oracle ADG 常规同步异常恢复

--处理同步异常

主库切换日志

alter system archive log current;

主库查看同步状态是否为ERROR

select * from v$archive_dest;

如果状态为ERROR调整参数后再观察

alter system set LOG_ARCHIVE_DEST_STATE_2='defer';

alter system set LOG_ARCHIVE_DEST_STATE_2='enable';

 

备库查看同步信息

sqlplus / nolog

 

 

set lines 500

set pages 500

select db.name,dg.name,dg.value,dg.datum_time from v$dataguard_stats dg,v$database db;

 

 

关闭ADG同步

alter database recover managed standby database cancel;

 

打开数据库

alter database open;

再次启动ADG同步

alter database recover managed standby database using current logfile disconnect;