Re: "Checkpoint not complete" message in alert.log file

Ken Nichols wrote:
>
> Hi everyone,
>
> I see this message from time to time in alert_RCM.log (our database name
> is 'RCM'). Does the "Checkpoint not complete" message mean that
> anything is wrong? I have not been able to find a reference to this
> message anywhere in the docs.
>
> Thanks,
>
> Ken Nichols
>
> --------- log excerpt ------------
>
> Fri Sep 19 11:57:43 1997
> Thread 1 advanced to log sequence 1234
> Current log# 1 seq# 1234 mem# 0: /oracle/oradata/RCM/redoRCM01.log
> Thread 1 advanced to log sequence 1235
> Current log# 2 seq# 1235 mem# 0: /oracle/oradata/RCM/redoRCM02.log
> Thread 1 advanced to log sequence 1236
> Current log# 3 seq# 1236 mem# 0: /oracle/oradata/RCM/redoRCM03.log
> Thread 1 cannot allocate new log, sequence 1237
> Checkpoint not complete
> Current log# 3 seq# 1236 mem# 0: /oracle/oradata/RCM/redoRCM03.log
> Thread 1 advanced to log sequence 1237
> Current log# 1 seq# 1237 mem# 0: /oracle/oradata/RCM/redoRCM01.log
> Thread 1 advanced to log sequence 1238
> Current log# 2 seq# 1238 mem# 0: /oracle/oradata/RCM/redoRCM02.log

You can do either of 2 things to take care of this:

1. Add another redo log group.
2. Start the Checkopint process, by setting the variable CHECKPOINT_PROCESS = TRUE in your init.ora file.

amit
Oracle DBA/Unix SA Received on Tue Sep 23 1997 - 00:00:00 CDT