on 08-05-2009 12:57 PM
Hi All,
In our Production server DB check was scedule in morning 05:00 hrs, which is completing with warnings daily.
Kindly suggest, wat could be the reson,
am confused weather to change parameters in DB16 or not as this was Production server.
BR0974I Checking database messages in /oracle/PRD/saptrace/background/alert_PRD.log ...
BR0976W Database message alert - level: WARNING, line: 165097, time: 2009-08-04 09.20.02, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 165216, time: 2009-08-04 12.02.12, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 165249, time: 2009-08-04 12.25.07, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 165267, time: 2009-08-04 12.25.11, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 165286, time: 2009-08-04 12.25.44, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 165297, time: 2009-08-04 12.25.45, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 165415, time: 2009-08-04 15.43.43, message:
Checkpoint not complete
BR0280I BRCONNECT time stamp: 2009-08-05 05.04.00
BR0977I Checking database profile...
BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14493696 (>< 4096,512 KB)
BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.1 (== 10.2.0.1)
BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2152 (>< 16384,4096)
BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE)
BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)
BR0978W Database profile alert - level: WARNING, parameter: STAR_TRANSFORMATION_ENABLED, value: FALSE (<> TRUE)
BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)
Thnx & Rgds!!
Hello,
Regarding the checkpoint not complete errors it seems Log switches are probably occurring too fast.
To resolve frequent log switches and "checkpoint not complete" messages you
should do the following:
1) Add more redo log groups
2) Increase the size of your redo logs and monitor the frequency of the switches. Keep adjusting them until your switches are occurring at the desired rate.
This would automatically bring down the frequency of archive log generation also.
Also checked in logs Database version is 10.2.01 , consult SAP note 1068186
Regarding the warnings coming in brconnect logs for oracle parameters
either set the correct value of oracle parameters in initSID.ora else you can ignore the alerts by changing the values in DB17 transaction.
Regards,
Reema Verma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Kindly refer to these notes,
For Checkpoint not complete,
Note 79341 - Checkpoint not complete
Note 1068186 - "checkpoint not complete" message increasingly in alert file
For Oracle Parameter,
Note 830576 - Parameter recommendations for Oracle 10g
Thanks,
Chandresh Pranami
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.