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

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, jim.silverman_at_thomson.com <jim.silverman_at_thomson.com> 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: jim.silverman_at_thomson.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l