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

Go to solution
former_member554231
Explorer

on ‎10-12-2011 12:09 PM

0 Kudos

Hi experts,

db13 i have check the database in my testing server finished with sucess,but warning message will come.(yellow color).

The details are :

12.10.2011 15:21:59 BR0280I BRCONNECT time stamp: 2011-10-12 15.21.55

12.10.2011 15:21:59 BR0969I Checking database administration...

12.10.2011 15:21:59 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: H:\ORACLE\MPQ\SAPDATA1\SYSAUX_1\SYSAUX01.DA

12.10.2011 15:21:59 BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPR3.EWUCLU, value: PSAPEL40

12.10.2011 15:21:59 BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPR3.EWUCLU~0, value: PSAPEL

12.10.2011 15:21:59

12.10.2011 15:21:59 BR0280I BRCONNECT time stamp: 2011-10-12 15.21.56

12.10.2011 15:21:59 BR0972I Checking database operations...

12.10.2011 15:21:59 BR0973W Database operation alert - level: WARNING, operation: Archive log backup, condition: Operation too old or has not been r

12.10.2011 15:21:59 BR0973W Database operation alert - level: WARNING, operation: Complete database backup, condition: Operation too old or has not

12.10.2011 15:21:59 BR0973W Database operation alert - level: WARNING, operation: chk, condition: Operation too old or has not been run in clean-up

12.10.2011 15:21:59 BR0973W Database operation alert - level: WARNING, operation: , condition: Operation too old or has not been run in clean-up pe

12.10.2011 15:21:59 BR0973W Database operation alert - level: WARNING, operation: Update optimizer statistics, condition: Operation too old or has n

12.10.2011 15:21:59

12.10.2011 15:21:59 BR0280I BRCONNECT time stamp: 2011-10-12 15.21.56

12.10.2011 15:21:59 BR0974I Checking database messages in D:\ORACLE\MPQ\102\ADMIN\SAMPLE\BDUMP\alert_mpq.log ...

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 1235, time: 2010-08-26 02.32.44, message:

12.10.2011 15:21:59 ORA-1113 signalled during: ALTER DATABASE OPEN...

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 2730, time: 2010-08-26 02.46.50, message:

12.10.2011 15:21:59 ORA-1113 signalled during: alter database open resetlogs...

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 4799, time: 2010-08-26 03.01.19, message:

12.10.2011 15:21:59 ORA-1113 signalled during: alter database open resetlogs...

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 4914, time: 2010-08-26 03.09.00, message:

12.10.2011 15:21:59 ORA-1113 signalled during: alter database open resetlogs...

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 4922, time: 2010-08-26 03.09.32, message:

12.10.2011 15:21:59 ORA-1113 signalled during: alter database open resetlogs...

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 5134, time: 2010-08-26 05.11.04, message:

12.10.2011 15:21:59 ORA-1113 signalled during: alter database open resetlogs...

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22576, time: 2010-11-27 01.41.14, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00251_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22577, time: 2010-11-27 01.41.14, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22586, time: 2010-11-27 01.41.15, message:

12.10.2011 15:21:59 ORA-16038: log 13 sequence# 251 cannot be archived

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22587, time: 2010-11-27 01.41.15, message:

12.10.2011 15:21:59 ORA-19504: failed to create file ""

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22593, time: 2010-11-27 01.41.35, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00251_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22594, time: 2010-11-27 01.41.35, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22602, time: 2010-11-27 01.42.35, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00251_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22603, time: 2010-11-27 01.42.35, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22611, time: 2010-11-27 01.43.20, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00251_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22612, time: 2010-11-27 01.43.20, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22620, time: 2010-11-27 01.43.35, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00251_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 22621, time: 2010-11-27 01.43.35, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32227, time: 2011-02-17 08.35.02, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00432_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32228, time: 2011-02-17 08.35.02, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32237, time: 2011-02-17 08.35.02, message:

12.10.2011 15:21:59 ORA-16038: log 14 sequence# 432 cannot be archived

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32238, time: 2011-02-17 08.35.02, message:

12.10.2011 15:21:59 ORA-19504: failed to create file ""

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32244, time: 2011-02-17 08.35.23, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00432_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32245, time: 2011-02-17 08.35.23, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32253, time: 2011-02-17 08.36.13, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00432_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32254, time: 2011-02-17 08.36.13, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32262, time: 2011-02-17 08.36.23, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00432_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32263, time: 2011-02-17 08.36.23, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32271, time: 2011-02-17 08.37.23, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00432_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 32272, time: 2011-02-17 08.37.23, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44447, time: 2011-05-30 23.08.56, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00628_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44448, time: 2011-05-30 23.08.56, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44457, time: 2011-05-30 23.08.57, message:

12.10.2011 15:21:59 ORA-16038: log 14 sequence# 628 cannot be archived

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44458, time: 2011-05-30 23.08.57, message:

12.10.2011 15:21:59 ORA-19504: failed to create file ""

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44464, time: 2011-05-30 23.09.40, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00628_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44465, time: 2011-05-30 23.09.40, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44473, time: 2011-05-30 23.10.40, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00628_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44474, time: 2011-05-30 23.10.40, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44482, time: 2011-05-30 23.11.28, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00628_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44483, time: 2011-05-30 23.11.28, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44491, time: 2011-05-30 23.11.40, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00628_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 44492, time: 2011-05-30 23.11.40, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46210, time: 2011-06-14 23.12.25, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00655_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46211, time: 2011-06-14 23.12.25, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46220, time: 2011-06-14 23.12.26, message:

12.10.2011 15:21:59 ORA-16038: log 13 sequence# 655 cannot be archived

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46221, time: 2011-06-14 23.12.26, message:

12.10.2011 15:21:59 ORA-19504: failed to create file ""

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46227, time: 2011-06-14 23.12.29, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00655_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46228, time: 2011-06-14 23.12.29, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46236, time: 2011-06-14 23.13.28, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00655_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46237, time: 2011-06-14 23.13.28, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46245, time: 2011-06-14 23.13.29, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00655_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46246, time: 2011-06-14 23.13.29, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46253, time: 2011-06-14 23.14.29, message:

12.10.2011 15:21:59 ORA-19504: failed to create file "G:\ORACLE\MPQ\SAPARCH\MPQARCH\ARC00655_0728082691.001"

12.10.2011 15:21:59 BR0976W Database message alert - level: ERROR, line: 46254, time: 2011-06-14 23.14.29, message:

12.10.2011 15:21:59 ORA-27044: unable to write the header block of file

12.10.2011 15:21:59

12.10.2011 15:21:59 BR0280I BRCONNECT time stamp: 2011-10-12 15.21.57

12.10.2011 15:21:59 BR0977I Checking database profile...

12.10.2011 15:21:59 BR0978W Database profile alert - level: WARNING, parameter: DB_FILE_MULTIBLOCK_READ_COUNT, value: 8(set in parameter file)

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

12.10.2011 15:21:59 BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_MODE, value: CHOOSE (set in parameter file)

12.10.2011 15:21:59 BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE)

12.10.2011 15:21:59 BR0978W Database profile alert - level: ERROR, parameter: RECYCLEBIN, value: ON (<> OFF)

12.10.2011 15:21:59 BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)

12.10.2011 15:21:59

12.10.2011 15:21:59 BR0280I BRCONNECT time stamp: 2011-10-12 15.21.57

12.10.2011 15:21:59 BR0980I Number of changed database profile parameters: 14

12.10.2011 15:21:59

12.10.2011 15:21:59 BR0280I BRCONNECT time stamp: 2011-10-12 15.21.59

12.10.2011 15:21:59 BR0955I Number of signaled error/warning/exception alerts for database administration: 0/3/0

12.10.2011 15:21:59 BR0956I Number of signaled error/warning/exception alerts for database operations: 0/5/0

12.10.2011 15:21:59 BR0957I Number of signaled error/warning/exception alerts for database messages: 54/0/0

12.10.2011 15:21:59 BR0958I Number of signaled error/warning/exception alerts for database profile: 3/3/0

12.10.2011 15:21:59

12.10.2011 15:21:59 BR0806I End of BRCONNECT processing: cegzcdei.chk2011-10-12 15.21.59

12.10.2011 15:21:59 BR0280I BRCONNECT time stamp: 2011-10-12 15.21.59

12.10.2011 15:21:59 BR0803I BRCONNECT completed successfully with warnings

12.10.2011 15:21:59 Job finished

Regards,

A.Sithanandan

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎10-12-2011 12:14 PM
0 Kudos

Hi Sithanandan,

There are many warnings and errors to fix in the log, such as "IN_WRONG_TABLESPACE", "ORA-1113", old optimizer statistics and so on. You should fix them all.

Best regards,

Orkun Gedik

Show replies
Show replies
former_member554231
Explorer
‎10-13-2011 6:19 AM
0 Kudos

hi,gedik,

In db13 we shedule the check database the warnings are come .how to solve this problem?

BR0971W The default temporary tablespace of database MPQ is set to SYSTEM

-

BR0969I Checking database administration...

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: H:\ORACLE\MPQ\SAPDATA1\SYSAUX_1\SYSAUX01.DA

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPR3.EWUCLU, value: PSAPEL40

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPR3.EWUCLU~0, value: PSAPEL

-

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: Archive log backup, condition: Operation too old or has not been r

BR0973W Database operation alert - level: WARNING, operation: Complete database backup, condition: Operation too old or has not

BR0973W Database operation alert - level: WARNING, operation: Update optimizer statistics, condition: Operation too old or has n

Regards,

A.Sithanandan

Former Member
‎10-13-2011 6:31 AM
0 Kudos

Seems you do not 'search',

Note 483856 - Description of the alerts for Oracle database monitoring

There are already so many discussion threads on these CheckDB warnings.

Thanks

Answers (0)

Ask a Question