Re: CHECKPOINT NOT COMPLETE
From: ddf <oratune_at_msn.com>
Date: Mon, 21 Sep 2009 06:50:45 -0700 (PDT)
Message-ID: <fd01dcb2-9c15-442e-acd0-2c5d2ad3df45_at_l34g2000vba.googlegroups.com>
On Sep 21, 8:10 am, Michael <mbulch..._at_gmail.com> wrote:
> 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
Date: Mon, 21 Sep 2009 06:50:45 -0700 (PDT)
Message-ID: <fd01dcb2-9c15-442e-acd0-2c5d2ad3df45_at_l34g2000vba.googlegroups.com>
On Sep 21, 8:10 am, Michael <mbulch..._at_gmail.com> wrote:
> 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
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. Received on Mon Sep 21 2009 - 08:50:45 CDT