Home » RDBMS Server » Backup & Recovery » Restore database from another server (Oracle database 10.2.0.4.0, Linux)
Restore database from another server [message #531271] Mon, 14 November 2011 20:07 Go to next message
User01
Messages: 9
Registered: October 2011
Location: California
Junior Member
Hi,

I have taken cold back-up of a complete database using below rcv from a server.
RMAN>
connect target /
run{
set command id to 'bkp_EMCPROD_db';
allocate channel c1 type 'sbt_tape' parms="BLKSIZE=1048576, ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
backup current controlfile format 'ct_t%t_T%T_d%d_s%s.ctl';
backup database format 'db_t%t_T%T_d%d_s%s_p%p.db';
backup current controlfile format 'ct_t%t_T%T_d%d_s%s.ctl';
release channel c1;
}

I need to restore this back-up on another server of the same Database Name. Below is the rcv which my sr. dba asked me to look into for the restore. Can you please explain me if this script works.

/* From the new server to restore the back-up */

RMAN>
connect target "rman/xxxxx@emcprod"
connect auxiliary /
run {
set until time "to_date('Nov 03 2011 19:00:00','Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel c1 type 'sbt_tape' parms="ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.sacsun8.opt)";
restore database;
}

Could you please explain me how this works, as am trying to learn things.

Thanks



Re: Restore database from another server [message #531298 is a reply to message #531271] Tue, 15 November 2011 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which part don't you understand?

Regards
Michel
Re: Restore database from another server [message #531380 is a reply to message #531298] Tue, 15 November 2011 12:21 Go to previous messageGo to next message
User01
Messages: 9
Registered: October 2011
Location: California
Junior Member
Thanks for the response Michel. I would like to know, whether I would be able to do that kind of restore into the new Server from the old server where the backup taken connecting to target.
Re: Restore database from another server [message #533430 is a reply to message #531380] Wed, 30 November 2011 00:09 Go to previous message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

You can check my video tutorial to see how it works:

RMAN Video Tutorial series Performing Disaster Recovery with RMAN
http://kamranagayev.com/2010/03/29/rman-video-tutorial-series-performing-disaster-recovery-with-rman/
Previous Topic: Manual cloning of oracle 10g database
Next Topic: rman crosscheck (tape)
Goto Forum:
  


Current Time: Thu Mar 28 11:44:33 CDT 2024