ORA-00600: internal error code, arguments: [13011], [9183], [12587093], [52], [12587093], [17], [], []

最新推荐文章于 2021-07-21 16:11:29 发布

原创最新推荐文章于 2021-07-21 16:11:29 发布 · 2.7k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#object #sql #table #file

oracle 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一种解决Oracle数据库中ORA-00600内部错误的方法，通过检查并重建WRH$_ENQUEUE_STAT表的索引来修复索引键丢失的问题。

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问题