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

Comments