ORA-08102: index key not found, obj# 56687, file 54, block 176049 (2)

delete from B2BADMIN.DELIVERYJOB where DOCID
in(SELECT DOCID from B2BADMIN.BIZDOC where doctimestamp< sysdate -26) ； 
Error at line 8
ORA-08102: index key not found, obj# 56687, file 54, block 176049 (2)

在刪除表上的歷史資料時發現index資料塊方面的錯誤，

mxb2bcoredb01$oerr   ora   8102   
08102, 00000, "index key not found, obj# %s, file %s, block %s (%s)"
// *Cause:  Internal error: possible inconsistency in index
// *Action:  Send trace file to your customer support representative, along
//           with information on reproducing the error

重建index 後恢復正常， alter index  xxxx   rebuild online  ;  

 

如果需要檢視到底時候什麼不一致，可以經過analyze table t   validate structure cascade;   驗證表和索引的完整性。在udump產生一個trace檔案。

　　*** SESSION ID:(570.35812) 2006-01-01 10:49:34.095
　　row not found in index tsn: 37 rdba: 0xfe037009
.......