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