Oracle dataguard報錯：Error 1017 received logging on to the standby

Davis_itpub發表於2018-06-27
OracleError
1，狀態描述：
SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;                                                                                                                                                   


MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started


MESSAGE
--------------------------------------------------------------------------------
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARCi: Becoming the 'no FAL' ARCH
ARC1: Becoming the heartbeat ARCH
Error 1017 received logging on to the standby


MESSAGE
--------------------------------------------------------------------------------
FAL[client, ARC2]: Error 16191 connecting to PD for fetching gap sequence
ARCj: Archival started
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Media Recovery Waiting for thread 1 sequence 28870


28 rows selected.


SQL>  

2，解決方案：將主庫的密碼檔案 copy到備份庫，然後重啟備份庫，解決。


參考文章地址：http://blog.itpub.net/26230597/viewspace-1224676/


3，恢復過程：
再啟動從庫
STARTUP MOUNT;
再應用redo應用
alter database recover managed standby database disconnect from session;
檢視是否有yes
select name,sequence#,applied from v$archived_log;  


再去主庫上切換下日誌，看下新的24178歸檔日誌是否傳輸過來，是否應用成YES：
alter system switch logfile;
SQL> alter system switch logfile;                                                                                                                                                              
System altered.
SQL> 


去從庫上面執行檢查
SQL> select sequence#,applied from v$archived_log;
 SEQUENCE# APPLIED
---------- ---------
     24170 YES
     24169 YES
     24173 YES
     24176 YES
     24177 YES
     24178 IN-MEMORY


2800 rows selected.
再繼續檢查check下，applied就變成YES了
 SEQUENCE# APPLIED
---------- ---------
     24170 YES
     24169 YES
     24173 YES
     24176 YES
     24177 YES
     24178 YES
2800 rows selected.


停止redo應用
alter database recover managed standby database cancel;
再開啟open模式，將從庫開啟供大家查詢資料
alter database open read only;
再起動redo應用
alter database recover managed standby database disconnect from session;



 ----------------------------------------------------------------------------------------------------------------
<版權所有，文章允許轉載，但必須以連結方式註明源地址，否則追究法律責任!>
原部落格地址：     http://blog.itpub.net/26230597/viewspace-1413077/
原作者：黃杉 (mchdba)
----------------------------------------------------------------------------------------------------------------

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31520497/viewspace-2156782/，如需轉載，請註明出處，否則將追究法律責任。

相關文章