Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alert log info(checkpoint not complete), please help!

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

From: Denny Koovakattu <denny_vk_at_my-deja.com>
Date: Fri, 09 Jul 1999 21:00:02 GMT
Message-ID: <7m5nsb$ktt$1@nnrp1.deja.com>


Hi,

  Your logs are sized too small. They are switching every minute. And you have only two log groups. I would suggest increasing the size of your log files and also to add at least one more log group. Since you would not be able to drop any log group now, add the new log group with the new size first before attempting to drop and recreate the existing log groups.

Regards,
Denny

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. Received on Fri Jul 09 1999 - 16:00:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US