Monday, October 12, 2009

DP RMAN Script for Archivelog backup

DP-RMAN Script for Archivelog backup

run
{allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Database,OB2BARLIST=Server_Database_RMAN_ARC_ST_RA)'; sql 'alter system switch logfile';
crosscheck archivelog all;
backup format 'Server_Database_RMAN_ARC_ST_RA
.arc'
archivelog all delete input;
}

*Crosscheck archivelog all was added to avoid backup failure due to missing archive files.

No comments:

Post a Comment