Re: Archive Log Creation Rate??

"Charles Davis" <cdavis10717_at_comcast.net> wrote in message news:<a-GdnTG0_8tG0eaiU-KYuA_at_comcast.com>...
> Hi, all.
>
> I am looking for opinions about sizing ReDo logs vs the rate at which
> Archive Logs are created.
>
> Oracle suggests archiving once every 20-30 minutes.
>
> Others suggest archiving more frequently to minimize potential data loss and
> for a shorter recovery/warm start when reading the most recent archive log.
>
> Either approach affects the ReDo sizes specified for the average database
> taking into account the usual logged update activity.
>
> I was cutting a 200MB archive log every 5 minutes, then I increased ReDo to
> 1GB to archive less frequently, more in line with what Oracle suggested.
>
> What's your opinion or experience? I'd love to hear it.
>
> Thanks.
>
> Charles

Besides what everyone else said, the granularity of restore should depend on business requirements and explicit management decision.

jg

--
@home.com is bogus.
live update death, news at 11.