How to check managed standby process status in Oracle Data Guard

V$MANAGED_STANDBY is the go-to view for Data Guard health. Shows every managed process (MRP0 = redo apply, RFS = redo receive, LNS = log network sender, ARCH = archiver) with its status, thread, sequence, and where it is inside the current log. The third query drills into block-level progress when apply looks stuck.

SET LINES 200 PAGESIZE 500

-- 1) Quick view: what processes are running and where
SELECT process, status, sequence#, thread#
FROM   v$managed_standby;

-- 2) Client-process view: which primary process each is talking to
SELECT process, client_process, thread#, sequence#, status
FROM   v$managed_standby;

-- 3) Block-level detail: how far MRP has progressed inside the current log
SELECT process, status, thread#, sequence#, block#, blocks
FROM   v$managed_standby;