on 06-05-2008 9:28 AM
Dear Experts,
I have been going through a series of warnings on my DB13 since a week now whenever i perform a Check DB activity.
I have been scheduling my tasks as follows
Start Time -
Period -
Action
01:00:00 1 Check and update optimizer statistics
02:00:00 1 Check database
03:00:00 0 Whole database online + redo log backup
==============================================
But for the Check database the job log is as follows
=============================================
BR0972I Checking database operations...
BR0973W Database operation alert - level: WARNING, operation: adybgofl.cds, time: 2008-06-03 00.23.09, condition: Last archive l
BR0280I BRCONNECT time stamp: 2008-06-03 02.00.56
BR0974I Checking database messages in /oracle/RT2/saptrace/background/alert_RT2.log ...
BR0976W Database message alert - level: WARNING, line: 213333, time: 2008-05-31 10.48.51, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 213345, time: 2008-05-31 10.51.15, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 213392, time: 2008-05-31 11.02.39, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 213411, time: 2008-05-31 11.05.05, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 213430, time: 2008-05-31 11.07.42, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 213449, time: 2008-05-31 11.09.46, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 213468, time: 2008-05-31 11.13.16, message:
Checkpoint not complete
BR0280I BRCONNECT time stamp: 2008-06-03 02.00.57
BR0977I Checking database profile...
BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14254080 (>< 4096,512 KB)
BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.1 (set in parameter file)
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)
BR0280I BRCONNECT time stamp: 2008-06-03 02.00.57
BR0980I Number of changed database profile parameters: 0
BR0280I BRCONNECT time stamp: 2008-06-03 02.00.57
BR0955I Number of signaled error/warning/exception alerts for database administration: 0/0/0
BR0956I Number of signaled error/warning/exception alerts for database operations: 0/1/0
BR0957I Number of signaled error/warning/exception alerts for database messages: 0/7/0
BR0958I Number of signaled error/warning/exception alerts for database profile: 2/5/0
BR0806I End of BRCONNECT processing: cdybgwvi.chk2008-06-03 02.00.58
BR0280I BRCONNECT time stamp: 2008-06-03 02.00.58
BR0803I BRCONNECT completed successfully with warnings
External program terminated with exit code 1
BRCONNECT returned error status E
Job finished
Check and update optimizer statistics
Check database
+Whole database online + redo log backup+
I request you to kindly help on this as i am unsure WHY this is happening.
The back up and the optimizer stats end without any errors or warnings...
Kindly suggest as this is very urgent and happening daily
Regards
Hunter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Harry,
You need to apply SAP recommendations on your database profile. Please check "Note 830576 - Parameter recommendations for Oracle 10g (<= 10.2.0.2)" on sap.service.com. This is because, "Check DB" checks whether db parameters are correctly setup.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.