What Is Mrp in Oracle Data Guard
Managed Recovery Process (Mrp) the Managed Recovery Process (Mrp) Applies Information from the Archived Redo Logs to the Standby Database. When Performing...
Managed recovery process (MRP) The managed recovery process (MRP) applies information from the archived redo logs to the standby database. When performing managed recovery operations, log apply services automatically apply archived redo logs to maintain transactional synchronization with the primary database.
How do I start MRP in Active Data Guard?
- Start and mount the physical standby database: SQL> STARTUP MOUNT;
- Start Redo Apply or real-time apply: To start Redo Apply, issue the following statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE 2> DISCONNECT FROM SESSION;
How do I check my MRP process in standby database?
- 1.To Start media recovery on standby database : SQL> alter database recover managed standby database disconnect from session;
- Perform few log switch on Primary database. SQL> Alter system switch logfile; SQL> / SQL> /
- Monitor Various process on standby database by :
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
