check DB finished with warning

[Former Member]

Dear all,

Check DB finished with warning from DB13,

kindly check the detail log .

BR0969I Checking database administration...

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3342337) 34959360 KB (> 28188060 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3342338) 32747520 KB (> 26471824 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3342339) 33157120 KB (> 17786284 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3342340) 34304000 KB (> 24094204 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 3342339) 24125440 KB (> 17786284 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 5 files on disk 3342340) 29286400 KB (> 24094204 KB)

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZBIMIS

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPSR3.ZHDFCLOG

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPSR3.ZHDFCLOG1

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPSR3.ZHDFCMAP

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPSR3.ZHDFCLOG~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPSR3.ZHDFCLOG1~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPSR3.ZHDFCMAP~0

BR0280I BRCONNECT time stamp: 2010-03-12 01.04.29

BR0972I Checking database operations...

BR0280I BRCONNECT time stamp: 2010-03-12 01.04.29

BR0974I Checking database messages in /oracle/IRP/saptrace/background/alert_IRP.log ...

BR0280I BRCONNECT time stamp: 2010-03-12 01.04.31

BR0977I Checking database profile...

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14251008 (>< 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: 2010-03-12 01.04.31

BR0980I Number of changed database profile parameters: 0

BR0280I BRCONNECT time stamp: 2010-03-12 01.04.32

Kindly suggest

Regards

[debasissahoo]

Hi,

Your log gives warnings for database

- CRITICAL_TABLESPACE comes when Tablespace with datafiles autoextend option marked ON, but file system has not enough space to provide.

- Missing statistics - follow what Anindya has said. if not solved, update with errors.

- Several oracle parameters needs to be changed. Check SAP note corresponding Oracle version. for 10g, see 830576.

Regards,

Debasis.

[anindya_bose]

HI

Go to DB20 , Enter the table name ( which are coming in warning) , Press "Refresh" button . You will see

"Old number" and "New Number" are different for those table. Simply click on "Create Statistics" button.

Once you create stats for all the tables shown in warning, run your DB Check job once again.

You have lots of other warning...do some google...you will get most of the information for those warning. Some good links are below

http://download.oracle.com/docs/cd/B12037_01/server.101/b10755/initparams143.htm

http://skywheel.sarang.net/docs/Oracle/10g/server.101/b10755/initparams168.htm

http://youngcow.net/doc/oracle10g/server.102/b14237/initparams209.htm

Regards

Anindya

Edited by: Anindya Bose on Mar 12, 2010 12:35 PM

[Former Member]

Please run "Check and Update optimizer statistics" and collect statics job for the warnings.

Thanks,

Nitesh Jain