Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alert log info(checkpoint not complete), please help!
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