Fixing corruption in SYS.WRH$_SEG_STAT_OBJ

I have a data block corruption on the above table:  
SQL> select distinct owner from sys.WRH$_SEG_STAT_OBJ;
select distinct owner from sys.WRH$_SEG_STAT_OBJ
                               *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 3, block # 32164)
ORA-01110: data file 3: 'H:\ORACLE\PRODUCT\10.2.0\ORADATA\GBEASYA\SYSAUX01.DBF'

There are plenty of threads on here about how to fix the corruption so I think I can do it.  My question is whether anyone know what this table is storing.  Chances are I'm going to lose the row with the corruption and I'm not sure what this will do to my database.  My thinking is that seeing as the table can't be read at the moment and the database is still up it can't be *too* important (naive, me?).

I've only been asked to look into this today and have found the problem started in November!  We therefore no longer have a good backup to go back to :o(

We're using Oracle 10.2.0.1.0 on Windows 2003 Server.

I'm 'feeling my way' with this at the moment so if there's a log or anything that will help please let me know.

Thanks,
Keith
LVL 2
it-deptAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Devinder Singh VirdiLead Oracle DBA TeamCommented:
>>My question is whether anyone know what this table is storing
This table stores data used by AWR and ADDM. click the following to get more information
http://www.dba-oracle.com/oracle10g_tuning/t_awr_wri_wrm_wrh.htm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
it-deptAuthor Commented:
Thanks for that.  After a bit more research I found that no-one uses these stats and they are now switched off.  After clearing out the data the data block corruption has gone.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.