Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 05, 2008 at 01:57 PM

    Hi ,

    Try the below link ,

    missing-statistics-error-in-bi-system

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.