Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: log file switch (checkpoint incomplete)

Re: log file switch (checkpoint incomplete)

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Tue, 20 Feb 2007 23:59:36 -0500
Message-ID: <c2213f680702202059v3bf251c0q7c16c690fe46b0ff@mail.gmail.com>


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
Received on Tue Feb 20 2007 - 22:59:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US