Oracle辅导：Dataguard出问题了

会计考友

Standby数据库一根内存报错,同事在处理时OS突然宕机,重新开机后内存恢复正常,启动日志Apply正常.青年人网站提示AP人员反映Report抓不到资料(report是用Standby的).检查DB发现Standby没有Apply log.查看日志没有发现异常.
) n& k7 z3 W9 _0 a1 N1 P7 O2 ]　　SQL>select event_time,status,event from dba_logstdby_events
　　ORA-16128: User initiated stop apply successfully completed
　　ORA-16111: log mining and apply setting up
1 l( }+ s5 f0 l; ?　　SQL>SELECT TYPE, STATUS_CODE, STATUS FROM V$LOGSTDBY_PROCESS;
　　ORA-16127: stalled waiting for additional transactions to be applied
( g2 v# d% E6 B　　SQL>SELECT TYPE, HIGH_SCN, STATUS FROM V$LOGSTDBY;
  x( p9 ]5 j4 i( Q- D! C. z　　ORA-16240: Waiting for logfile ARC001_064418511614697.ARC
& b; J+ H" _9 f. H" n　　发现备库上缺少ARC001_064418511614697.ARC--ARC001_064418511614717.ARC,就是DB宕机时产生的LOG,手动COPY过来,shutdown DB,,重新Startup ,再重新Apply,仍然不行.在网上找了很久,没有相关解决方式,在 metalink上也没有找到.
; R" H3 r2 ^' l: l0 d　　SQL>SELECT file_name, sequence#, first_change#, next_change#, TIMESTAMP, dict_begin, dict_end, thread# FROM dba_logstdby_logORDER BY sequence#;
  B+ e- t- q  K7 B& S　　FILE_NAME SEQUENCE# FIRST_CHANGE# NEXT_CHANGE# TIMESTAMP DICT_BEGIN DICT_END THREAD#
　　D:MESARCHIVEARC001_064418511614695.ARC 14695 55452450043 55452555758 2008/11/6 上午 08:41:04 NO NO 1D:MESARCHIVEARC001_064418511614696.ARC 14696 55452555758 55452674627 2008/11/6 上午 08:46:05 NO NO 1
　　D:MESARCHIVEARC001_064418511614717.ARC 14717 55455038222 55455134353 2008/11/6 上午 10:31:01 NO NO 1D:MESARCHIVEARC001_064418511614718.ARC 14718 55455134353 55455249641 2008/11/6 上午 10:36:01 NO NO 1
: k8 ^: Y" S  S! r4 q7 {$ a　　D:MESARCHIVEARC001_064418511614719.ARC 14719 55455249641 55455357972 2008/11/6 上午 10:41:01 NO NO 1
5 P2 r, \* h1 E; e7 |0 g: I' x/ M' }　　发现手工复制过来的log file没有注册,到是后面来的log注册了,估计是个BUG.下以下命令
; B* t& P7 T& u! b　　SQL> ALTER DATABASE REGISTER logfile 'D:MESARCHIVEARC001_064418511614697.ARC';
　　注册成功,继续将未注册的Log手工注册完,
　　SQL>SELECT SESSION_ID, STATE FROM V$LOGSTDBY_STATE;
　　系统开始Apply