设为首页 收藏本站
查看: 3227|回复: 0

[经验分享] PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 16191.

[复制链接]

尚未签到

发表于 2015-9-5 12:51:01 | 显示全部楼层 |阅读模式
  PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 16191.
Fri Jul 05 14:18:27 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:22:09 2013
  
  在解决这个问题的时候,尝试过很多办法;老师讲的,网上查的;都不管用;后来自己摸索出了一条方法,错误的核心不是主库与备库的密码文件不一致吗,而且2个节点中,有一个节点能正常归档,另外一个就是死活归档不了,即使重新修改了密码,也是照样不可以;郁闷至极;
  后来,灵机一动,既然搞一致,那我将节点中能常常归档的那个密码文件,复制一份给另外一个节点,在复制一份给dataguard节点,结果我终于发泄了.


DSC0000.gif DSC0001.gif


Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:23:30 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:24:30 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:25:30 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:26:31 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:27:32 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:28:32 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:29:32 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:30:33 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:31:33 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:32:35 2013
Error 1031 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.
Fri Jul 05 14:34:50 2013
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LGWR: Standby redo logfile selected for thread 1 sequence 83 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 83 (LGWR switch)
Current log# 1 seq# 83 mem# 0: +DATA/devdb/onlinelog/group_1.261.819703681
Current log# 1 seq# 83 mem# 1: +FLASH/devdb/onlinelog/group_1.257.819703683
Fri Jul 05 14:35:01 2013
Archived Log entry 191 added for thread 1 sequence 82 ID 0x2b2dcaf4 dest 1:
node1




Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Beginning instance recovery of 1 threads
parallel recovery started with 2 processes
Started redo scan
Fri Jul 05 14:40:09 2013
Completed redo scan
read 367 KB redo, 86 data blocks need recovery
Started redo application at
Thread 1: logseq 82, block 7170
Recovery of Online Redo Log: Thread 1 Group 2 Seq 82 Reading mem 0
Mem# 0: +DATA/devdb/onlinelog/group_2.262.819703685
Mem# 1: +FLASH/devdb/onlinelog/group_2.258.819703687
Recovery of Online Redo Log: Thread 1 Group 1 Seq 83 Reading mem 0
Mem# 0: +DATA/devdb/onlinelog/group_1.261.819703681
Mem# 1: +FLASH/devdb/onlinelog/group_1.257.819703683
Completed redo application of 0.07MB
Completed instance recovery at
Thread 1: logseq 83, block 378, scn 1811630
80 data blocks read, 88 data blocks written, 367 redo k-bytes read
Fri Jul 05 14:40:17 2013
Setting recovery pair for thread 1: nab 378 seq 83
Fri Jul 05 14:40:19 2013
Thread 1 advanced to log sequence 84 (thread recovery)
Redo thread 1 internally disabled at seq 84 (SMON)
Fri Jul 05 14:40:24 2013
minact-scn: master continuing after IR
Fri Jul 05 14:40:27 2013
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Thread 2 advanced to log sequence 82 (LGWR switch)
Current log# 4 seq# 82 mem# 0: +DATA/devdb/onlinelog/group_4.267.819704185
Current log# 4 seq# 82 mem# 1: +FLASH/devdb/onlinelog/group_4.260.819704189
Fri Jul 05 14:40:29 2013
Archived Log entry 193 added for thread 1 sequence 83 ID 0x2b2dcaf4 dest 1:
Fri Jul 05 14:40:30 2013
Archived Log entry 194 added for thread 2 sequence 81 ID 0x2b2dcaf4 dest 1:
Fri Jul 05 14:40:30 2013
ARC3: Archiving disabled thread 1 sequence 84
Archived Log entry 195 added for thread 1 sequence 84 ID 0x2b2dcaf4 dest 1:
Fri Jul 05 14:42:00 2013
ARC0: Archive log rejected (thread 1 sequence 83) at host 'phydb'
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance devdb2 - Archival Error. Archiver continuing.
Fri Jul 05 14:45:03 2013
IPC Send timeout detected. Sender: ospid 9998 [oracle@node2.localdomain (PING)]
Receiver: inst 1 binc 429840056 ospid 4733
Fri Jul 05 14:47:27 2013
db_recovery_file_dest_size of 4347 MB is 8.86% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
node2  

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-109744-1-1.html 上篇帖子: HA-drbd+heartbeat+nfs搭建 下篇帖子: 编译安装Heartbeat常见错误
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表