ORA-16766: Redo Apply is stopped (Error From Dataguard Broker)
Problem:
DGMGRL>show configuration
Configuration - db4_dg
Protection Mode: MaxPerformance
Databases:
db3_dg - Primary database
db4_dg - Physical standby database
Error: ORA-16766: Redo Apply is stopped
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
Solution:
The problem is MRP process is not applying log in standby.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
Now you can MRP process is applying log:
SQL> SELECT PROCESS, STATUS FROM v$managed_standby;
PROCESS STATUS
--------------------------- ------------------------------------
ARCH CLOSING
ARCH CONNECTED
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
RFS IDLE
PROCESS STATUS
--------------------------- ------------------------------------
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
MRP0 APPLYING_LOG
DGMGRL>show configuration
Configuration - db4_dg
Protection Mode: MaxPerformance
Databases:
db3_dg - Primary database
db4_dg - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS