consistent-archivelog-backup.rman script (Oracle)

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

Loading...