both standby/primary db in physical standby role: ORA-16816: incorrect database role
edited Aug 12, 2013 7:34PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered ✓
We have two RAC nodes of Primary(oraqa) and two RAC nodes of Physicalstandby(orasqa) managed by dataguard broker. fast start failover enabled. Database version is 11.2.0.3. OS is Redhat 5.3
Couple days ago our primary oraqa failed over to orasqa by fast start failover, and I could not switchover since some network issue.
Today the network issue fixed, and I would like to switchover orasqa to oraqa.
However I got this error:
ORA-16816: incorrect database role
a check of database_role in v$database at orasqa shows it is in read only physical standby role.
So now both oraqa/orasqa are in physical database role.
0