DG两个日志文件的SIZE 不同的报错。

刚安装完成就报错

 select process,status,client_process,sequence#,block# from v$managed_standby;

alter database recover managed standby database using archived logfile disconnect;

 

 

 ORA-16857: 成员与重做源断开连接的时间已超过指定的阈值

检查服务器主和备用机器上的备用和重做日志的大小：

select GROUP#,THREAD# ,BYTES/1024/1024 from v$standby_log;

select GROUP#,THREAD#,BYTES/1024/1024 from v$log;

 alter database recover managed standby database cancel;

ALTER DATABASE DROP STANDBY LOGFILE GROUP 10;

alter database add standby logfile thread 1 group 10 size 200m;

 

 看来这边也要改了

alter database recover managed standby database cancel;

 

 关闭在看看