alert log info(checkpoint not complete), please help!

From: <celia9268_at_my-deja.com>
Date: Fri, 09 Jul 1999 20:23:39 GMT
Message-ID: <7m5lnt$k3p$1@nnrp1.deja.com>

Hi, all.
I found the following information in alert log file:

Wed Jul 7 18:58:55 1999
Thread 1 advanced to log sequence 739

  Current log# 1 seq# 739 mem# 0: /data0/logs/log1a.dbf
  Current log# 1 seq# 739 mem# 1: /data0/logs/log1b.dbf
  Current log# 1 seq# 739 mem# 2: /data0/logs/log1c.dbf

Wed Jul 7 18:59:20 1999
Thread 1 cannot allocate new log, sequence 740 Checkpoint not complete

  Current log# 1 seq# 739 mem# 0: /data0/logs/log1a.dbf
  Current log# 1 seq# 739 mem# 1: /data0/logs/log1b.dbf
  Current log# 1 seq# 739 mem# 2: /data0/logs/log1c.dbf

Thread 1 advanced to log sequence 740

  Current log# 2 seq# 740 mem# 0: /data2/log2a.dbf
  Current log# 2 seq# 740 mem# 1: /data2/log2b.dbf
  Current log# 2 seq# 740 mem# 2: /data2/log2c.dbf

Wed Jul 7 18:59:44 1999
Thread 1 advanced to log sequence 741

  Current log# 1 seq# 741 mem# 0: /data0/logs/log1a.dbf
  Current log# 1 seq# 741 mem# 1: /data0/logs/log1b.dbf
  Current log# 1 seq# 741 mem# 2: /data0/logs/log1c.dbf

Wed Jul 7 19:00:09 1999
Thread 1 cannot allocate new log, sequence 742 Checkpoint not complete

  Current log# 1 seq# 741 mem# 0: /data0/logs/log1a.dbf
  Current log# 1 seq# 741 mem# 1: /data0/logs/log1b.dbf
  Current log# 1 seq# 741 mem# 2: /data0/logs/log1c.dbf

Thread 1 advanced to log sequence 742

  Current log# 2 seq# 742 mem# 0: /data2/log2a.dbf
  Current log# 2 seq# 742 mem# 1: /data2/log2b.dbf
  Current log# 2 seq# 742 mem# 2: /data2/log2c.dbf

Wed Jul 7 19:00:31 1999
Thread 1 advanced to log sequence 743

  Current log# 1 seq# 743 mem# 0: /data0/logs/log1a.dbf
  Current log# 1 seq# 743 mem# 1: /data0/logs/log1b.dbf
  Current log# 1 seq# 743 mem# 2: /data0/logs/log1c.dbf

Wed Jul 7 19:00:59 1999
Thread 1 cannot allocate new log, sequence 744 Checkpoint not complete

  Current log# 1 seq# 743 mem# 0: /data0/logs/log1a.dbf
  Current log# 1 seq# 743 mem# 1: /data0/logs/log1b.dbf
  Current log# 1 seq# 743 mem# 2: /data0/logs/log1c.dbf

Thread 1 advanced to log sequence 744

  Current log# 2 seq# 744 mem# 0: /data2/log2a.dbf
  Current log# 2 seq# 744 mem# 1: /data2/log2b.dbf
  Current log# 2 seq# 744 mem# 2: /data2/log2c.dbf

Wed Jul 7 19:01:22 1999
Thread 1 advanced to log sequence 745

  Current log# 1 seq# 745 mem# 0: /data0/logs/log1a.dbf
  Current log# 1 seq# 745 mem# 1: /data0/logs/log1b.dbf
  Current log# 1 seq# 745 mem# 2: /data0/logs/log1c.dbf

Wed Jul 7 19:01:45 1999
Thread 1 cannot allocate new log, sequence 746 Checkpoint not complete

  Current log# 1 seq# 745 mem# 0: /data0/logs/log1a.dbf
  Current log# 1 seq# 745 mem# 1: /data0/logs/log1b.dbf
  Current log# 1 seq# 745 mem# 2: /data0/logs/log1c.dbf

It seems that thread is trying to change to log1, but unsuccessful. What's the reason?
Later(ab.10minutes later) I found it's ok. Could someone point me out? Can this affect recovery? Thanks.

celia

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 09 1999 - 15:23:39 CDT