Re: Alert.log - check point not complete???

This is the typical report for 'bursts' ie all redo logs fill simulteanously, and lgwr simply can't keep up. You'll need to enlarge your redo logs to say 5 or 10 Mb and/or add more.

Hth,

Sybrand Bakker, Oracle DBA

<loi_huynh_at_my-deja.com> wrote in message news:8ba3c5$aj3$1_at_nnrp1.deja.com...
> I checked the disk is only 78% fill.
> Closer look at the log, it failed to allocate but then succeed e.g.
> sequence number 24029. There are at lease a dozen entries like this in
> the log.
>
> Pls advise,
>
> Many thanks,
>
> LHUYNH.
>
> /########################################################/
> Checkpoint not complete
> Current log# 1 seq# 24025 mem# 0: /mnt/oracle/log1.dbf
> Thread 1 advanced to log sequence 24026
> Current log# 2 seq# 24026 mem# 0: /mnt/oracle/log2.dbf
> Thread 1 advanced to log sequence 24027
> Current log# 3 seq# 24027 mem# 0: /mnt/oracle/log3.dbf
> Thread 1 advanced to log sequence 24028
> Current log# 1 seq# 24028 mem# 0: /mnt/oracle/log1.dbf
> Thread 1 cannot allocate new log, sequence 24029
> Checkpoint not complete
> Current log# 1 seq# 24028 mem# 0: /mnt/oracle/log1.dbf
> Thread 1 advanced to log sequence 24029
> Current log# 2 seq# 24029 mem# 0: /mnt/oracle/log2.dbf
> Thread 1 advanced to log sequence 24030
> Current log# 3 seq# 24030 mem# 0: /mnt/oracle/log3.dbf
> Thread 1 advanced to log sequence 24031
> Current log# 1 seq# 24031 mem# 0: /mnt/oracle/log1.dbf
> Thread 1 advanced to log sequence 24032
> Current log# 2 seq# 24032 mem# 0: /mnt/oracle/log2.dbf
> Thread 1 advanced to log sequence 24033
> Current log# 3 seq# 24033 mem# 0: /mnt/oracle/log3.dbf
> Thread 1 advanced to log sequence 24034
> Current log# 1 seq# 24034 mem# 0: /mnt/oracle/log1.dbf
> /########################################################/
>
> In article <8b9s7b$2d0$1_at_nnrp1.deja.com>,
> www_dba_at_my-deja.com wrote:
> >
> >
> > Hi,
> >
> > It seems that you are running archivelog mode.
> > But you are running out of hard disk space.
> >
> > HTH.
> >
> > In article <8b9jj6$pav$1_at_nnrp1.deja.com>,
> > loi_huynh_at_my-deja.com wrote:
> > > Hi,
> > > I am getting the following errors in Alert.log but not quite sure
 what
> > > are their ramifications. It says "check point not complete" and
 "Thread
> > > x cannot allocate new log sequence".
> > > Pls advise, thanks,
> > > LHUYNH.
> > > /#################################/
> > > Current log# 2 seq# 24026 mem# 0: /mnt/oracle/log2.dbf
> > > Thread 1 advanced to log sequence 24027
> > > Current log# 3 seq# 24027 mem# 0: /mnt/oracle/log3.dbf
> > > Thread 1 advanced to log sequence 24028
> > > Current log# 1 seq# 24028 mem# 0: /mnt/oracle/log1.dbf
> > > Thread 1 cannot allocate new log, sequence 24029
> > > Checkpoint not complete
> > > /#################################/
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 22 2000 - 00:00:00 CST