Restoring backup on remote system

[Maarten van Maanen]

We have a HP9000 K370 and D370 with both HP-UX 11. The K370 is running an Oracle database on a HP 12H. On the D370 I have added 5 9Gb disks in a external SCSI-box, connected to the SE-SCSI connector on the D370.
Now I have to get a copy of the Oracle database from the K370 on the D370. I am using fbackup to do my backups on the K370. Can I somehow do a restore from the DLT in the K370 and redirect the data on to the disks in the D370 ?? If not, can I do a quick copy from the K370 to the D370, keeping the complete directory-structure intact. If either possibility exists, it would save me an awful lot of time.

[melvyn burnard]

fbackup/frecover are designed for backup/recovery across the netwrk.
If you read the man page for frecover, you will see how it can be used by specifying the device to recover from as hostname:/device/file/needed

e.g. snoopy:/dev/rmt/0m

The host tha thas the backup device will need to have an entry in .rhosts for the node on which you will run the recovery.

[MARTINACHE]

Hi,

There are other way to do this :

1) export/import

- do a full export of yous database
- ftp, rcp of nfs the export
- import your database

2) copy via nfs

- shutdown your DB
- export destination filesystems via nfs
- mount these filesystems
- cp your datafiles

Regards,

Patrice.

[Stefan Schulz]

Pretty easy. Goto SAM / backup and recovery / intaractiv backup. There choose Actions / Use remote backupdevice (or so).

You can specify the remote machine, the device and which files you want to restore.

Regards Stefan

[Joseph C. Denman]

To do the import, you must have a database created on the other system. This is what I normally do when I migrate a database.

1. query the database for files with svrmgrl and spool to a file;
a. spool /tmp/dbfiles
b. select file_name from dba_data_files;
c. select member from v$logfile;
d. select name from v$controlfile;
e. spool off
2. shutdown the database
3. backup the files to a backup dir.
a. num=0
cat /tmp/dbfiles | grep / | while read line
do
num=`expr ${num} + 1`
tar cvpf /backup/${num}.tar ${line}
done

b. copy your init file,trace files, and alertlog to the /backup dir.
4. Zip them
a. cd /backup
b. /usr/contrib/bin/gzip *
5. ftp them to the other box
6. get on the other box and unzip them.
a. cd /the/place/you/put/them
b. /usr/contrib/bin/gunzip *
7. move the init file,trace file, and alert log into place
8. untar the files
tar xvpf *.tar

This will make an exact duplicate of the current system...file structure and all.

...jcd...