Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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