Re: deleting archive logs after successful backup with backup exec oracle agent

From: Brian E Dick <bdick_at_cox.net>
Date: Wed, 15 Jan 2003 21:21:26 GMT
Message-ID: <qhkV9.77640$t06.3613532_at_news2.east.cox.net>


I said offline. That could be many things besides tape, such as NFS, FTP, etc. I use CD-RW for a small database I support.

"Frank" <fvanbortel_at_netscape.net> wrote in message news:3E245BE4.80402_at_netscape.net...
> Brian E Dick wrote:
> > You should keep an online copy of the archive log files created since
 your
> > last database backup. This will speed up recovery. Older archive log
 files
> > that have been copied to offline storage may be deleted with a script.
>
> Tape = rust on wheels. I would not trust a single copy on tape
> of my archived redo logs.
>
>
> I use
> > the following JScript to delete archive log files older than thirty
 days.
> <snip script>
>
> Meaning you will end with 30 tapes containing the same archived log
> file. Bound to be a readable copy between one of 'em!
> I go for 4 copies; 2 uncompressed, 2 compressed in a directory
> structure: ../arch, ../arch/old, ../arch/older, ../arch/oldest
>
> Frank
>
Received on Wed Jan 15 2003 - 22:21:26 CET

Original text of this message