Re: Alert: Thread 1 cannot allocate new log

Hi Zachary.

I don't think so, but you maybe have to take a look at dbw-process. You may have some
contention for I/O ?

Best regards
Jan

Zachary Agatstein <Zachary.Agatstein_at_atsc.allied.com> wrote in article <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 - 16:36:25 CST