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