Standby database process status

Standby database process status:

Following queries on standby database to see what MRP and RFS processes are doing, which block of which archivelog sequences are being shipped or being applied.

SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby ;

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH      CLOSING               1         78          1       1680
ARCH      CLOSING               1         77          1        181
ARCH      CONNECTED             0          0          0          0
ARCH      CLOSING               1         79          1         93
MRP0      APPLYING_LOG          1         80        905     102400
RFS       IDLE                  0          0          0          0
RFS       IDLE                  1         80        906          1