OraFAQ Forum: Server Administration » Restore to diff box rman

Home » RDBMS Server » Server Administration » Restore to diff box rman

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore to diff box rman [message #163369]

Thu, 16 March 2006 07:43

kapil2005
Messages: 44
Registered: March 2005

Member

Here is the script i used to take the backup uring rman

connect catalog rman_92/backoffu2@RMAN_CATALOG
connect target /
run
{
allocate channel ch0 type 'sbt_tape';
allocate channel ch1 type 'sbt_tape';
backup database
format 'd%d_df_U%U_s%s_p%p'
include current controlfile
filesperset=8;

sql 'alter system archive log current';

backup
format '%d_al_U%U_s%s_p%p'
filesperset=12
(archivelog all);

backup
format '%d_cntl_U%U_s%S_p%p'
(current controlfile);

release channel ch0;
allocate channel ch0 type disk;
backup
format '/u06/app/oracle/admin/SIAT/siebel/rpsfiles/backup/%d_al_U%U_s%s_p%p'
filesperset=12
(archivelog until time 'sysdate-1'
delete input);

release channel ch0 ;
release channel ch1 ;
}
exit;

Now I need to restore and recover this database to a different location on different server. what should be my rman script?
Thank you all very much.

Report message to a moderator