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 |
{
[ SEND | NOSEND ]
[ RECEIVE | NORECEIVE ]
[ DG_CONFIG=(remote_db_unique_name1 [, ... remote_db_unique_name30) | NODG_CONFIG ]
}
|
|
Default value |
|
|
Modifiable |
|
|
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.
备库操作
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导致此错误，配置一定要仔细