Below Query is Used to verify if MRP process is running fine on Standby Database, after any maintenance activity that requires disconnect to Primary and Standby database.
SQL> SELECT CLIENT_PROCESS, PROCESS, THREAD#, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY;
Below is the sample output from the query:
SQL> SELECT CLIENT_PROCESS, PROCESS, THREAD#, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY;
CLIENT_P PROCESS THREAD# SEQUENCE# STATUS
——– ——— ———- ———- ————
ARCH ARCH 2 101072 CLOSING
ARCH ARCH 0 0 CONNECTED
ARCH ARCH 1 298101 CLOSING
ARCH ARCH 2 103073 CLOSING
ARCH ARCH 3 95398 CLOSING
ARCH ARCH 1 296100 CLOSING
ARCH ARCH 3 95399 CLOSING
ARCH ARCH 3 95400 CLOSING
ARCH RFS 0 0 IDLE
ARCH RFS 0 0 IDLE
ARCH RFS 0 0 IDLE
LGWR RFS 2 101074 IDLE
LGWR RFS 1 296102 RECEIVING
UNKNOWN RFS 0 0 IDLE
UNKNOWN RFS 0 0 IDLE
LGWR RFS 3 95401 IDLE
UNKNOWN RFS 0 0 IDLE
17 rows selected.