1Z0-1067-25 Question 83
Select 2Your organization runs a mission-critical Oracle Database in the Ashburn region on OCI, with a Data Guard standby in the Phoenix region for disaster recovery. You need to minimize downtime by enabling automatic failover if the primary database becomes unavailable. Which TWO configurations must be implemented to ensure that a fast-start failover automatically occurs?
- A
Enable the Data Guard broker and configure fast-start failover settings on both the primary and standby databases
- B
Disable Archive Logging mode to speed up replication and rely on real-time apply
- C
Set up and register an Observer in a separate host or region for continuous monitoring and automatic failover initiation
- D
Manually initiate failover only after verifying that the primary database is completely unreachable
- E
Configure a MySQL Database System with integrated replication for instant failover regardless of Oracle Database settings
Show answer and explanation
Correct answers: A, C
Explanation
To implement automated failover with minimal downtime, you must enable the Data Guard broker and fast-start failover (FSFO), and set up a dedicated Observer to monitor the primary. If the Observer detects a loss of connectivity with the primary, it automatically initiates failover to the standby. Refer to the Oracle Cloud Infrastructure Data Guard documentation for detailed guidance on configuring and deploying fast-start failover.
- A. Correct.
Option 1: Correct. Enabling the Data Guard broker and configuring fast-start failover on the primary and standby is essential for automatic monitoring and failover handling. The broker automates role transitions and enforces the failover configuration.
- B. Incorrect.
Option 2: Incorrect. Data Guard requires a properly configured Archive Log mode to protect data. Disabling it would break the Data Guard arrangement and eliminate critical redundancy and recovery capabilities.
- C. Correct.
Option 3: Correct. An Observer is a separate process that monitors the health of the primary database and automatically initiates failover when the primary is deemed non-operational. Deploying it in a different region or host is a best practice for reliability.
- D. Incorrect.
Option 4: Incorrect. Manually initiating failover contradicts the requirement for automation. In fast-start failover configurations, the Observer and broker handle the failover process.
- E. Incorrect.
Option 5: Incorrect. Configuring a MySQL Database System for replication won't automate failover for an Oracle Database. Oracle Data Guard is specific to Oracle Database environments.