RMAN恢復異常：ORA-01113: 需要對檔案 1 進行媒體恢復作業
RMAN> sql 'alter database activate standby database';sql 敘述句: alter database activate standby database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 07/13/2007 13:29:12
RMAN-11003: failure during parse/execution of SQL statement: alter database acti
vate standby database
ORA-01113: 需要對檔案 1 進行媒體恢復作業
ORA-01110: 資料檔 1: 'E:\ORACLE\ORADATA\SFIS\SYSTEM01.DBF'
各位知道如何解決嗎？感謝指教
recover database 也不可以，
需要單獨 recover datafile ***嗎？
有誰之前遇到過嗎？
SQL> recover standby database until cancel;
ORA-00279: 必須變更 4054771183 建立於 07/10/2007 10:56:58 上 (對於繫線 1 而言)
ORA-00289: 建議 : F:\ARCHIVE\SFIST001S81654.ARC
ORA-00280: 變更 4054771183 (屬於繫線 1) 是在序列 #81654
指定日誌: {<RET>=suggested | filename | AUTO | CANCEL}
我用樓上zhaolinjnu的方法，好像行唉，系統需要的這個archive我的備份集裡面沒有。故一直停在這個地方。
RMAN> sql 'alter database standby database recover management disconnect from se
ssion;'
2> ;
sql 敘述句: alter database standby database recover management disconnect from s
ession;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 07/13/2007 15:51:45
RMAN-11003: failure during parse/execution of SQL statement: alter database stan
dby database recover management disconnect from session;
ORA-02231: 遺漏 ALTER DATABASE 的選項, 或此選項無效
RMAN>
第二種方法也不行，
页:
[1]