Re: archive log files

Once they have been backed up to tape, you can delete them - as long as you aren't trying to delete a log file while the arch process is copying it (theoretically you shouldn't be able to) it won't affect the database instance at all. If you need some of the deleted log files for recovery, just restore them from tape. A good strategy would be to keep all the log files created since the start of your last complete physical backup on disk, since these are the ones that will most likely be needed for a recovery.

HTH,
Andy
<insane808_at_my-deja.com> wrote in message news:8ecsha$mn1$1_at_nnrp1.deja.com...
> On one of the 8.1.6 databases I'm running I have
> archive log mode running. Its on a wintoy NT box.
> The problem is that the archive destination dir.
> is getting very large in size. There is a fair
> amount of dml being run on this instance. What is
> the easiest way to remove the log files. The box
> is tape backed up cold each night. Can I simply
> just delete the logs or will this screw up the
> database. I want to keep about 2 days worth of
> log files on the machine for backup reasons. Any
> info would be greatly appreciated.
>
> Thanx
> Jeff
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Apr 28 2000 - 00:00:00 CDT