系统版本:centos7.3
数据库版本:11.2.3
问题描述:新搭的dataguard,数据文件全部都可以同步到备库,截止到最后的归档都可以同步,但是此后主库的归档都同步不过去,备库没有错误日志生成,主库一直报
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'csspm_dg'. Error is 12154.
PING[ARC2]: Heartbeat failed to connect to standby 'csspm_dg'. Error is 12154.
在主库中执行
SQL>SELECT thread#, dest_id, gvad.status, error, fail_sequence FROM gv$archive_dest gvad, gv$instance gvi WHERE gvad.inst_id = gvi.inst_id AND destination is NOT NULL ORDER BY thread#, dest_id;
ORA-12154:TNS:couldnot resolve the connect identifier specified
开始解决问题:
1.开始检查dataguard文档中所有的配置参数,都没有问题。因为跟主从相关的同步参数,主要就是log_archive_config,log_archive_dest_2,log_archive_dest_state_2
,将主库的log_archive_dest_2参数置空,再重设。
SQL> alter system set log_archive_dest_state_2='defer' scope=both;