Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Sym BE how to config only delete oracle two days ago archivelogs

Created: 06 May 2013 • Updated: 07 May 2013 | 1 comment

HI,

I check the oracle backup log found sym BE delete all of archivelogs.

Anyone known how to modify script to only delete tow days ago logs,so tks.

RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=XXX.XXX.XXX.XXX,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={E5800D96-9710-43B7-896B-4A47290C5B8F},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\XXX.XXX.XXX.XXX\DBSID';
 BACKUP
     INCREMENTAL LEVEL=0
     FORMAT 'BE_U'
     DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP DELETE INPUT;
 BACKUP CURRENT CONTROLFILE
     FORMAT 'BE_U';
 
 RELEASE CHANNEL ch0;
 }

.......

channel ch0: deleting archive log(s)
archive log filename=T:\ORACLE\ARCHIVELOG\ARC62401_0697130604.001 recid=62395 stamp=814695654
archive log filename=T:\ORACLE\ARCHIVELOG\ARC62402_0697130604.001 recid=62396 stamp=814696899
archive log filename=T:\ORACLE\ARCHIVELOG\ARC62403_0697130604.001 recid=62397 stamp=814697481
archive log filename=T:\ORACLE\ARCHIVELOG\ARC62404_0697130604.001 recid=62398 stamp=814698032
archive log filename=T:\ORACLE\ARCHIVELOG\ARC62405_0697130604.001 recid=62399 stamp=814698925
archive log filename=T:\ORACLE\ARCHIVELOG\ARC62406_0697130604.001 recid=62400 stamp=814699540
........
 

Operating Systems:

Comments 1 CommentJump to latest comment