If you’re managing a standby database in Oracle Data Guard, one of the most critical components to monitor is the Managed Recovery Process (MRP). This background process is responsible for applying archived redo logs to the standby database—keeping it in sync with the primary.

🛠 How to Check MRP Status

Run this simple SQL query on your standby database:

SELECT PROCESS, STATUS 
FROM V$MANAGED_STANDBY 
WHERE PROCESS LIKE 'MRP%';

If you see something like:

Code

PROCESS   STATUS
-------   -------
MRP0      RUNNING

🎉 You’re good! The MRP process is actively applying logs.

If no rows are returned or the status is anything other than RUNNING, then the MRP process is not active, and your standby might be falling behind.

🚀 Starting MRP (if needed)

If you’re sure it’s safe and the standby is ready, you can start MRP with:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

🛑 Stopping MRP

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;