redo log problem

From: Lee Ming Fai <leemingf_at_pacific.net.hk>
Date: Thu, 15 Jul 1999 16:04:25 +0800
Message-ID: <7mk425$kei$1@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:04:25 CDT