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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).