Home » Error: ORA-16765: Redo Apply is running

Error: ORA-16765: Redo Apply is running

by tuanlp

DGMGRL> show configuration;
Configuration – DG_TST1T
  Protection Mode: MaxAvailability
  Databases:
    TST1TS – Primary database
    TST1TP – Physical standby database
      Error: ORA-16765: Redo Apply is running
Fast-Start Failover: DISABLED
Configuration Status:
ERROR

CAUSE:

Broker configuration out of sync with MPR running causes by using sqlplus to start and stop MRP instead of dgmgrl.

 SQL> select dest_name,recovery_mode,database_mode,type,status from v$archive_dest_status where type like ‘%PHYSICAL%’;
DEST_NAME                      RECOVERY_MODE           DATABASE_MODE   TYPE           STATUS
—————————— ———————– ————— ————– ———
LOG_ARCHIVE_DEST_3             MANAGED REAL TIME APPLY MOUNTED-STANDBY PHYSICAL       VALID

DGMGRL> edit database ‘TST1TP’ set state = ‘APPLY-OFF’ ; with stop managed recovery
DGMGRL> edit database ‘TST1TP’ set state = ‘APPLY-ON’ ; starts managed recovery again

DGMGRL>  edit database ‘TST1TP’ set state = ‘APPLY-OFF’ ;
Succeeded.
DGMGRL> edit database ‘TST1TP’ set state = ‘APPLY-ON’ ;
Succeeded.
DGMGRL>DGMGRL> show configuration;
Configuration – DG_TST1T
  Protection Mode: MaxAvailability
  Databases:
    TST1TS – Primary database
    TST1TP – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

You may also like