APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later Information in this document applies to any platform.
GOAL
Data Guard Broker Configuration
DGMGRL> show configuration verbose;
Configuration - orcl1_site
Protection Mode: MaxPerformance Databases: orcl1 - Primary database dgorcl1 - Physical standby database Warning: ORA-16826: apply service state is inconsistent with the DelayMins property <<<<<<<<<<<<<<<
Properties: FastStartFailoverThreshold = '30' OperationTimeout = '30' FastStartFailoverLagLimit = '30' CommunicationTimeout = '180' FastStartFailoverAutoReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status: WARNING
DGMGRL> SHOW DATABASE dgorcl1
Database - dgorcl1
Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds Apply Lag: 2 minutes 33 seconds Real Time Query: OFF Instance(s): dgorcl11 (apply instance) dgorcl12
Database Warning(s): ORA-16826: apply service state is inconsistent with the DelayMins property<<<<<<<<<
Database Status: WARNING<<<<<<<<<<<<
SOLUTION
Workaround :
Check on which node MRP process is running.
On Standby
Make sure Standby redo logs files are created on standby.
Please referenceInteraction Between the Data Guard Broker and a Data Guard Configuration Doc ID 249703.1
DGMGRL> edit database <standby database> set state=apply-off; DGMGRL> edit database<standby 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 Broker Configuration
DGMGRL> show configuration
Configuration - orcl1_site
Protection Mode: MaxPerformance Databases: orcl1 - Primary database dgorcl1 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS <<<<<<<<<<<<<<<<<<
DGMGRL> show database dgorcl1
Database - dgorcl1
Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds Apply Lag: 0 seconds Real Time Query: OFF Instance(s): dgorcl11 (apply instance) dgorcl12
Database Status: SUCCESS <<<<<<<<<<<<<<<<<<<<<<
How to avoid this issue
1. This Problem occurs if Managed Recovery is started manually which should not be done at all if there is an active Data Guard Broker Configuration.
Typically the Data Guard Broker should start Managed Recovery .
2. It can also happen if there are no Standby Redo Logs in Place or they are incorrect configured - referenceUsage,Benefits and Limitations of Standby Redo Logs (SRL) Doc ID 219344.1 (编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|