刚安装完成就报错
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;
关闭在看看