移动系统表Dependencie$,没重建它索引

今天有人问我这样之后能不能恢复, 我想基本上已经不能了. 在open时报ORA-01092号错误, 我查了一下event也没有这方面的合适的event啊, 我推荐用不完全恢复, 不过好象是没有备份, 运行在noarchivelog模式.

从trc文件中得到的内容:

KCRA: buffers claimed = 0/0, eliminated = 0

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01502: index 'SYS.I_DEPENDENCY1' or partition of such index is in unusable state

oerr ora 704

00704, 00000, "bootstrap process failure"

// *Cause:

Failure in processing bootstrap data - see accompanying error.

// *Action: Contact your customer support representative.

SQL_TRACE打开的情况下生成的Trace:

PARSING IN CURSOR #9 len=84 dep=2 uid=0 oct=3 lid=0 tim=18446744073254091198

hv=2287793623

ad='66f6c06c'

select o.name, u.name from obj$ o, user$ u

where o.obj# = :1 and o.owner# = u.user#

END OF STMT

PARSE #9:c=0,e=343,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=18446744073254091193

EXEC #9:c=0,e=186,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=18446744073254091456

FETCH #9:c=0,e=28019,p=2,cr=5,cu=0,mis=0,r=1,dep=2,og=4,tim=18446744073254119501

STAT #9 id=1 cnt=1 pid=0 pos=1 obj=0 op='NESTED LOOPS

'

STAT #9 id=2 cnt=1 pid=1 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ#(18) '

STAT #9 id=3 cnt=1 pid=2 pos=1 obj=36 op='INDEX UNIQUE SCAN OBJ#(36) '

STAT #9 id=4 cnt=1 pid=1 pos=2 obj=22 op='TABLE ACCESS CLUSTER OBJ#(22) '

STAT #9 id=5 cnt=1 pid=4 pos=1 obj=11 op='INDEX UNIQUE SCAN OBJ#(11) '

ORA-00704: 引导程序进程失败

ORA-00604: 递归 SQL 层 1 出现错误

ORA-01502: 索引'SYS.I_DEPENDENCY1'或这类索引的分区处于不可用状态

EXEC #1:c=109375,e=5578667,p=44,cr=616,cu=1,mis=0,r=0,dep=0,og=4,

tim=18446744073255895570

ERROR #1:err=1092 tim=23012387

DBA做事一定要细心, 在运行批处理时一定要审了再审.