Skip to Content
avatar image
Former Member

Warning while doing a DB Check on my PRD server

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 😊

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 05, 2008 at 08:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 05, 2008 at 01:57 PM

    Hi ,

    Try the below link ,

    missing-statistics-error-in-bi-system

    Add comment
    10|10000 characters needed characters exceeded