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

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: 2000/03/22
Message-ID: <8ba4cq$1fl$1@nereid.worldonline.nl>#1/1

Your logwriter is waiting for the checkpoint to complete, probably during a large batch operation. This is no problem, happend on many databases.
If your logfiles are too small (500K is small) you might want to enlarge them. Five 10Mb files are usually sufficient for a medium-size db (a few Gbytes total size). Cheers,

     Roelof

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife

loi_huynh_at_my-deja.com heeft geschreven in bericht <8b9jj6$pav$1_at_nnrp1.deja.com>...
>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.
Received on Wed Mar 22 2000 - 00:00:00 CST