Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Checkpoint not complete error in alert log

Y.RamletDec 8 2015 — edited Dec 9 2015

OS : Oracle Linux 6.5
RDBMS version : 11.2.0.4

In our 2-node RAC DB, we have configured the redo log size as 2GB . We see around 7 to 8 switches on peak hours and 3 to 5 switches on off-peak hours. Recently we have see quite a high number "Checkpoint not complete" errors in our alert log.

We don't have any latency on our storage array. Currently , we have 4 redo log groups per thread/instance.

Should I increase the Online Redo Log size or should I increase the number of Online Redo Logs to fix the 'Checkpoint not complete' error ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2016
Added on Dec 8 2015
9 comments
1,384 views