重建Data Guard遭遇錯誤PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.
主庫端archivelog無法傳至備庫端，主庫端報如下錯誤：
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 14:45:11 2016
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 14:51:46 2016
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 14:52:28 2016
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 14:56:28 2016
PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.
Thu Apr 07 15:02:14 2016
Thread 1 advanced to log sequence 7110 (LGWR switch)
Current log# 2 seq# 7110 mem# 0: +DATA3/jzhd/redo02.log
Thu Apr 07 15:02:14 2016
Archived Log entry 17363 added for thread 1 sequence 7109 ID 0x68b07be9 dest 1:
Thu Apr 07 15:02:14 2016
FAL[server, ARC3]: Error 16032 creating remote archivelog file 'jzhddg'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 15:06:46 2016
標紅字型顯示hearbeat failed，似乎是網路問題，但是tnsping沒有問，sqlplus連線也沒有問題，引數全檢查了都沒有問題，於是檢視trc檔案發現：
*** TRACE FILE RECREATED AFTER BEING REMOVED ***
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
*** 2015-12-14 12:04:06.749 4320 krsh.c
Error 12154 received logging on to the standby
*** 2015-12-14 12:04:06.749 915 krsu.c
Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'jzhddg'
Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'jzhddg'
*** 2015-12-14 12:04:06.749 2932 krsi.c
krsi_dst_fail: dest:2 err:12154 force:0 blast:1
kcrrwkx: unknown error:12154
*** 2015-12-14 13:57:17.587
*** 2015-12-14 13:57:17.587 4645 krsu.c
Logged on to standby successfully
Client logon and security negotiation successful!
Standby parameter STANDBY_ARCHIVE_DEST string is invalid at host 'jzhddg'
Error 16032 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'jzhddg'
*** 2015-12-14 13:57:17.592 2932 krsi.c
krsi_dst_fail: dest:2 err:16032 force:0 blast:1
kcrrwkx: unknown error:16032

STANDBY_ARCHIVE_DEST引數在11gR2被廢棄掉了，檢查備庫，確實設定該引數
alter system set STANDBY_ARCHIVE_DEST=''之後，日誌傳輸正常，應用正常。

PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.

相關文章