ORA-16826: apply service state is inconsistent with the DelayMins property
Workaround:
Check DG configuration:
DGMGRL> show configuration
Configuration – new_DG_CONFIG
Protection Mode: MaxPerformance
Databases:
new – Primary database
newia – 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 < Doc ID 249703.1> for the same.
DGMGRL> edit database <STANDBY DB> set state=apply-off;
DGMGRL> edit database <STANDBY DB> 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 – new_DG_CONFIG
Protection Mode: MaxPerformance
Databases:
new – Primary database
newia – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
———————————————————
DGMGRL> show database newia
Database – newia
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
new
Database Status:
SUCCESS
