下面我們一起來看看關(guān)于oracle中OBJ4 ORA-8102故障恢復(fù)案例，希望本文章可以幫助到各位朋友。

　　在測試環(huán)境中對于OBJ$中i_obj4中出現(xiàn)ORA-8102進(jìn)行了重新并恢復(fù)測試,認(rèn)為自己已經(jīng)比較清楚的掌握了I_OBJ4的ORA-8102問題處理,可是實際的一個案例,還是比較比實驗中復(fù)雜,這里貼出來主要操作供大家參考,再次證明數(shù)據(jù)庫恢復(fù)的場景不可大意,客戶的故障只有你想不到的,沒有遇不到的

　　通過bbed修改obj$中dataobj$重現(xiàn)I_OBJ4索引報ORA-08102錯誤

　　使用bbed 修復(fù)I_OBJ4 index 報ORA-8102

　　數(shù)據(jù)庫創(chuàng)建表提示ORA-8102錯誤

　　SQL> startup

　　ORACLE instance started.

　　Total System Global Area 2.6991E+10 bytes

　　Fixed Size 2213976 bytes

　　Variable Size 1.9327E+10 bytes

　　Database Buffers 7516192768 bytes

　　Redo Buffers 145174528 bytes

　　Database mounted.

　　Database opened.

　　SQL> create table t1 as select * from dual;

　　create table t1 as select * from dual

　　*

　　ERROR at line 1:

　　ORA-00604: error occurred at recursive SQL level 1

　　ORA-08102: index key not found, obj# 39, file 1, block 93842 (2)

　　分析ORA-08102錯誤

　　SQL> select object_name,object_type from dba_objects where object_id=39;

　　OBJECT_NAME OBJECT_TYPE

　　------------------------------ -------------------

　　I_OBJ4 INDEX

　　SQL> create table t1 as select * from dual;

　　create table t1 as select * from dual

　　*

　　ERROR at line 1:

　　ORA-00604: error occurred at recursive SQL level 1

　　ORA-08102: index key not found, obj# 39, file 1, block 93842 (2)

　　SQL> select /*+ index(t i_obj4) */ DATAOBJ#,type#,owner# from obj$ t

　　minus

　　select /*+ full(t1) */ DATAOBJ#,type#,owner# from obj$ t1;

　　2 3

　　DATAOBJ# TYPE# OWNER#

　　---------- ---------- ----------

　　97109 0 0

　　SQL> select /*+ full(t1) */ DATAOBJ#,type#,owner# from obj$ t1

　　minus

　　select /*+ index(t i_obj4) */ DATAOBJ#,type#,owner# from obj$ t

　　;

　　2 3 4

　　DATAOBJ# TYPE# OWNER#

　　---------- ---------- ----------

　　97094 0 0

　　SQL> SET LINES 122

　　COL INDEX_OWNER FOR A20

　　COL INDEX_NAME FOR A30

　　COL TABLE_OWNER FOR A20

　　COL COLUMN_NAME FOR A25

　　SELECT TABLE_OWNER,INDEX_NAME,COLUMN_NAME,COLUMN_POSITION

　　FROM Dba_Ind_Columns

　　WHERE table_name = upper('&TABLE_NAME') order by TABLE_OWNER,INDEX_OWNER,INDEX_NAME,COLUMN_POSITION

　　and index_name='I_OBJ4';

　　SQL> SQL> SQL> SQL> SQL> 2 3

　　Enter value for table_name: OBJ$

　　old 3: WHERE table_name = upper('&TABLE_NAME') order by TABLE_OWNER,INDEX_OWNER,INDEX_NAME,COLUMN_POSITION

　　new 3: WHERE table_name = upper('OBJ$') order by TABLE_OWNER,INDEX_OWNER,INDEX_NAME,COLUMN_POSITION

　　TABLE_OWNER INDEX_NAME COLUMN_NAME COLUMN_POSITION

　　-------------------- ------------------------------ ------------------------- ---------------