cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DB13 Check Database Completed with Warning

rajesh_gupta12
Explorer

on ‎08-08-2009 9:19 AM

0 Kudos

Hi All,

I have executed Check Database in DB13 and get the following warning message on 03-Aug-09,

BR0974I Checking database messages in /oracle/P11/saptrace/background/alert_P11.log ...

BR0976W Database message alert - level: WARNING, line: 49475, time: 2009-08-01 07.02.42, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 49487, time: 2009-08-01 07.03.35, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 49499, time: 2009-08-01 07.04.07, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 49511, time: 2009-08-01 07.04.40, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 49523, time: 2009-08-01 07.05.19, message:

Checkpoint not complete

BR0280I BRCONNECT time stamp: 2009-08-03 12.01.48

BR0977I Checking database profile...

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14497792 (>< 4096,512 KB)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 20 (set in parameter file)

BR0979I Changes in database profile parameters:

Pos. Parameter name Old value

New value

1 SHADOW_CORE_DUMP PARTIAL

partial

BR0280I BRCONNECT time stamp: 2009-08-03 12.01.48

BR0980I Number of changed database profile parameters: 1

BR0280I BRCONNECT time stamp: 2009-08-03 12.01.49

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/0/0

BR0957I Number of signaled error/warning/exception alerts for database messages: 0/5/0

BR0958I Number of signaled error/warning/exception alerts for database profile: 0/2/0

BR0806I End of BRCONNECT processing: cebduuvl.chk 2009-08-03 12.01.49

BR0280I BRCONNECT time stamp: 2009-08-03 12.01.49

BR0803I BRCONNECT completed successfully with warnings

And on 07-Aug-09 I get the following warning message

BR0974I Checking database messages in /oracle/P11/saptrace/background/alert_P11.log ...

BR0976W Database message alert - level: ERROR, line: 52007, time: 2009-08-05 03.50.31, message:

ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264] [SIGSEGV] [Address not mapped to object] [0x000003058] [] []

BR0976W Database message alert - level: ERROR, line: 52011, time: 2009-08-05 03.50.59, message:

ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264] [SIGSEGV] [Address not mapped to object] [0x000003058] [] []

BR0976W Database message alert - level: WARNING, line: 52651, time: 2009-08-06 14.34.39, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 52983, time: 2009-08-07 08.49.53, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 52995, time: 2009-08-07 08.53.37, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 53006, time: 2009-08-07 08.53.39, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 53017, time: 2009-08-07 08.53.45, message:

Checkpoint not complete

BR0280I BRCONNECT time stamp: 2009-08-07 12.02.12

BR0977I Checking database profile...

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14497792 (>< 4096,512 KB)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 20 (set in parameter file)

BR0280I BRCONNECT time stamp: 2009-08-07 12.02.12

BR0980I Number of changed database profile parameters: 0

BR0280I BRCONNECT time stamp: 2009-08-07 12.02.13

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/0/0

BR0957I Number of signaled error/warning/exception alerts for database messages: 2/5/0

BR0958I Number of signaled error/warning/exception alerts for database profile: 0/2/0

BR0806I End of BRCONNECT processing: cebeomcp.chk 2009-08-07 12.02.13

BR0280I BRCONNECT time stamp: 2009-08-07 12.02.13

BR0803I BRCONNECT completed successfully with warnings

Please let me know that what is the exact problem ? Waiting for your reply.

Rajesh Gupta

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎08-10-2009 4:47 PM
0 Kudos

Hi,

BR0976W Database message alert - level: WARNING, line: 49475, time: 2009-08-01 07.02.42, message:
 Checkpoint not complete

See note 079341. Probably no action needed if the alerts only occur sporadically and in "bursts" with only a short time between successive messages, as seems to be the case in the log you submitted

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14497792 (>< 4096,512 KB)

See [;. Edit the alert condition LOG_BUFFER in DB17 so that you only get a warning (or even better, an error) if the log buffer is smaller than 1024 kB.

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 20 (set in parameter file)

Use SAP parameter recommendations in note 830576 (for convenience you can use the verification SQL script delivered with note 1171650).

Regards,

Mark

Show replies
Show replies
ashish_vikas
Active Contributor
‎08-09-2009 11:43 AM
0 Kudos

Hi Rajesh,

The easiest way of analysing result of Check Database executed from DB 13 is by using tcode DB16. You will find all errors/warning message in DB16. Thresholds/conditions are set for these checks are in DB17 tcode..

I can see you are getting Checkpoint not complete many times : For this probably you need to increase size of your onlne redo log files size and this can be done online.

Check details in DB16, it will suggest you action point for each warning/error message.

On OS level, log of this check will be in /oracle/SID/sapcheck.. and not in /oracle/SID/sapbackup.

thanks

Ashish

Show replies
Show replies
Former Member
‎08-08-2009 10:03 AM
0 Kudos

Hi Rajesh,

can copy here alert log you can find same in /oracle/<SID>/sapbackup/

Regards

Chandra

Show replies
Show replies
rajesh_gupta12
Explorer
‎08-08-2009 10:20 AM
0 Kudos

Hi Chandra,

You mean log file for check database i.e. /oracle/SID/P11/sapcheck/cebeomcp.chk file.

Rajesh Gupta

Former Member
‎08-08-2009 10:24 AM
0 Kudos

action log while you executed db13, it will generate in /oracle/<SID>/sapbackup.

rajesh_gupta12
Explorer
‎08-08-2009 10:58 AM
0 Kudos

Hello Chandra,

When you execute BRBACKUP then the log will be generated in /oracle/SID/sapbackup folder. But when you execute "Check Database" it will execute BRCONNECT and save the log file into /oracle/SID/sapcheck folder. So tell me which log file you want.

Thanks and Regards,

Rajesh

anindya_bose
Active Contributor
‎08-08-2009 11:03 AM
0 Kudos

Hi Rajesh

What is your oracle version? 10g? then check https://service.sap.com/sap/support/notes/900522

https://service.sap.com/sap/support/notes/830576

Some of the warnings you can remove by setting the parameter correctly ( according to SAP's recommendation) and some you can avoid by altering the check conditions from DB17. 900522 has most of the information

rajesh_gupta12
Explorer
‎08-08-2009 12:01 PM
0 Kudos

Yes it is oracle 10g version 10.2.0.2.0.

Thanks and Regards,

Rajesh

Ask a Question