RMAN Script: Cumulative level 2 backup

[ call_dbbkup_cm2.scp]

#!/bin/ksh

export ORACLE_HOME="/u01/app/oracle/product/10.2.0"

export ORACLE_SID="omr"

PATH=$PATH:$ORACLE_HOME/bin

echo rman backup cm level1 for CATDB started `date` >> /u07/catdb/rmanbkup.log

rman target sys/password@omr catalog rman/rman@catdb cmdfile='/u04/catdb/scripts/dbbkup_cm1.scp'

echo rman backup cm level0 for CATDB ended `date` >> /u07/catdb/rmanbkup.log

exit

[dbbkup_cm2.scp]

run

{

allocate channel c1 type disk;

backup incremental level 2 cumulative

        tag omr_cm2

        format '/u10/catdb/backup/cm2_%d_%s_%p_%t'

        (database);

release channel c1;

#backing up controlfile to the specified destination keeping autobakup copy

configure controlfile autobackup format for device type disk to '/u10/catdb/back

up/auto_cntrl_%F';

configure controlfile autobackup on;

#backup up archivelog files

allocate channel c2 type disk;

backup

format '/u10/catdb/backup/cm2_%d_%s_%p_%t'

(archivelog all);

release channel c2;

}