Re: batch job to automatically delete old archive files under NT?

TerrY:

Which ones and how do you use them? Thanks.

David Spaisman

Terry Dykstra wrote:

> I use some Unix utilities for NT to find archive logs older than x days and
> delete them.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
>
> Joe Long wrote in message <37FE09A5.BE8FE709_at_cticallcenter.com>...
> >I use a batch file job in the NT Scheduler (c:\winnt\tasks) to both do
> >my backup and delete the old files.
> >Here is the contents of the batch file:
> >CALL DEL e:\DB\backup\*.1
> >CALL DEL e:\DB\backup\*.ora
> >CALL DEL e:\DB\backup\*.trc
> >CALL DEL k:\DB\backup\*.1
> >CALL DEL k:\DB\backup\*.ora
> >CALL DEL k:\DB\backup\*.trc
> >CALL MOVE e:\DB\files\archive\*.1 e:\DB\backup\
> >CALL MOVE k:\DB\files\archive\*.1 k:\DB\backup\
> >CALL SET ORACLE_SID=<OurSid>
> >CALL SVRMGR30.EXE COMMAND="@c:\db_admin\BACKUP.SQL"
> >CALL COPY k:\DB\backup\*.ora e:\DB\backup\
> >CALL COPY k:\DB\files\trace\*.trc e:\DB\backup\
> >CALL COPY k:\DB\files\trace\*.trc k:\DB\backup\
> >CALL COPY e:\DB\files\archive\*.1 e:\DB\backup\
> >CALL COPY k:\DB\files\archive\*.1 k:\DB\backup\
> >
> >First I clear out all of the backed up files from yesterday (which have
> >already been written to tape) from the E: and K: drives (I believe in
> >having duplicates of everything). Then I move todays archived log files
> >to the backup directory. Next I run my hot backup script, backing up
> >all data files and the control file (including to trace) to one of the
> >drives. I then copy those files to the other drive again for
> >duplication. Next I copy my trace files to both backup directories.
> >Finally, I copy any new archived logs into the backup directories so I
> >have any logs that were in use when I started the backup procedure. I
> >know it may seem a little anal retentive, but it has really made my life
> >easier during problems to have everything, and have it in two seperate
> >locations. And I just schedule the whole thing through NTs scheduler.
> >If you are not familiar with it, just go to c:\winnt\tasks and double
> >click on 'Add Scheduled Task'. Hope it helps.
> >
> >Joe Long
> >
> >David Spaisman wrote:
> >>
> >> Hello:
> >>
> >> I am working on an application under Oracle 8.0.4 under NT. We are
> >> testing hot backups and rather than manually go to the archive directory
> >> and delete out-of-date archive logs manually, I was wondering if
> >> any one has or uses a batch job that delete old archive log files based
> >> on a certain number of days?
> >>
> >> Thanks.
> >> .
> >>
> >> David Spaisman
Received on Mon Oct 11 1999 - 23:41:58 CDT