Fixing corruption in SYS.WRH$_SEG_STAT_OBJ
Posted on 2010-03-26
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.