RE: log file switch (checkpoint incomplete)

Well, you know your system better than any of us do, but 50MB strikes me as a small log file. How frequently are you switching logs?  

-Mark
 

--

Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA

There is nothing so useless as doing efficiently that which shouldn't be done at all. -Peter F. Drucker, 1909-2005  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: Tuesday, February 20, 2007 11:43 AM To: oracle-l
Subject: log file switch (checkpoint incomplete)

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 - 11:31:46 CST