[oracle@DRDB1 restore_script]$ cat restore run { allocate channel t11 type 'SBT_TAPE'; allocate channel t21 type 'SBT_TAPE'; send channel t11 'NSR_ENV=(NSR_SERVER=backup_db,NSR_CLIENT=db1)'; send channel t21 'NSR_ENV=(NSR_SERVER=backup_db,NSR_CLIENT=db1)'; restore database; release channel t11; release channel t21; } [oracle@DRDB1 restore_script]$ backup script: [root@db1 scripts]# cat rman_hot_KAU11PUB1_level0.rcv connect target sys/oracle@KAU11PUB1 run { # Hot database level 0 whole backup allocate channel c1 type SBT_TAPE format 'hotbackup_%d_%U_%p_%c'; allocate channel c2 type SBT_TAPE format 'hotbackup_%d_%U_%p_%c'; allocate channel c3 type SBT_TAPE format 'hotbackup_%d_%U_%p_%c'; allocate channel c4 type SBT_TAPE format 'hotbackup_%d_%U_%p_%c'; crosscheck archivelog all; backup incremental level 0 tag=Weekly_Full_Backup filesperset 8 diskratio=0 format '_%t_%s_%p_%d' (database include current controlfile); sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system archive log current'; backup (archivelog from time 'trunc(sysdate-2)' until time 'sysdate'); delete archivelog all completed before 'trunc(sysdate)'; backup current controlfile tag ='Second Cntrl_File Bkp'; release channel c1; release channel c2; release channel c3; release channel c4; } [root@db1 scripts]# [root@db1 scripts]# cat rman_hot_KAU11PUB1_level1.rcv connect target sys/oracle@KAU11PUB1 run { # Hot database level 1 backup allocate channel c1 type SBT_TAPE format 'hotbackup_%d_%U_%p_%c'; allocate channel c2 type SBT_TAPE format 'hotbackup_%d_%U_%p_%c'; allocate channel c3 type SBT_TAPE format 'hotbackup_%d_%U_%p_%c'; allocate channel c4 type SBT_TAPE format 'hotbackup_%d_%U_%p_%c'; crosscheck archivelog all; backup incremental level 1 tag=Daily_Level1_Backup filesperset 8 diskratio=0 format '_%t_%s_%p_%d' (database include current controlfile); sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system archive log current'; backup (archivelog from time 'trunc(sysdate-2)' until time 'sysdate'); delete archivelog all completed before 'trunc(sysdate)'; backup current controlfile tag ='Second Cntrl_File Bkp'; release channel c1; release channel c2; release channel c3; release channel c4; } [root@db1 scripts]#