DP rman backup scripts

備份archive log script

注意，備份archive log可以刪除上一次的，而且還可以備份controlfile.

run {
allocate channel 'dev_0' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=glscmb2b,OB2BARLIST=glscmb2b_73_arch)';
allocate channel 'dev_1' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=glscmb2b,OB2BARLIST=glscmb2b_73_arch)';
allocate channel 'dev_2' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=glscmb2b,OB2BARLIST=glscmb2b_73_arch)';
allocate channel 'dev_3' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=glscmb2b,OB2BARLIST=glscmb2b_73_arch)';
crosscheck archivelog all;
backup
 format 'glscmb2b_73_arch.dbf'
 archivelog all;
delete expired archivelog all;
delete archivelog until time 'sysdate - 2';
backup
 format 'glscmb2b_73_arch.dbf'
 current controlfile;
}

備份full db script

注意，備份full db可以刪除上一次的archive log.

run {
allocate channel 'dev_0' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=glscmb2b,OB2BARLIST=glscmb2b_73_full)';
allocate channel 'dev_1' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=glscmb2b,OB2BARLIST=glscmb2b_73_full)';
allocate channel 'dev_2' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=glscmb2b,OB2BARLIST=glscmb2b_73_full)';
allocate channel 'dev_3' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=glscmb2b,OB2BARLIST=glscmb2b_73_full)';
backup incremental level
 format 'glscmb2b_73_full.dbf'
 database;
crosscheck archivelog all;
backup
 format 'glscmb2b_73_full.dbf'
 archivelog all;
delete expired archivelog all;
delete archivelog until time 'sysdate - 1';
backup
 format 'glscmb2b_73_full.dbf'
 current controlfile;
}

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23757700/viewspace-723525/，如需轉載，請註明出處，否則將追究法律責任。