环境:RAC+单机 Dataguard
问题:启动DG备库到mount阶段,启动MRP进程后,发现后台日志不打印归档传输信息,另外备库日志打开ARC1: Becoming the 'no FAL' ARC
1、启动DG备库到mount阶段,启动MRP进程后,发现后台日志不打印归档传输信息,
,发现备库中的日志有报错现象,报:ARC1: Becoming the 'no FAL' ARC错误,告警中日志如下
MMON started with pid=15, OS id=10552
Oracle_BASE from environment = /oracle/app/oracle
Sun Mar 04 15:44:47 2018
MMNL started with pid=16, OS id=10554
Sun Mar 04 15:44:47 2018
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Sun Mar 04 15:44:52 2018
ARC0 started with pid=18, OS id=10561
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 2557884335
Physical Standby Database mounted.
Lost write protection disabled
Sun Mar 04 15:44:53 2018
ARC1 started with pid=19, OS id=10564
Sun Mar 04 15:44:53 2018
ARC2 started with pid=20, OS id=10566
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Sun Mar 04 15:44:53 2018
ARC3 started with pid=21, OS id=10568
Completed: ALTER DATABASE MOUNT
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sun Mar 04 15:51:20 2018
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (strac)
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