Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
Workaround:
Check DG configuration:
DGMGRL> show configuration
Configuration – ZEE_DG_CONFIG
Protection Mode: MaxPerformance
Databases:
zee – Primary database
zeedr – Physical standby database
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
Check on Which node MRP process is running.
On Standby
Make sure Standby redo logs files are created on standby.
Please refere for the same.
DGMGRL> edit database set state=apply-off;
DGMGRL> edit database set state=apply-on;
OR
SQL>alter database recover managed standby database cancel;
SQL> alter database recover managed standby database using current logfile disconnect;
Verify DG Broker Configuration:
DGMGRL> show configuration
Configuration – ZEE_DG_CONFIG
Protection Mode: MaxPerformance
Databases:
zee – Primary database
zeedr – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
———————————————————
DGMGRL> show database zeedr
Database – zeedr
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
zee
Database Status:
SUCCESS
How to avoid this issue:
1. This Problem can only happen if Managed Recovery is started manually which should not be done at
all if there is an active Data Guard Broker Configuration – reference Doc ID 249703.1 Typically the
Data Guard Broker should start Managed Recovery.
2. It can also happen if there are no Standby RedoLogs in Place or they are incorrectly configured
– reference Doc ID 219344.1 to set them up.
