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

Hello,

Read this page :

http://altern.org/place4oracle/oracle20.html#topic19

You will have some information.

Cu
Place4oracle
http://altern.org/place4oracle/oracle_contents.html

In article <7m5lnt$k3p$1_at_nnrp1.deja.com>,   celia9268_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 12 1999 - 04:01:05 CDT