Oracle Backup Restore to a different Server

[muneer alam]

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.

[INH]

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