RE: NOT COMPLETE LOG

This note is from MetaLink

Rick

 CHECKPOINT NOT COMPLETE

 At times you may see "checkpoint not complete" messages in the alert log as

 follows:   

 Thread 1 advanced to log sequence 248
   Current log# 2 seq# 248 mem# 0: /prod1/oradata/logs/redologs02.log  Thread 1 cannot allocate new log, sequence 249  Checkpoint not complete   

 These messages indicate that Oracle is ready to recycle the redo logs but the
 checkpoint has not been complete on the redo log Oracle needs to accomplish

 this.   

 You should also check the bstat/estat report for the statistics  BACKGROUND_CHECKPOINTS_COMPLETED and BACKGROUND_CHECKPOINTS_STARTED. These

 two numbers should never differ by more than 1. If there is a large  difference in these two statistics it indicates that checkpoints are starting
 but not completing, just as "checkpoint not complete" messages in the alert

 log indicate. The number of checkpoints completed and started as indicated by
 these statistics should be weighed against the duration of the bstat/estat  report. Keep in mind the goal of only one log switch per hour, which ideally
 should equate to one checkpoint per hour as well.      

 The way to resolve incomplete checkpoints is through tuning checkpoints and

 logs:   

1. Give the checkpoint process more time to cycle through the logs
   • add more redo log groups
   • increase the size of the redo logs
2. Reduce the frequency of checkpoints
   • increase LOG_CHECKPOINT_INTERVAL
   • increase size of online redo logs
3. Improve the efficiency of checkpoints
   • enable the CKPT process with CHECKPOINT_PROCESS=TRUE

> -----Original Message-----
> From: Waleed Haggagy ( Nile Networks ) [SMTP:Whaggagy_at_NileNetworks.com]
> Sent: Wednesday, February 07, 2001 8:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: NOT COMPLETE LOG
>
> MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS
> DURING FOLLOW UP MY ALERT LOG FOUND LINES
>
> 'CHECKPOINT NOT
> COMPLETE'
> 'Thread 1 cannot
> allocate
> new log, sequence 609'
>
> WHY?
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Waleed Haggagy \( Nile Networks \)
> INET: Whaggagy_at_NileNetworks.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).