oracle 11g adg,检查dg不同步,查看
-
--主库上监控dest状态
-
set lin 300 pages 100
-
col dest_name for a25
-
col error for a20 trunc
-
col gap_status for a18
-
col database_mode for a15
-
col recovery_mode for a25
-
col status for a12
-
col type for a15
-
col synchronization_status for a20
-
select dest_name,status,error,target,affirm,compression,applied_scn,net_timeout from v$archive_dest where target='standby';
error列提示ora-16047
检查备库的log_archive_config参数为空,设置好后就ok
alter system set log_archive_config='dg_config=(orcl,orcldg)
';
原先此库就是一个可用的备库,因主库迁移,所以相关参数没调整,但是原先居然能用(也许一直没同步)
阅读(273) | 评论(0) | 转发(0) |