Re: redo log problem

Hi,
What happens is ALL three online redo log files get written at the same time(ie a 'burst' of data), a fourth needs to be allocated. This means the database will hang until this situation has been resolved. Whenever a checkpoint occurs, the db needs to write out all dirty SGA buffers to the redo log. The message means at the time of the allocation error that has not been completed yet.
You need either to increase the size of your redo log files or add a fourth group.

Hth,

Sybrand Bakker, Oracle DBA

Lee Ming Fai <leemingf_at_pacific.net.hk> wrote in message news:7mk425$kei$1_at_news.hk.linkage.net...
> hi,
>
> our database always log the following message in the alert log at the peek
> hour:
>
> Current log# 1 seq# 44260 mem# 0: /dev/dbdata/oracle/db/db_redo11
> Current log# 1 seq# 44260 mem# 1: /dev/dbdata/oracle/db/db_redo12
> Thu Jul 15 06:59:56 1999
> Thread 1 advanced to log sequence 44261
> Current log# 2 seq# 44261 mem# 0: /dev/dbdata/oracle/db/db_redo21
> Current log# 2 seq# 44261 mem# 1: /dev/dbdata/oracle/db/db_redo22
> Thu Jul 15 07:00:59 1999
> Thread 1 advanced to log sequence 44262
> Current log# 3 seq# 44262 mem# 0: /dev/dbdata/oracle/db/db_redo31
> Current log# 3 seq# 44262 mem# 1: /dev/dbdata/oracle/db/db_redo32
> Thu Jul 15 07:02:19 1999
> Thread 1 cannot allocate new log, sequence 44263
> Checkpoint not complete
> Current log# 3 seq# 44262 mem# 0: /dev/dbdata/oracle/db/db_redo31
> Current log# 3 seq# 44262 mem# 1: /dev/dbdata/oracle/db/db_redo32
> Thu Jul 15 07:02:35 1999
> Thread 1 advanced to log sequence 44263
> Current log# 1 seq# 44263 mem# 0: /dev/dbdata/oracle/db/db_redo11
> Current log# 1 seq# 44263 mem# 1: /dev/dbdata/oracle/db/db_redo12
> Thu Jul 15 07:03:40 1999
> Thread 1 advanced to log sequence 44264
> Current log# 2 seq# 44264 mem# 0: /dev/dbdata/oracle/db/db_redo21
> Current log# 2 seq# 44264 mem# 1: /dev/dbdata/oracle/db/db_redo22
> Thu Jul 15 07:04:58 1999
> Thread 1 cannot allocate new log, sequence 44265
> Checkpoint not complete
>
>
> is it told me that three groups of redo logs is not enough for our db?
>
> What's the meaning and effect for the message "Checkpoint not complete"?
> lost data? or just cannot write the log?
>
>
>
Received on Thu Jul 15 1999 - 03:14:49 CDT