Home » RDBMS Server » Backup & Recovery » Restore RMAN backup on different host
Restore RMAN backup on different host [message #293572] Mon, 14 January 2008 02:32 Go to next message
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 #293585 is a reply to message #293572] Mon, 14 January 2008 03:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button to verify.

For instance:
http://www.orafaq.com/forum/mv/msg/93999/287112/102589/#msg_287112

Regards
Michel
Re: Restore RMAN backup on different host [message #293958 is a reply to message #293572] Tue, 15 January 2008 14:33 Go to previous messageGo to next message
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 #294013 is a reply to message #293958] Wed, 16 January 2008 00:51 Go to previous messageGo to next message
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
Member

Hi ,

Thanks for the restoration steps ,

In our scenario we have the exiting target machine with different file system but OS and DB version is same as source, so is it possible to restore RMAN into different file system, then what will be the procedures.

Thanks
Asif
Re: Restore RMAN backup on different host [message #294017 is a reply to message #294013] Wed, 16 January 2008 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Those that are described in Database Backup and Recovery Basics and Database Backup and Recovery Advanced User's Guide

Regards
Michel

[Updated on: Wed, 16 January 2008 01:01]

Report message to a moderator

Re: Restore RMAN backup on different host [message #294186 is a reply to message #293572] Wed, 16 January 2008 13:53 Go to previous messageGo to next message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
I'm not sure about restoring to different file systems. Perhaps you could look into doing a copy with Rman or try creating the source file system names as symbolic linnks to the actual file systems.
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
Michel Cadot
Messages: 64152
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
Previous Topic: What are the minimums server specs to run a recovery catalog?
Next Topic: oracle hp-ux data to windows based oracle
Goto Forum:
  


Current Time: Sat Dec 10 16:27:49 CST 2016

Total time taken to generate the page: 0.04714 seconds