Alert: Thread 1 cannot allocate new log

From: Zachary Agatstein <Zachary.Agatstein_at_atsc.allied.com>
Date: Tue, 27 Oct 1998 11:35:53 -0500
Message-ID: <714ssh$2lb82@tmpsp002.tmpprv.allied.com>

I tried to switch to ARCHIVELOG mode. I had problems, so I switched back to NOARCHIVELOG for now.

In my instancenameALRT.log file, I now get log entries like the following:

Thread 1 advanced to log sequence 41706 Current log# 2 seq# 41706 mem# 0: E:\ORANT\DATABASE\LOG2CART.ORA Thread 1 cannot allocate new log, sequence 41707 Checkpoint not complete
Current log# 2 seq# 41706 mem# 0: E:\ORANT\DATABASE\LOG2CART.ORA Thread 1 advanced to log sequence 41707 Current log# 1 seq# 41707 mem# 0: E:\ORANT\DATABASE\LOG1CART.ORA

Did I forget to enable something? My procedure was: shutdown immediate
startup mount pfile=blahblahblah
alter database noarchivelog;
alter database open;

Thank you

Zach Received on Tue Oct 27 1998 - 10:35:53 CST