环境:主库RAC,物理备库单实例
条件:备库关闭一段时间后,再次开启,接收主库在此期间产生的归档日志及在线日志。
SQL> select PROCESS,STATUS,THREAD#,SEQUENCE# from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE#
--------- ------------ ---------- ----------
ARCH CLOSING 1 406
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CLOSING 2 287
MRP0 APPLYING_LOG