hi all.
Environment: Windows Server 2008 + Oracle 11.2.0.1 + without rman backup(not my fault);
I found the tablespace SYSAUX have Corrupt block.
After finding an index and the table “WRH$_SQL_BIND_METADATA” have Corrupt block.
The index is rebuilt without problem,and using dbms_repair repair table “WRH$_SQL_BIND_METADATA”.
First, use DBMS_REPAIR.CHECK_OBJECT check table,
Seconed, use DBMS_REPAIR.FIX_CORRUPT_BLOCKS fix corrupt block,
Third，use DBMS_REPAIR.SKIP_CORRUPT_BLOCKS skip corrupt block.
Database using without problem, but use "dbv" check tablespace file ,the corrupt block is still there, and always be wrong.
so,I rename WRH$_SQL_BIND_METADATA to WRH$_SQL_BIND_METADATA_BAK,and create new table WRH$_SQL_BIND_METADATA, and insert the history data.
When I try drop WRH$_SQL_BIND_METADATA_BAK with parameter purge,
reported error ORA-00600: internal error code: [13011], [420], [4283125] parameters, [1], [4283125], [3], [], [], [], [], [], [].
truncate table WRH$_SQL_BIND_METADATA_BAK,
and limit the automatic growth of the tablespace SYSAUX ,
and create a table filled with data to bad data blocks away.
try to drop the table again,but not Success.
what can i do?
Thank you very much.