1Z0-076 practice question 17 of 25

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

Answer options

A: The new primary database will be open read-write. Correct answer

B: If the former primary database became a logical standby database it will be in mount state.

C: If the former primary database became a logical standby database it will be open read-write. Correct answer

D: If the former primary database became a physical standby database it will be in the same state as the former physical standby database. Correct answer

E: If the former primary database became a physical standby database it will always be open readonly.

F: The former primary database will always be open.

Correct Answer:

A. The new primary database will be open read-write.; C. If the former primary database became a logical standby database it will be open read-write.; D. If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

Explanation

After a successful switchover:
• The standby that becomes primary is immediately opened read-write (A).
• If the former primary becomes a logical standby, it is opened read-write so SQL Apply can run (C).
• If the former primary becomes a physical standby, it is placed in the same state (mounted or open read-only) that the original standby previously had (D).

Why Incorrect

B. A new logical standby is not left mounted; it is opened.
E. A new physical standby may be mounted, not necessarily open read-only.
F. Former primary is not always open; its state depends on the target standby type.

References

1. Oracle® Data Guard Concepts and Administration 19c, 8.3 “Performing a Switchover”, Table 8-2 “Database States After Switchover”.

2. Oracle® Data Guard Broker Admin Guide 19c, 7.3 “Switchover” (state discussion).

Keep practicing

Take the free 1Z0-076 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test