备库wait_for_log

问题

分析

主库查看

主库切归档

备库可以看到归档

查看备库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;

Bingo