| Restore RMAN backup on different host [message #293572] |
Mon, 14 January 2008 02:32  |
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
|
Member |
|
|
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  |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
