Say the first story

Environment: Windows server 2008 + oracle 11.. 2.0.1
No backup (not my pot, this is not my installation management)

1, first of all find SYSAUX database data blocks damaged

2, find and found an index and WRH $_SQL_BIND_METADATA table data block damage;

3, indexing rebuilt, no problem,,

4, table WRH $_SQL_BIND_METADATA dbms_repair repair
Use first DBMS_REPAIR. CHECK_OBJECT
Reoccupy DBMS_REPAIR. FIX_CORRUPT_BLOCKS

Because the table is the query parameter table, for the system is not important, even if no problems with the loss of data
So direct DBMS_REPAIR. SKIP_CORRUPT_BLOCKS

5, DBV check table space still found to have bad fast,
So the WRH $_SQL_BIND_METADATA renamed WRH $_SQL_BIND_METADATA_BAK
And a new table WRH $_SQL_BIND_METADATA and inserted the history data

Try to delete TABLE DROP TABLE SYS. WRH $_SQL_BIND_METADATA_BAK PURGE
An error
ORA - 00600: internal error code, parameters: [13011], [420], [4283125], [1], [4283125], [3], [], [], [], [], [], []


6, but under truncate table WRH $_SQL_BIND_METADATA_BAK, table space restriction with automatic growth
Random create tables to fill the bad data block hedge

7, try again to delete table
DROP TABLE SYS. WRH $_SQL_BIND_METADATA_BAK PURGE
Still an error
ORA - 00600: internal error code, parameters: [13011], [420], [4283125], [1], [4283125], [3], [], [], [], [], [], []

So don't know how to the whole,

Database operation no problem, but would have been an error, the error log can be just a few days of the disk is full

CodePudding user response:

This is probably not this watch is broken, but the base table there is a problem, you try to create a table try


If it is a base table is broken, can look for us

CodePudding user response:

reference 1st floor xifenfei response:

this is probably not this watch is broken, but the base table there is a problem, you try to create a table try


If it is a base table is broken, you can find our

Build table is no problem, but on the analysis of this table when a base table index data inconsistency

CodePudding user response:

Met one such mistake, do not have what method, can take advantage of this database, backup, reinstall, recovery,
Rman backup fails, exp error is derived, and finally use toad export and import