standby报错：PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.

最新推荐文章于 2025-03-17 21:13:58 发布

Perry705

最新推荐文章于 2025-03-17 21:13:58 发布

阅读量7.2k

点赞数 1

分类专栏： ORACLE_FAQ ORACLE_DATAGUARD

本文链接：https://blog.youkuaiyun.com/u011616400/article/details/51241623

版权

ORACLE_FAQ 同时被 2 个专栏收录

24 篇文章

订阅专栏

ORACLE_DATAGUARD

17 篇文章

订阅专栏

standby报错：

Mon Apr 25 12:18:26 2016
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
Mon Apr 25 12:19:26 2016
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
Mon Apr 25 12:20:26 2016
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
Mon Apr 25 12:21:26 2016
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
Mon Apr 25 12:22:26 2016
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
Mon Apr 25 12:23:26 2016
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
Mon Apr 25 12:24:26 2016
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
Mon Apr 25 12:25:26 2016
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.

standby：

SQL> select dest_id,error from v$archive_dest;

DEST_ID ERROR
---------- -----------------------------------------------------------------
1
2 ORA-16009: invalid redo transport destination

查看standby的log_archive_dest_2如下：

SQL> show parameter log_archive_dest_2;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=orcl async valid_for=(all_logfiles,all_roles) db_unique_name=orcl

修改standby的log_archive_dest_2如下：

SQL> alter system set log_archive_dest_2='service=orcl async valid_for=(online_logfiles,primary_roles) db_unique_name=orcl';

System altered.

问题解决。