DEST_ID ERROR STATUS LOG_SEQUENCE APPLIED_SCN
---------- ------------------------------ --------- ------------ -----------
2 VALID 63 2133221
@standby,
SQL> sho parameter log_archive_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
NOTE :
1. It is not mandatary to set the config parameter at standby side. But we need this to be set on standby side as well for any role
transition purpose and for DG broker configuration.
2. Once remote shipping established then log_archive_config to null will not affect the remote destination until DB is restarted.
Restart will verify log_archive_config.
rti.run" type="text/javascript">
这个错误是由于没有配置log_archive_config造成的,重新配置该参数,重新启用log_archive_dest_state_x参数之后,主备数据库同步恢复正常。出现这个错误的原因是客户没有同步主数据库的主备服务器下的初始化参数文件造成的。
当遇到Heartbeat failed to connect to standby的错误时一定注意错误编号,根据编号来找错误,对新完成配置的ADG环境也可以尝试重启备库或主库观察是否能正常同步。