# 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...