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

Hi Ken,

increase the size of your redolog-files if it happens on a regular basis.

Kind regards,

Toni
In article <34264870.667F_at_mcsilo.ilo.dec.com>, Ken Nichols <knichols_at_mcsilo.ilo.dec.com> 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
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  | Please remove            
Marchioninistr.15 81366 Muenchen 49-89-70953202 | _NO_SPAM for email.