Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 12, 2007 at 02:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 12, 2007 at 02:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded