Re: log file switch (checkpoint incomplete)

status active means that this online redo log is required for crash recovery.

Try "ALTER SYSTEM CHECKPOINT;" you should see that status ACTIVE should disappear.

You need to checkpoint more aggressively (depending on your Oracle version like setting MTTR_TARGET appropriately) or increase size / number of logs as Mark mentioned already.

On 2/20/07, Harvinder Singh <Harvinder.Singh_at_metratech.com> wrote:
> Hi,
>
> We have a test system in noarchivelog mode and have 3 log file groups having
> 1 50MB member each. Now I see the ora-00600 in the alert log and user
> process is waiting on "log file switch (checkpoint incomplete)". Now the 2
> redo log were in active state and 1 is current and so I added 3 new log
> groups and now I can see that 4 log files are in active state and 1 current
> and 1 usused and now the waiting message for process changed to "enq: CI –
> contention" but still it is hanged. Before that I can restart the instance
> it will be great if you can tell me some pointers what else to check and to
> make sure that checkpoint now completes successfully and system can move
> forward normally and then I will figure out what caused the system to be in
> this state.
>
>
>
> Thanks
>
> --Harvinder
>
>

-- 
Best regards,
Alex Gorbachev

http://www.oracloid.com
--
http://www.freelists.org/webpage/oracle-l