consistent-archivelog-backup.rman script (Oracle)

Updated

export ORACLE_HOME=/oracle/oracle11g

$ORACLE_HOME/bin/rman target sys/sys@VMFSDB catalog vmfsdb/shankar@CATDB <<EOF1

spool log to $ORACLE_HOME/DBA_SCRIPTS/archivelog-backup.log

run

{

allocate channel ch1 type 'sbt_tape'

PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so,ENV=(CvOraSID=VMFSDB,CvClientName=VMOracleVMFS,CvInstanceName=Instance001),BLKSIZE=262144";

sql 'alter system archive log current';

backup filesperset 32

(archivelog all);

backup current controlfile ;

}

spool off

EOF1