on 12-12-2007 12:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.