Re: Alert Log

From: tmgn <tmgn_at_excite.com>
Date: Tue, 03 Aug 1999 11:06:46 -0400
Message-ID: <37A70586.C920EA25@excite.com>

This error usually means that the transaction rate is too huge to be handled by the current configuration of Online Redolog files especially if the Database is operated in ARCHIVELOG mode..

The LGWR process might be waiting for the ARCH process to complete the Copy of the Redolog file...

Try adding more REdolog files(probably bigger in Size) as this will buy time for the ARCH process to complete it's operation and not block the LGWR process...

-Thiru

amerar_at_ci.chi.il.us wrote:

> Hello,
>
> I rfeceived this message in my alert log:
>
> Mon Aug 2 23:39:38 1999
> Thread 1 cannot allocate new log, sequence 32802
> Checkpoint not complete
> Current log# 2 seq# 32801 mem# 0:
> /u04/oradata/DR_CASHT/redoDR_CASHT02a.log
> Current log# 2 seq# 32801 mem# 1:
> /u05/oradata/DR_CASHT/redoDR_CASHT02b.log
>
> What does this mean and how can I fix it?
>
> Please CC a copy to my e-mail.
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Aug 03 1999 - 10:06:46 CDT