ZT：CommVault备份脚本

AIX 5.3、Oracle 9.2.0.8

******DATA FILE/CONTROL FILE/SPFILE BACKUP SCRIPT******
run {
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.a(shr.o),BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine=BACKUP -jm 13 -a 2:21 -cl 6 -ins 5 -at 22 -j 0 -bal 1 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -data -PREVIEW -cn zydb_per -vm Instance001)" TRACE 0;
setlimit channel ch1 maxopenfiles 8;
backup
    incremental level = 0
    filesperset = 32
    database
    include current controlfile  ;
}

******LOGS BACKUP SCRIPT******
run {
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.a(shr.o),BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine=BACKUP -jm 13 -a 2:21 -cl 6 -ins 5 -at 22 -j 0 -bal 1 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -logs -PREVIEW -cn zydb_per -vm Instance001)" TRACE 0;
setlimit channel ch1 maxopenfiles 8;
sql "alter system archive log current";
backup
     filesperset = 32
     (archivelog  all   delete input );
}

******DATA FILE/CONTROL FILE/SPFILE BACKUP SCRIPT******
run {
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.a(shr.o),BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine=BACKUP -jm 13 -a 2:21 -cl 6 -ins 5 -at 22 -j 0 -bal 2 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -data -PREVIEW -cn zydb_per -vm Instance001)" TRACE 0;
setlimit channel ch1 maxopenfiles 8;
backup
     incremental level = 1
     filesperset = 32
     database
     include current controlfile  ;
}

******LOGS BACKUP SCRIPT******
run {
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.a(shr.o),BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine=BACKUP -jm 13 -a 2:21 -cl 6 -ins 5 -at 22 -j 0 -bal 2 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -logs -PREVIEW -cn zydb_per -vm Instance001)" TRACE 0;
setlimit channel ch1 maxopenfiles 8;
sql "alter system archive log current";
backup
     filesperset = 32
     (archivelog  all   delete input );
}

run {
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.a(shr.o),BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine=BACKUP -jm 45 -a 2:21 -cl 6 -ins 5 -at 22 -j 6127 -jt 6127:3:1 -bal 1 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -data -ma 3 -cn zydb_per -vm Instance001)" TRACE 0;
setlimit channel ch1 maxopenfiles 8;
backup
     incremental level = 0
     filesperset = 32
     database
     include current controlfile  ;
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/5359/viewspace-714588/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/5359/viewspace-714588/