cancel
Showing results for 
Search instead for 
Did you mean: 

CHECKDB-Checkpoint not complete

Former Member
0 Kudos

Hello,

After upgrade to oracle 10.2.0.4 from 9.2.0.8 when i run the CHECKDB i get a warning message as follows.

BR0974I Checking database messages in G:\ORACLE\PRD\SAPTRACE\BACKGROUND\alert_prd.log ...

BR0976W Database message alert - level: WARNING, line: 6335083, time: 2008-09-17 21.46.09, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 6335095, time: 2008-09-17 21.46.10, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 6335108, time: 2008-09-17 21.46.32, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 6335190, time: 2008-09-17 23.10.25, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 6335203, time: 2008-09-17 23.10.40, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 6335216, time: 2008-09-17 23.10.58, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 6335229, time: 2008-09-17 23.12.17, message:

Checkpoint not complete

Why is this occuring?

When i run it again immediately this warning message goes off?

Please give some idea why it is so?

Regards,

Siddhartha RV.

Accepted Solutions (1)

Accepted Solutions (1)

former_member227600
Contributor
0 Kudos

Hi,

this problem is related to redolog file size ,Increass the size of redolog files.

For more information .please followup the snote 79341.

click on below link

[https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=79341]

karan

former_member204746
Active Contributor
0 Kudos

you upgraded to Oracle 10g and started getting these?

then, check SAP note 1068186 "checkpoint not complete" message increasingly in alert file

http://service.sap.com/sap/bc/bsp/spn/sapnotes/index2.htm?numm=1068186

Answers (1)

Answers (1)

Former Member
0 Kudos

There are two possible solutions of this error if it is occuring frequently.

1-Increase size of redo log file.

2-Add a new redo log file like now might be you having origlogA and origlogB just add origlogC.

Shivam