on 09-18-2008 5:31 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.