Re: log file switch (checkpoint incomplete)
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx
- Date: Tue, 20 Feb 2007 23:59:36 -0500
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@xxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
