Restore RMAN backup on different host [message #293572] |
Mon, 14 January 2008 02:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dbasif
Messages: 35 Registered: March 2006 Location: Bangalore, India
|
Member |
![dbasif%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi All,
i have come across this scenario, where i have to restore the RMAN backup of prod db to different host with same configuration and db version.
please help with the prerequisite required and steps to implement.
backup script used as follows :--
#!/bin/ksh
export ORACLE_SID=dmop
export ORACLE_HOME=/local0/app/oracle/product/10.2
export DATE=$(date +%Y%m%d%H%M%S)
$ORACLE_HOME/bin/rman log=/home/oracle/rman/DMOPrman_control$DATE.log
connect target /
run {
allocate channel d1 type disk;
backup full
(database format '/dmoprman/dmopdevfull_%U');
backup current controlfile format '/dmoprman/curr_control_%U';
release channel d1;
}
run {
allocate channel d1 type disk ;
backup
archivelog from time '(sysdate-30/1440)'
format '/dmoprman/arch_%d.%u';
release channel d1;
}
exit
|
|
|
|
Re: Restore RMAN backup on different host [message #293958 is a reply to message #293572] |
Tue, 15 January 2008 14:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dzt52r
Messages: 19 Registered: July 2007 Location: PA
|
Junior Member |
|
|
you should have RDBMS software backed up with OS backups.
restore RDBMS software to new server.
create all mount points, directories, and sub-directories required for all database files, including logs, init parms and archived redo logs.
you will need the dbid of the target database and some init parms to startup target database.
export ORACLE_SID=????
here is a copy of a script I use for DR drills at a testing facility. This restores from tape to the latest backup. Our media manager is Netbackup. Modify it as needed. It does have the rman steps.
#
# Restore and recover the CTS database
#
set dbid = ????????? ;
connect catalog uid/pwd@rman ;
connect target uid/pwd;
startup nomount pfile=/export/home/oracle/DisasterRecovery/inittarg.ora ;
run {
allocate channel t1 type 'sbt_tape' ;
send 'NB_ORA_POLICY=ora_targ, NB_ORA_CLIENT=oratarg, NB_ORA_SERV=netb' ;
restore spfile to '/u02/targ/oraenv/pfile/spfiletarg.ora' ;
}
shutdown immediate ;
host 'echo "spfile=/u02/targ/oraenv/pfile/spfiletarg.ora" > /u02/targ/o
raenv/pfile/inittarg.ora' ;
startup nomount pfile=/u02/targ/oraenv/pfile/inittarg.ora ;
run {
allocate channel t1 type 'sbt_tape' ;
send 'NB_ORA_POLICY=ora_targ, NB_ORA_CLIENT=oratarg, NB_ORA_SERV=netb' ;
restore controlfile ;
}
alter database mount ;
run {
allocate channel t1 type 'sbt_tape' ;
send 'NB_ORA_POLICY=ora_targ, NB_ORA_CLIENT=oratarg, NB_ORA_SERV=netb' ;
restore database ;
}
run {
allocate channel t1 type 'sbt_tape' ;
send 'NB_ORA_POLICY=ora_targ, NB_ORA_CLIENT=oratarg, NB_ORA_SERV=netb' ;
recover database ;
}
alter database open resetlogs ;
|
|
|
|
|
|
Re: Restore RMAN backup on different host [message #294189 is a reply to message #294186] |
Wed, 16 January 2008 14:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | I'm not sure about restoring to different file systems. Perhaps
|
Yes it is possible and explained in the documentation.
Unless you are talking about different file system TYPE.
Regards
Michel
|
|
|