Checkpoint not complete - BR0976W

[Former Member]

Recently, my SAP always got this error when I enter t-code DB14 and double click a "Database check" item :

BR0976W Database message alert - level: WARNING, line: 1281, time: 2011-06-12 01.13.45, message : Checkpoint not complete

I am using Oracle 9i, SAP Kernel release 640, archive log mode.

What should I do now ?

Add more log files ? Decrease the log switch frequency ?

Any ideal ?

[Former Member]

Hello Ming,

as Markus wrote check SAP note 79341, maybe you are affected by the problem described in section 5: "Selftune Checkpointing". This is quite common.

The best way to prevent "checkpoint not complete" messages would be to speed up IO for the online redologs. Make sure that writing to disk is as fast as possible for your online redo logs. Most of the time slow IO causes these messages.

Regards,

Mark

[Former Member]

check this link it may be more helpful

KHS

[markus_doehr2]

Check

Note 79341 - Checkpoint not complete

Your logs may be to small.

Markus