We have 5 redo logs each of 150M in size and there are 2 members in
each group. We have been constantly getting the following error
message:
Checkpoint not complete
Current log# 2 seq# 127927 mem# 0: /u01/NI00/redo_tbs/redo_2a.log
Current log# 2 seq# 127927 mem# 1: /u03/NI00/redo_tbs/redo_2b.log

What can we do to get rid of this checkpoint error? Should we increase
the size of my redo logs?

Thanks in advance for your help.

Michael

On Sep 21, 8:10*am, Michael <mbulch... (AT) gmail (DOT) com> wrote:
That is one way, presuming you're not executing regularly scheduled
checkpoints; check the setting on log_checkpoint_interval to see if it
is non-zero. Another way to address this is to add one or more log
groups as the issue is usually caused when Oracle has cycled through
the log groups and attempts to reuse a group and the checkpoint is
still in progress.


David Fitzjarrell.

On Sep 21, 9:50*am, ddf <orat... (AT) msn (DOT) com> wrote:
The "Checkpoint not complete" is a fairly reliable indicatior that
your online redo logs are size too small. In the absence of the use
of Data Guard in a log shipping mode you should likely resize your
online redo logs. you can check this by reviewing how many are
created and how much time passes between log switches using the alert
log or the v$archived_log view.

Generally speaking you probably want only 24 - 48 redo log switches
per day. (one every 30 - 60 minutes on average).

HTH -- Mark D Powell --