问题
--stbstatus.sql--
select PID,PROCESS,STATUS,SEQUENCE#,THREAD#,BLOCKS,DELAY_MINS from v$managed_standby;
select * from v$gap;
重启MRP
alter database recover managed standby database cancel;
alter database recover managed standby database using current logfile disconnect from session;
查看日志
col name format a90
select name,applied from v$archived_log where sequence#=11988;
显示已应用,切归档中存在。。。
解决方案
从主库传归档到备库,注册后重启MRP,OPEN备库。