General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Backup Restore to a different Server

muneer alam
Occasional Contributor

Oracle Backup Restore to a different Server

Hi,

I want to restore the production RMAN backups taken via HP data protector to a Test server.

Production Server - oraprd.rg.com
HP DP Management Server - hpdata.rg.com
Test Server - oratest.rg.com

Can someone please let me know what should be the recover command to be used at RMAN prompt.

Thanks.
1 REPLY
INH
Regular Advisor

Re: Oracle Backup Restore to a different Server

Here is an example.


rman target / catalog DB_name_to be recovred/rcat10g@rcat10g
run{
allocate channel 'Ponline9i_oratest.rg.com_DB_name_to be recovred_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DB_name_to be recovred,OB2BARLIST=C_Ponline9i_oratest.rg.com_DB_name_to be recovred)';
allocate channel 'Ponline9i_oratest.rg.com_DB_name_to be recovred_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DB_name_to be recovred,OB2BARLIST=C_Ponline9i_oratest.rg.com_DB_name_to be recovred)';
allocate channel 'Ponline9i_oratest.rg.com_DB_name_to be recovred_3' type 'sbt_tape'
restore database;
recover database;
};


Here rcat10g is catlog DB

Regards
Knowledge is power