Hi Robyn,
Check the log_checkpoint_interval setting in your init.ora file. It should
be set very high to make sure your logs are filling up completly. Also, I
think more logs of smaller size are better in such cases. It keeps
recovery to a managable level.
- rsands_at_lendleaserei.com wrote:
>
>
> Listers,
>
> What's the best approach to deal with the archiver not keeping up with
> the redo
> log switches? Currently, redo logs are 20 MB, originally had four
> groups. We
> have one process that runs twice a day and results in one or two 'cannot
> allocate new log' errors. The switch occurs seconds later without
> causing the
> update to fail, and the process completes in less than 10 minutes.
> Tried
> increasing the size of the logs, no improvement. Added two more log
> groups,
> errors stopped for a time, but then reoccurred. This process populates
> a
> denormalized table for queries, and the problem began after additional
> data was
> added to the base tables. Typically, I see only 4 to 12 switches within
> a 24
> hour period, so I'm not sure if I should continue to added more groups
> or
> increase the size. If I increase the size, should I worry about
> checkpoints
> occurring too infrequently? (Only occur at log switches now). Both
> copies of
> the redo logs and the archived redo logs are all on separate disks.
>
> Robyn
>
> Lend Lease REI
> Atlanta, GA
>
>
> --
> Author:
> INET: rsands_at_lendleaserei.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
Received on Mon Jun 12 2000 - 13:25:54 CDT
