Re: archive log files

What we do is copy files more than a day old to another directory and compress them every night. We have a special tape for those logs that also runs a little bit later, and then they are deleted after four days. This way, we have plenty of space, and all of our logs for the last two weeks are either on tape, or on the box. The filesystem is mirrored as well. We've never needed 2 weeks of archive logs but we have needed a couple of days. By all means.. make absolutely sure you can get your old archive logs.. if there's one thing about a recovery that can be a real show-stopper, it's a missing archive log. If you're missing one, there's absolutely nothing you can do to recover past that point.. Whatever strategy you use, test,test,test.. make sure you can get those logs..

• Dc.

On Fri, 28 Apr 2000 20:32:43 GMT, insane808_at_my-deja.com wrote:

>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 Sat Apr 29 2000 - 00:00:00 CDT