log file switch (checkpoint incomplete)

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Tue, 20 Feb 2007 11:42:42 -0500
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E027EA@ex2003.metratech.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 20 2007 - 10:42:42 CST