I agree with Dave. It's probably not a good idea to delete your archived
redo logs after they've been backed up only once.

A better strategy might be to do a backup, then compress the redo logs that
were backed up successfully. The next time space falls below your
threshhold, do another backup then delete the compressed logs and compress
the uncompressed ones. That way you assure each file is backed up twice,
once uncompressed and again compressed.

For another level of safety, after each backup determine the tape(s) to
which the log files were written and either withdraw them from the jukebox
or mark them readonly. That way you force each backup to go to a different
physical tape, and avoid the tape failure problem that Dave pointed out.

Conrad Macina
Pfizer, Inc.



On Sat, 13 Mar 2004 05:34:03 -0500, Tarjei T. Jensen
<tarjei.jensen AT AKERKVAERNER DOT COM> wrote:

>Werth, Dave wrote:
>>Because we don't have enough room to keep all of the archive logs on-line
>>I've set up a cron job that checks every 10 minutes for file system space
>>where the archive logs are created and when it reaches a certain level it
>>starts a savegroup that back's up then deletes the archive logs.
>
>I used to compress the archive logs and keep them for a little while. We
>also did a cold backup of the database every night.
>
>I belive only doing a backup and then delete archive logs is foolhardy. If
>one tape goes bad, life will be VERY miserable. Disk IS cheap and it does
>not cost much to add a few disks to a server to store the archive logs
>until they are spread on so many tapes that there is no danger anymore.
>
>
>greetings,
>
>--
>Note: To sign off this list, send a "signoff networker" command via email
>to listserv AT listmail.temple DOT edu or visit the list's Web site at
>http://listmail.temple.edu/archives/networker.html where you can
>also view and post messages to the list.
>=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=