Urgent: Restore a database with the RMAN full backup of another database on disk

[Lily_Liu_2004]

DBAs.,

I have an urgent task.
The task is refresh the db2 with db1., who are on different box.
The db2 was completely wiped off and in in nomount mode.

Originally I used the following way to do:
1) made a full backup of dbq1 to tape
2) duplicate

The problem is that the rman backup on tape of db1 cannot be accessed by db2.
The UNIX admin needs to do something. But all of them are gone.

The option left for me is :
I1) I have a full rman backup of db1 on disk on the box where db1 resides

Is the following method doable:
1) ftp the disk rman backup of db1 to db2 box
2) restore the db2 using the rman backup of db1

If it is doable, would you please outline the procedure?

If it is not donable, what is the best way for me to finish this task?

Thank you very much!

Lily

[ams-jamali]

Try this.,

you can use ftp (or) scp

eg:

scp /mnt/db/disk1 orcl@ :/mnt/db/disk2

Restore and recover the whole database
RMAN> STARTUP FORCE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;

[davey23uk]

you say it doesnt work - but dont say what the error is

[Lily_Liu_2004]

Thanks for replies.

The error message is as follows:

ORA-19870: error reading backup piece FULL_MKEXQ_3mimfnu8
ORA-19507: failed to retrieve sequential file, handle="FULL_MKEXQ_3mimfnu8", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
ORA-19870: error reading backup piece FULL_MKEXQ_3kimfnu8
ORA-19507: failed to retrieve sequential file, handle="FULL_MKEXQ_3kimfnu8", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
ORA-19870: error reading backup piece FULL_MKEXQ_3limfnu8
ORA-19507: failed to retrieve sequential file, handle="FULL_MKEXQ_3limfnu8", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file

[Lily_Liu_2004]

My case is like this:

1.Source db1 on client1, target db2 on client2, both use rman to backup to tape using netbackup, The netbackup sever is the same server.

2.On source box the oracle OS owner is different from the target box.
Here, using the ora as the oracle’s os users.

[Lily_Liu_2004]

Anyone has the experience with using rman duplicate function to
refresh one db to another db in new host with netbackup as media management?

If so, would you please share the experience how to set up this
whatever fom dba side or netbackup team side?

Thanks,

Lily

[waitecj]

As long as you can connect to the target, catalog and auxiliary at the same time, the process is fairly straight forward.