Instance_role on both databases/servers showing as Primary_Instance
2921752Mar 10 2010 — edited Mar 11 2010Hi,
I setup a dataguard configuration for one of our databases few weeks ago, tested the switchover via the broker which successed.
Today, I ran the following sql to find that the value of INSTNACE_ROLE on both servers are PRIMARY_INSTANCE . I am sure this was not the case when I initially set this up, it showing PHYSICAL_STANDBY
select NAME,DB_UNIQUE_NAME,instance_role,open_mode,dataguard_broker from v$database,v$instance ;
The output of dgmgrl> show configuration show that DB1 is Primary and DB2 is Physical standby.
v$log_histry also show that logs are being applied as it should.
Can someone please explain what could be wrong here.
Regards
Shah.