Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Checkpoint not complete

2 views
Skip to first unread message

Michael

unread,
Sep 14, 2009, 9:30:04 AM9/14/09
to m_bul...@yahoo.com
I am receiving the following message in my alert log and can find no
documentation explaining what this error means or how to correct it.


Thanks,
Michael

Michel Cadot

unread,
Sep 14, 2009, 12:16:51 PM9/14/09
to

"Michael" <mbul...@gmail.com> a �crit dans le message de news:
2b047962-b90e-44f7...@d21g2000vbm.googlegroups.com...

Search again, for instance on Google.

Regards
Michel


joel garry

unread,
Sep 14, 2009, 12:26:58 PM9/14/09
to

The answers vary somewhat by version. In general it is not a fatal
error as long as it isn't compounding until things die, but it
indicates a misconfiguration of some sort, and likely a performance
problem. In older versions, you might need to configure a checkpoint
process.

So, what version/OS version are you on, and how often are you getting
the error? Are users complaining? How have you configured your log
buffer size? How big are your redo logs and how often are they
switching?

jg
--
@home.com is bogus.
Marketing, feh.
http://www3.signonsandiego.com/stories/2009/sep/14/pc-makers-turn-simple-shopper-friendly-sales-pitch/?uniontrib

Mark D Powell

unread,
Sep 15, 2009, 9:55:12 AM9/15/09
to
> Marketing, feh.http://www3.signonsandiego.com/stories/2009/sep/14/pc-makers-turn-sim...

A "checkpoint not complete" message in the alert log pretty much has
always been an indication that the online redo logs are sized too
small for the amount of redo being generated so that another log
switch takes place before the checkpoint of the previous switch could
be completed.

Take a look at the alert log or use v$log_history to determine the
time between switches. In the absence of Data Guard I aim for 24 - 48
switches per 24 hours. That is one switch every 30 - 60 minutes on
average. If you use Data Guard and you log ship then you generally
want smaller redo logs and will aim for a higher switch total but even
so you need to make sure the online redo logs are not badly
undersized.

Too many log switches too close together so that multiple checkpoint
not complete messages occur can result in Oracle stopping current
activity so that it completes a check point.

HTH -- Mark D Powell --


Michael

unread,
Sep 21, 2009, 9:02:29 AM9/21/09
to
We have 10 redo logs each of 150M in size and 2 members in each group.
We have been constanly getting a message of CHECKPOINT NOT
COMPLETE.

What can we do to get rid of this checkpoint error? Should we
increase the size of our redo logs?

Thanks in advance for your help.


Michael

Frank van Bortel

unread,
Oct 29, 2009, 9:58:14 AM10/29/09
to

150MB is pretty small... ROT is 1GB, three groups minimum for me
(but... beware of ROTs).
Mark has given pretty solid advise, that is a lot more precise.

0 new messages