Can Log Files Be Archived To The Bit Bucket?

  • From: <jim.silverman@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 5 Apr 2007 15:11:25 -0400

We manage several non-production 10g databases that are currently shut
down and backed up cold every weekend.  We'd like to begin backing them
up using rman, both to avoid these weekly shutdowns and to gain the
ability to recover to a time within 24 hours of a failure.  Our plan is
to perform Level-0 incremental backups on the weekend, and Level-1s each
night during the week; we can live with an incomplete recovery through
the most recent Level-1 available.

To enable this, we'll need to convert the databases to ARCHIVELOG mode.
However, we don't want to have to deal with managing archivelog space,
since we often generate a lot of redo that, per the recovery scenario
described above, will never be applied.  As a result, we'd like to set
up our environment such that the archiver's output is not saved

We tried setting LOG_ARCHIVE_DEST_1 to "LOCATION=/dev/null", and while
Oracle didn't complain when we started the instance, the archiver wasn't
very happy when it woke up.  We've also considered creating a small
filesystem to hold the log files and firing up a cron job to
periodically clear it out, but we'd rather avoid building such a kludge
that would accomplish nothing useful while adding another item to our
list of maintenance tasks.

Thanks in advance for any suggestions.
Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone:   734-669-7641
FAX:            734-930-7611
E-Mail:         jim.silverman@xxxxxxxxxxx


Other related posts: