设为首页 加入收藏

TOP

Oracle Dataguard报错:ARC1: Becoming the 'no FAL' ARC(一)
2018-03-13 09:06:38 】 浏览:649
Tags:Oracle Dataguard 报错 ARC1: Becoming the ' FAL' ARC

环境:RAC+单机 Dataguard
问题:启动DG备库到mount阶段,启动MRP进程后,发现后台日志不打印归档传输信息,另外备库日志打开ARC1: Becoming the 'no FAL' ARC


2、在备库中查询查询状态如下,其中有后台日志报错信息


SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;


MESSAGE


ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
ARC3: Archival started


7 rows selected.


3、此时通过第2步是发现备库中有报归档日志错误信息,可以先到主库是查询是否报错
查询结果如下:
SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;


MESSAGE


Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby


MESSAGE


PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.


MESSAGE


Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby


MESSAGE


PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.


MESSAGE


Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby


4、通过第三步发现主库中无法连接备库,导致报12154错误,通过分析,由于我们在备库中采集的是静态监听方式来同步数据,在服务器启动时,并不会自动启动静态监听,从而导致RAC和备库

首页 上一页 1 2 3 4 5 6 7 下一页 尾页 1/9/9
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇Oracle Dataguard中备库中归档日.. 下一篇MySQL实现中位数算法

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目