cancel
Showing results for 
Search instead for 
Did you mean: 

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATIST

Former Member
0 Kudos

Dear all,

We have recently migrated 4.6c/oracle9i/solaris 6800 5.8 to 4.6c/oracle10g/HPUX11.23

After the migration everything was succesfull. Except the below error, when I run a dbcheck from db13.

BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: /oracle/DV2/mirrlogA/log_g1m2.dbf

BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: /oracle/DV2/mirrlogB/log_g2m2.dbf

BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: /oracle/DV2/mirrlogA/log_g3m2.dbf

BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: /oracle/DV2/mirrlogB/log_g4m2.dbf

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.APQD

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.APQI

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.ARFCRSTATE

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.ARFCSDATA

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.ARFCSSTATE

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.ATAB

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.CDCLS

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.COIX

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.COIX_DATA40

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.DBTABLOG

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.DDLOG

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.DDNTF

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.DDNTT

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.DDXTF

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.DDXTT

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.EPIDXB

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.EPIDXC

BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPR3.GLSP

Can anyone help us to overcome the above issue

Regards

Senthil

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

The error HARMFUL_STATISTICS is because statistics are getting collected for tables which should not have statistics.

These are for eg., cluster tables/pool tables, etc which have been given a flag in table DBSTATC that they should not have statistics.

If you schedule a brconnect job via DB13 this should delete the

harmful stats that exist or can then be deleted with the following job:

brconnect -u / -c -f stats -d

Best regards,

Warren

Former Member
0 Kudos

Thank you Warren. I shall do that reply to you.

Also I have received the below error messages

oracle9i/solaris 6800 5.d to 4.6c(Kernel46D)/oracle10g/hpux11.23.

Everything works fine except the below Three errors:

BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: /oracle/DV2/mirrlogA/log_g3m2.dbf

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

BR0978W Database profile alert - level: ERROR, parameter: LOG_ARCHIVE_START, value: FALSE (<> TRUE)

Can you help

Regards

Senthil

0 Kudos

Why you ask the same question here and in a new post?

Former Member
0 Kudos

Also I have got one more error messages:

BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: /oracle/DV2/mirrlogA/log_g3m2.dbf

Can you pl help

Regards

Senthil