Which three are true concerning database states after a…

Which three are true concerning database states after a successful switchover?

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 readonly.

F.
If the former primary database became a physical standby database it will be in the same state as the former physical standby database



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Wim J

Wim J

A is incorrect

https://docs.oracle.com/database/121/DGBKR/sofo.htm#DGBKR335

If the switchover transitions a logical standby database to the primary role, then:
The original primary database will be switched to a logical standby role.
Neither the primary database nor the logical standby database needs to be restarted after the switchover completes.

As the former primary was open and no restart is required, the database keeps the open state.

B: correct

The new primary database is opened in read/write mode and redo transport services are started.

If the former physical standby database was running with real-time query enabled, the new physical standby database will run with real-time query enabled

C: incorrect

D: correct (opposite of A)

E: incorrect, only read only open (real time query) if the standby was real time query enabled. (see comments on answer B)

F: incorrect: will be read/write

correct answer: B,D ??

PK

PK

If the former primary database became logical standby it will be open read-write. Thus incorrect is A and correct is D.
New primary database will be open read-write. Thus incorrect C and B correct.
Switchover = switching roles between primary and standby including state of standby before switch. That means if the standby was logical standby the former primary will become also logical standby. If the standby was physical in read only mode (real time query) the former will become also physical standby in read only mode (real time query). Thus incorrect E and correct F.

Correct – B, D, F
Incorrect – A, C, E