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

今天重启了一台测试库备库，发现备库数据库归档无法接收，主库的日志报以以错误
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24486203/viewspace-1801948/