RMAN Full Database backup script

This document describes how to take full database backup using RMAN(Recovery Manager).
First will create rmanfullbackup.sh file/script to run from OS level. Inturn this script
will call another script/CMDfile named rmanfullbk.rmn to take full database backup using RMAN.



vi rmanfullbackup.sh

#!/bin/sh
ORACLE_SID=testinguatdb; export ORACLE_SID
ORACLE_HOME=/u01/app/11.2.0/dbhome_1;
export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin export PATH
DD=`date +%d%h`
LNAME=/u01/createDB/scripts/${DD}rman_backup.log
###############DELETE BACKUP ################
#rm /ora_backup/Rman_Backup_DB_File/DB_RMAN_PLI*
#rm /ora_backup/Rman_Backup_DB_Arch/DB_ARCH_PLI*


rman target sys/password nocatalog cmdfile '/u01/createDB/scripts/rmanfullbk.rmn' log $LNAME


vi rmanfullbk.rmn

crosscheck archivelog all;
crosscheck backup;
delete expired backup;
delete force noprompt expired backup;
delete expired archivelog all;


run

{

allocate channel c1 device type disk format '/u01/createDB/DB_RMAN_%d_%u_%s_%p';

allocate channel c2 device type disk format '/u01/createDB/DB_RMAN_%d_%u_%s_%p';

allocate channel c3 device type disk format '/u01/createDB/DB_RMAN_%d_%u_%s_%p';

allocate channel c4 device type disk format '/u01/createDB/DB_RMAN_%d_%u_%s_%p';

BACKUP database include current controlfile;

release channel c1;

release channel c2;

release channel c3;

release channel c4;

}

run

{

allocate channel c1 device type disk format '/u01/createDB/DB_ARCH_%d_%u_%s_arc';

allocate channel c2 device type disk format '/u01/createDB/DB_ARCH_%d_%u_%s_arc';

allocate channel c3 device type disk format '/u01/createDB/DB_ARCH_%d_%u_%s_arc';

allocate channel c4 device type disk format '/u01/createDB/DB_ARCH_%d_%u_%s_arc';

sql 'alter system switch logfile';

sql 'alter system archive log current';

BACKUP archivelog all ;


#delete input;

release channel c1;

release channel c2;

release channel c3;

release channel c4;

}
crosscheck archivelog all;