问题
分析
主库查看
主库切归档
备库可以看到归档
查看备库standby redo
select group#,thread#,sequence#,archived,status,bytes/1024/1024 MB from v$standby_log;
查看主库redo
select thread#, group#, status, bytes/1024/1024 MB from v$log order by 1, 2;
猜测主库redo比备库standby redo小导致
解决方案:
alter database recover managed standby database cancel;
alter database add standby logfile thread 1 size 2G;
# alter database clear logfile group x;
# alter system archive log current;
alter database drop standby logfile group x;