log file switch (checkpoint incomplete)

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 20 Feb 2007 11:42:42 -0500



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.





Other related posts: