ORA-00600: internal error code, arguments: [13011], [9183], [12587093], [52], [12587093], [17], [], []
ORA-08102: index key not found, obj# 9029, file 3, block 35919 (2)
.查看对象
SQL> select owner,object_name,object_type from dba_objects where object_id=9029;
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
SYS
WRH$_ENQUEUE_STAT_PK
INDEX
2.比较结果
SELECT /*+ FULL(t1) */ *
FROM WRH$_ENQUEUE_STAT t1
MINUS
SELECT /*+ index(t2 WRH$_ENQUEUE_STAT_PK)*/ *
FROM WRH$_ENQUEUE_STAT t2;
select /*+ FULL(t1) */ SNAP_ID, DBID,INSTANCE_NUMBER,EQ_TYPE,REQ_REASON
FROM WRH$_ENQUEUE_STAT t1
MINUS
select /*+ INDEX(t2 WRH$_ENQUEUE_STAT_PK) */ SNAP_ID, DBID,INSTANCE_NUMBER,EQ_TYPE,REQ_REASON
FROM WRH$_ENQUEUE_STAT t2;
3.查看表的数据
SQL> SELECT /*+ FULL(t1) */ count(*)
2 FROM WRH$_ENQUEUE_STAT t1 ;
COUNT(*)
----------
124732
SQL> SELECT /*+ index(t2 WRH$_ENQUEUE_STAT_PK)*/ count(*)
2 FROM WRH$_ENQUEUE_STAT t2;
COUNT(*)
----------
124591
SQL>
4.清索引
ALTER TABLE WRH$_ENQUEUE_STAT DROP CONSTRAINT WRH$_ENQUEUE_STAT_PK;
5.创建约束
ALTER TABLE WRH$_ENQUEUE_STAT ADD (
CONSTRAINT WRH$_ENQUEUE_STAT_PK
PRIMARY KEY
(DBID, SNAP_ID, INSTANCE_NUMBER, EQ_TYPE, REQ_REASON)
USING INDEX
TABLESPACE SYSAUX);
第二天,同样报错,后来看看WHR开头的表,发现查询结果都不一致,后来把所有约束清掉,然后重建,解决了,ora-00600问题