1Z0-1067-25 Question 81
Select 2You are managing a production Oracle Database on OCI with a Data Guard standby deployed in a different region for disaster recovery. To minimize downtime, your team wants to implement fast-start failover, so that if the primary database is unavailable, failover to the standby happens automatically. Which two configurations are required to ensure fast-start failover works properly?
- A
- Install the Data Guard Observer in a separate location (third site) from both the primary and standby databases.
- B
- Configure the standby in Maximum Performance mode with real-time apply, and set the FS_FAILOVER_THRESHOLD parameter.
- C
- Disable the Data Guard Broker to prevent it from overriding manual failover decisions.
- D
- Host the primary and standby databases in the same Availability Domain to reduce network latency.
- E
- Change the Protection Mode to Maximum Protection on the primary for zero data loss.
Show answer and explanation
Correct answers: A, B
Explanation
Fast-start failover in Oracle Data Guard relies on the Data Guard Broker and the Observer for automatic failover. You configure the Observer in a separate location to ensure an independent perspective on when the primary is truly unavailable. Real-time apply in Maximum Performance mode is commonly used, along with thresholds such as FS_FAILOVER_THRESHOLD, to define when failover should occur. For details, reference Oracle Data Guard documentation on configuring fast-start failover.
- A. Correct.
Option 1: Correct. For automated failover with fast-start failover, you need the Data Guard Observer running on a system that is separate from both the primary and standby databases. This ensures the observer can detect a primary failure and coordinate an automatic failover if the primary is not reachable.
- B. Correct.
Option 2: Correct. Maximum Performance with real-time apply is a common configuration for fast-start failover because it balances performance with data protection. Setting the FS_FAILOVER_THRESHOLD parameter controls how long the observer waits before initiating the failover, ensuring automatic switchover happens if the primary is unresponsive.
- C. Incorrect.
Option 3: Incorrect. Data Guard Broker must be enabled for fast-start failover, as the broker manages and monitors both the primary and standby databases and coordinates the failover process.
- D. Incorrect.
Option 4: Incorrect. Placing both databases in the same Availability Domain defeats the purpose of high availability and resiliency. For effective DR, it is recommended to have the standby in a different Availability Domain or region.
- E. Incorrect.
Option 5: Incorrect. While Maximum Protection ensures zero data loss, it may cause the primary to halt transactions if the standby is unavailable. Most automated failover configurations use Maximum Availability or Maximum Performance to balance protection with uptime. Maximum Protection is typically only used for extremely sensitive data with stringent SLAs.