*** KEWROCISTMTEXEC - encountered error: (ORA-08102: index key not found, obj# 8965, file 3, block 56292 (2) )

早上来公司一看。以为不会出什么问题。

检查日志

Errors in file /u01/app/oracle/admin/gs/bdump/gs2_m000_11862398.trc:
Mon Nov 14 07:05:44 2011
Trace dumping is performing id=[cdmp_20111114070544]

---------------trc文件-------------------------------
*** KEWROCISTMTEXEC - encountered error: (ORA-08102: index key not found, obj# 8965, file 3,
 block 56292 (2)
)
  *** SQLSTR: total-len=346, dump-len=240,
      STR={delete from WRH$_ENQUEUE_STAT tab  where (:beg_snap <= tab.snap_id and         ta
b.snap_id <= :end_snap and         dbid = :dbid)    and not exists (select 1 from WRM$_BASEL
INE b                    where (tab.dbid = b.dbid) and             }
KEWRAPAD: Error=13509 in auto_purge_all_dbids for dbid=0.

。。。。貌似索引坏了。

dbv赶紧检查一下，没有发现坏块。

oracle@p550b$dbv file='+ORADATA/gs/datafile/sysaux.269.758391261' userid=system/xxxx

DBVERIFY: Release 10.2.0.1.0 - Production on Mon Nov 14 12:03:47 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

DBVERIFY - Verification starting : FILE = +ORADATA/gs/datafile/sysaux.269.758391261


DBVERIFY - Verification complete

Total Pages Examined         : 145920
Total Pages Processed (Data) : 43496
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 39503
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 49869
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 13052
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Highest block SCN            : 0 (0.0)

查看一下对象

SQL> select object_name from dba_objects  where object_id=8965;

OBJECT_NAME
--------------------------------------------------------------------------------
WRH$_ENQUEUE_STAT_PK

无奈重建一下索引。

alter index WRH$_ENQUEUE_STAT_PK rebuild online.

继续观察观察。