standby database :
SQL> SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS FROM
2 V$MANAGED_STANDBY;
PROCESS CLIENT_P SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH ARCH 57 CLOSING
ARCH ARCH 56 CLOSING
MRP0 N/A 58 WAIT_FOR_LOG
RFS UNKNOWN 0 IDLE
SQL>