cancel
Showing results for 
Search instead for 
Did you mean: 

doing a RMAN BACKUP restore from a different master

PETERGE
Level 2

i know can do a file backup restore from a different master.
i know can do a rman backup restore to a different client with same server.

Now we want to build one DR site.
firstly, online rman backup oracle db to tape,
then send the tape to the DR site.
import the tape to DR master .

finally,  want to do the rman restore oracle db to new server.
is it possible (different master server, different media server, different client)  ?
if ok, is some need to attention, like dr master server name, client name?

Thansk a lot.
I am newer to NBU.


1 ACCEPTED SOLUTION

Accepted Solutions

Oddy
Level 5
Employee
Peterge,

Yes, it is possible to restore using different master,media and client.
For the master you can import media to get the the backup images to the new master.
On the new master you can specify which media server you want to use specifying,
FORCE_RESTORE_MEDIA_SERVER = <old media server> <new media server>

When you start the restore from the destination client in you DR site I would suggest to first restore the controlfile and then rest of the database. Here is an example restoring in an Unix environment, if you are using windows change path to C:\Program File,s\Veritas\Netbackup

Restore controlfile
i.e su - oracle user and run
/usr/openv/netbackup/bin/bplist -C <source client> -t 4 -l -R /
and take a note of the controlfile backup from the date you want to restore from. If you get a status 135, please
touch /usr/openv/netbackup/db/altnames/No.Restrictions
on the master server and try again.

Conned to rman on the destination DR oracle server,
$ORACLE_HOME/bin/rman target / nocatalog

run {
allocate channel ch00 'sbt_tape';
send 'NB_ORA_SERV=<master server>,NB_ORA_CLIENT=<source client>';
restore controlfile to '/tmp/controlfile.ctl' from '<backuppiece for controlfile from bplist output>';
release channel ch00;
}
run {
allocate channel ch00 'sbt_tape';
replicate controlfile from '/tmp/controlfile.ctl' ;
release channel ch00;
}

2.
run {
allocate channel ch00 'sbt_tape';
send NB_ORA_CLIENT=<source client>';
restore database;
recover database;
release channel ch00;
}

alter database open resetlogs;


I hope this helps.

/Oddy

View solution in original post

5 REPLIES 5

Will_Restore
Level 6
and then use the standard process for redirected restore

PETERGE
Level 2
Thanks a lot!

Oddy
Level 5
Employee
Peterge,

Yes, it is possible to restore using different master,media and client.
For the master you can import media to get the the backup images to the new master.
On the new master you can specify which media server you want to use specifying,
FORCE_RESTORE_MEDIA_SERVER = <old media server> <new media server>

When you start the restore from the destination client in you DR site I would suggest to first restore the controlfile and then rest of the database. Here is an example restoring in an Unix environment, if you are using windows change path to C:\Program File,s\Veritas\Netbackup

Restore controlfile
i.e su - oracle user and run
/usr/openv/netbackup/bin/bplist -C <source client> -t 4 -l -R /
and take a note of the controlfile backup from the date you want to restore from. If you get a status 135, please
touch /usr/openv/netbackup/db/altnames/No.Restrictions
on the master server and try again.

Conned to rman on the destination DR oracle server,
$ORACLE_HOME/bin/rman target / nocatalog

run {
allocate channel ch00 'sbt_tape';
send 'NB_ORA_SERV=<master server>,NB_ORA_CLIENT=<source client>';
restore controlfile to '/tmp/controlfile.ctl' from '<backuppiece for controlfile from bplist output>';
release channel ch00;
}
run {
allocate channel ch00 'sbt_tape';
replicate controlfile from '/tmp/controlfile.ctl' ;
release channel ch00;
}

2.
run {
allocate channel ch00 'sbt_tape';
send NB_ORA_CLIENT=<source client>';
restore database;
recover database;
release channel ch00;
}

alter database open resetlogs;


I hope this helps.

/Oddy

When you said : send 'NB_ORA_SERV=<master server>,NB_ORA_CLIENT=<source client>';

 

is <master server> the DR master server or the source master server that backed up the source client?

Marianne
Level 6
Partner    VIP    Accredited Certified
Best to start a new discussion as most of these users are no longer visiting this forum.
If images were imported, then the master will be the DR master.