1Z0-1067-25 Question 80
Select 2Your company runs a mission-critical application on an Oracle Database System in the primary region, with a Data Guard standby in a secondary region for disaster recovery. You have been tasked with enabling automated failover so that the standby database takes over role as primary if the primary becomes inaccessible. Which two configurations must you implement to achieve a fully automated failover with minimal downtime?
- A
A. Enable Fast-Start Failover (FSFO) on the Data Guard broker and configure an observer process on a separate host.
- B
B. Deploy a second observer in the same availability domain (AD) as the primary database for higher availability of FSFO.
- C
C. Manually open the standby in read/write mode immediately after any network disruption is detected.
- D
D. Configure Data Guard protection mode and FSFO threshold parameters (e.g., transport lag, observer wait time) according to your RPO/RTO requirements.
Show answer and explanation
Correct answers: A, D
Explanation
To implement automated failover on Oracle Cloud Infrastructure using Data Guard, you must enable Fast-Start Failover in the Data Guard broker and configure an observer on a separate, independent host. You should also define a suitable Data Guard protection mode and set thresholds that determine when a failover is triggered. Placing the observer in a different Availability Domain or region from both the primary and standby is recommended for higher resilience. For more details, consult Oracle's official documentation on configuring Oracle Data Guard on OCI, particularly the sections covering Fast-Start Failover configuration and best practices.
- A. Correct.
A. Correct. Enabling Fast-Start Failover and configuring an observer process on a separate, reliable host is critical. The observer monitors the primary database, and if it becomes unavailable under the set thresholds, it automatically triggers failover to the standby.
- B. Incorrect.
B. Incorrect. Although having a second observer can improve availability, placing it in the same AD as the primary database is not ideal for automated failover resilience�if that AD is down, both the primary and the observer are affected.
- C. Incorrect.
C. Incorrect. Manually opening the standby in read/write mode defeats the purpose of automated failover. Fast-Start Failover automatically handles the role transition without manual intervention.
- D. Correct.
D. Correct. Configuring the Data Guard protection mode (e.g., Maximum Availability or Maximum Performance) and setting thresholds (transport lag, observer wait time, etc.) is essential for Fast-Start Failover to work correctly and align with business RPO/RTO requirements.