Oracle dataguard報錯:Error 1017 received logging on to the standby,dataguardlogging

來源:互聯網
上載者:User

Oracle dataguard報錯:Error 1017 received logging on to the standby,dataguardlogging
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)
----------------------------------------------------------------------------------------------------------------

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.