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

From: <loi_huynh_at_my-deja.com>
Date: 2000/03/22
Message-ID: <8ba3c5$aj3$1@nnrp1.deja.com>#1/1

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