cancel
Showing results for 
Search instead for 
Did you mean: 

DB check comleted with warnings.

Former Member
0 Kudos

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!!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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