Re: archivelog v/s nonarchivelog

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 7 Aug 2003 15:30:35 -0700
Message-ID: <1ac7c7b3.0308071430.7a56b691@posting.google.com>

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F32540A.FDD2F82E_at_remove_spam.peasland.com>...
> > if the size and number of online redo logs is such that they are not
> > cycled during the day (since the last hot backup), one could
> > potentially recover up to the last transaction, applying the (stale)
> > online redo logs.
>
> I know that it works this way, but is this a suggestion to size the
> online redo logs so that they don't switch during the day?
>
> Cheers,
> Brian

:)
no.
I was just kicking around the idea that there would be a sufficient number of log groups that they would not be overwritten during the course of the day.
I was not making any recommendations whatsoever.

hourly log switches is usually fine with me. multiplexed redo logs on separate mount points lowers your blood pressure by 5 points.

Paul Received on Thu Aug 07 2003 - 17:30:35 CDT