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

2/9/2008来源:Oracle教程人气:6139


  今天有人问我这样之后能不能恢复, 我想基本上已经不能了. 在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做事一定要细心, 在运行批处理时一定要审了再审.