How to start managed recovery (MRP) on an Oracle Data Guard standby

Start managed recovery so MRP begins applying redo. USING CURRENT LOGFILE enables real-time apply from the standby redo logs (recommended). DISCONNECT FROM SESSION runs MRP in the background so your session returns immediately. Omit USING CURRENT LOGFILE for archived-log-only apply.

Run on the standby only. Requires the standby to be MOUNTED (or OPEN for Active Data Guard). Verify with V$MANAGED_STANDBY afterwards — MRP0 should show APPLYING_LOG.

-- Recommended: real-time apply from standby redo logs, run in background
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
  USING CURRENT LOGFILE DISCONNECT FROM SESSION;

-- Archived-log apply only (no standby redo logs)
-- ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

-- Verify (read-only) — MRP0 should be present and applying
SELECT process, status, thread#, sequence#
FROM   v$managed_standby
WHERE  process IN ('MRP0', 'MRP');