备份oracle二进制文件，以便修复后还原。
使用ue找到select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#,?
nvl(property,0),subname,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#的位置，删除“order by order#”，并增加d_obj#+0和p_obj#+0。 [oracle@bogon ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 19 00:53:03 2015 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 2083336 bytes Variable Size 88081912 bytes Database Buffers 184549376 bytes Redo Buffers 6303744 bytes Database mounted. SQL> alter session set events '10046 trace name context forever,level 12'; Session altered. SQL> oradebug setmypid Statement processed. SQL> oradebug tracefile_name /oracle/app/product/10.2.0/db_1/admin/orcl/udump/orcl_ora_28745.trc SQL> alter database open; Database altered.
在 数据库open过程中，alert日志有如下报错。
Database Characterset is AL32UTF8 Mon Jan 19 00:53:45 2015 Errors in file /oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_DEPENDENCY2' or partition of such index is in unusable state Mon Jan 19 00:53:45 2015 Errors in file /oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_DEPENDENCY2' or partition of such index is in unusable state Mon Jan 19 00:53:45 2015 Errors in file /oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_DEPENDENCY2' or partition of such index is in unusable state Opening with internal Resource Manager plan where NUMA PG = 1, CPUs = 4 Mon Jan 19 00:53:46 2015 Errors in file /oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_DEPENDENCY2' or partition of such index is in unusable state replication_dependency_tracking turned off (no async multimaster replication found) Mon Jan 19 00:53:47 2015 Errors in file /oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_DEPENDENCY2' or partition of such index is in unusable state Starting background process QMNC QMNC started with pid=19, OS id=28758 Mon Jan 19 00:53:51 2015 Errors in file /oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_DEPENDENCY2' or partition of such index is in unusable state Mon Jan 19 00:53:57 2015 Completed: alter database open --重建索引 SQL> alter index SYS.I_DEPENDENCY1 rebuild; Index altered. SQL> alter index SYS.I_DEPENDENCY2 rebuild; Index altered.
alert日志中不再报错，恢复oracle 二进制文件后，正常启动数据库。
?