Re: Alert: Thread 1 cannot allocate new log

It seems that your online redo log files are exhausted very quickly to recycle.
Try creating couple of additional log groups (or you can increase the size of the existing also) The first option would be better

Madhu Cherukuri

Zachary Agatstein wrote in message
<714ssh$2lb82_at_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 - 17:18:21 CST