Which three are true concerning database states after a successful switchover?
A.
If the former primary database became a logical standby database it will be in mount state.
B.
The new primary database will be open read-write.
C.
The former primary database will always be open.
D.
If the former primary database became a logical standby database it will be open read-write.
E.
If the former primary database became a physical standby database it will always be open read-only.
F.
If the former primary database became a physical standby database it will be in the same state as the
former physical standby database.
Explanation:
https://docs.oracle.com/database/121/SBYDB/pre12_role_trans.htm#SBYDB5212
Correct Ans: B, D, E
– The new primary database will be open read-write.
– Switchover is switching roles so when primary becomes logical standby it will be OPEN too (Read-Write)
– If the former primary database became a physical standby database it will be in the same state as the former physical standby database.
according to your explanation, it is BDF.
BDF are the right answers.
Typo…. BDF
Typo. BDF
Agree with you that B,D,E are the only correct answers.
Explanation:
If you perform online database relocation with Oracle RAC One Node on a physical standby, then the new instance is started in the same mode as the currently running instance. Therefore, if the database is mounted on the original instance, then the database will be mounted on the new instance. Likewise, if the database is open on the original instance, then the database will be open on the new instance. This may result in the new instance starting in a mode that does not match the start option recorded with Oracle Clusterware for the database.
https://docs.oracle.com/database/121/DGBKR/dbresource.htm#DGBKR150
If the new primary was a logical standby before the role transition, then all other logical standbys in the configuration become standbys of the new primary, but physical standbys in the configuration continue to be standbys of the old primary and therefore, do not protect the new primary. In the latter case, a future switchover or failover back to the original primary database returns all standbys to their original role as standbys of the current primary. For the reasons described above, a physical standby is generally the best role transition target in a configuration that contains both physical and logical standbys.
There is no need to shut down and restart any logical standby databases that are in the Oracle Data Guard configuration.
All other logical standbys in the configuration become standbys of the new primary, but any physical standby databases remain standbys of the original primary database.
https://docs.oracle.com/database/121/SBYDB/role_management.htm#SBYDB00635
A snapshot standby cannot be the target of a role transition. To use a snapshot standby database as a target for a role transition, first convert it to a physical standby database and allow all redo received from the primary database to be applied.
B,D,F