What is the expected DataGuard behavior in the following scenario?
We were testing automatic failover of the DBs here are the steps performed/followed:
» Backup both DBs
» Turn off the network interface on primary DB db01
» Failover – automatic switch
» Standby DB db02 was configured as new primary
» Turn on the network interface on old primary DB db01
» The DB db01 was shut down, I started as: startup mount standby
» The DB db01 was configured as new standby automatically and both DBs were synchronized
» Perform switchover to roll back the changes: db01 – primary & db02 – standby
The problem here is that when the switchover occurs the new standby db01 is in a shutdown state instead as coming up automatically in mounted state.