RAC+DG 单节点重启DG失效问题

RAC+DG 单节点重启DG失效问题

节点2显示重启之后
Error 12154 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby 'phyrac'. Error is 12154.

备库节点显示：
RFS[5]: Possible network disconnect with primary database
Mon Dec 12 03:07:56 2016
RFS[3]: Possible network disconnect with primary database
Mon Dec 12 03:07:56 2016
RFS[4]: Possible network disconnect with primary database

主库与备库的rfs断开连接了。


log_archive_dest_2 有一个参数reopen这个是重启时,还有一个net_timeout 这个是网络比较慢时

那么修复一下log_archive_dest_2,如下:
 alter system set log_archive_dest_2='service=phyrac  reopen=120  net_timeout=120 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=phyrac' sid='*' scope=spfile;

重启一节点之后DG依然正常运行.