Automatic failover caused DR to become primary and primary to become DR, but when checked the dgmgrl configuration there were some errors.
$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.
DGMGRL> show configuration
Configuration - db1tes_dg
Protection Mode: MaxPerformance
Databases:
db1tesd - Primary database
Warning: ORA-16829: fast-start failover configuration is lagging
db1tesp - (*) Physical standby database
Error: ORA-16810: multiple errors or warnings detected for the database
Fast-Start Failover: ENABLED
Configuration Status:
ERROR
DGMGRL>
DGMGRL> show database db1tesd
Database - db1tesd
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
db1tesd1
Database Warning(s):
ORA-16829: fast-start failover configuration is lagging
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database db1tesp
Database - db1tesp
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: 3 hours 20 minutes 3 seconds
Real Time Query: ON
Instance(s):
db1tesp1 (apply instance)
db1tesp2
Database Warning(s):
ORA-16826: apply service state is inconsistent with the DelayMins property
ORA-16829: fast-start failover configuration is lagging
Database Status:
WARNING
DGMGRL>
$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.
DGMGRL> show configuration
Configuration - db1tes_dg
Protection Mode: MaxPerformance
Databases:
db1tesd - Primary database
Warning: ORA-16829: fast-start failover configuration is lagging
db1tesp - (*) Physical standby database
Error: ORA-16810: multiple errors or warnings detected for the database
Fast-Start Failover: ENABLED
Configuration Status:
ERROR
DGMGRL>
DGMGRL> show database db1tesd
Database - db1tesd
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
db1tesd1
Database Warning(s):
ORA-16829: fast-start failover configuration is lagging
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database db1tesp
Database - db1tesp
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: 3 hours 20 minutes 3 seconds
Real Time Query: ON
Instance(s):
db1tesp1 (apply instance)
db1tesp2
Database Warning(s):
ORA-16826: apply service state is inconsistent with the DelayMins property
ORA-16829: fast-start failover configuration is lagging
Database Status:
WARNING
DGMGRL>
Fix:
What I did in our case was simply restarted the the new DR and it fixed the issue.
$ srvctl stop database -d db1tesp
$ srvctl start database -d db1tesp
$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.
DGMGRL> show configuration
Configuration - db1tes_dg
Protection Mode: MaxPerformance
Databases:
db1tesd - Primary database
db1tesp - (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database db1tesp
Database - db1tesp
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
db1tesp1 (apply instance)
db1tesp2
Database Status:
SUCCESS
DGMGRL> show database db1tesd
Database - db1tesd
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
db1tesd1
Database Status:
SUCCESS
DGMGRL>
No comments:
Post a Comment