Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can Log Files Be Archived To The Bit Bucket?

Re: Can Log Files Be Archived To The Bit Bucket?

From: Charles Schultz <>
Date: Thu, 5 Apr 2007 15:24:28 -0500
Message-ID: <>

Curious, wouldn't it be less of a kludge to simply put this in cron: * * * * * find /archive/log/destination -mmin +1 -exec rm {} \; ## add appropriate depth flags if desired

Guess that depends on what definition you use for "kludge". =) You could also have rman handle your archive logs rather handily.

On 4/5/07, <> wrote:
> 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
> anywhere.
> 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:
> --

Charles Schultz

Received on Thu Apr 05 2007 - 15:24:28 CDT

Original text of this message