PING[ARC2]: Heartbeat failed to connect to standby 'xyxdbs'. Error is 1605

shawnloong發表於2015-09-17
今天重啟了一臺測試庫備庫,發現備庫資料庫歸檔無法接收,主庫的日誌報以以錯誤
PING[ARC2]: Heartbeat failed to connect to standby 'xyxdbs'. Error is 1605
查詢主庫
SQL>  select dest_id,error,status,log_sequence,applied_scn from v$archive_dest where dest_id=2;


   DEST_ID ERROR
---------- -----------------------------------------------------------------
STATUS  LOG_SEQUENCE APPLIED_SCN
--------- ------------ -----------
2 ORA-16057: server not in Data Guard configuration
ERROR   211   5446747

透過metlink(文件 ID 827954.1)查詢到可能原因是db_unique_name或者是 log_archive_config配置錯誤
查詢備庫引數

SQL>  sho parameter log_archive_config


NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config     string DG_CONFIG=(xyxdbp,xyxdbs)

LOG_ARCHIVE_CONFIG


Property Description

Parameter type

String

Syntax

LOG_ARCHIVE_CONFIG =

 {
 [ SEND | NOSEND ]
 [ RECEIVE | NORECEIVE ]
 [ DG_CONFIG=(remote_db_unique_name1 [, ... remote_db_unique_name30) | NODG_CONFIG ]
 }

Default value

'SEND, RECEIVE, NODG_CONFIG'

Modifiable

ALTER SYSTEM

Basic

No


LOG_ARCHIVE_CONFIG enables or disables the sending of redo logs to remote destinations and the receipt of remote redo logs, and specifies the unique database names (DB_UNIQUE_NAME) for each database in the Data Guard configuration.

這裡指定的是主庫備庫的db_unique_name
備庫操作
SQL> alter system set log_archive_config='DG_CONFIG=(xyxdb,xyxdbs)';

修改後


主庫操作
SQL> alter system set log_archive_dest_state_2=defer;


System altered.


SQL> alter system set log_archive_dest_state_2=enable;


System altered.


SQL> select dest_id,error,status,log_sequence,applied_scn from v$archive_dest where dest_id=2;


   DEST_ID ERROR
---------- -----------------------------------------------------------------
STATUS  LOG_SEQUENCE APPLIED_SCN
--------- ------------ -----------
2
VALID   215   5447429
總結:這次是由於修改引數的時候未儲存到spfile重啟的的時候直接從spfile導致此錯誤,配置一定要仔細


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

相關文章