1Z0-997-25 Question 71
Select 3Your organization hosts a mission-critical OLTP database on an Oracle Cloud Infrastructure Virtual Machine DB System in the Ashburn region. To minimize data loss and downtime, you plan to create a physical standby database in the Phoenix region using Oracle Data Guard. Which THREE steps or considerations are required to achieve this near-zero data loss configuration?
- A
- Enable Data Guard from the OCI Console, selecting a Standby DB System in another region and configuring Maximum Availability mode.
- B
- Use block volume cross-region replication to clone primary data files, then manually apply redo logs once per day.
- C
- Choose a Standby DB System with sufficient network bandwidth and configure feasible network paths to reduce latency between regions.
- D
- Open the Standby Database in read-write mode to run reporting workloads, relying on automatic continuous syncing from the primary.
- E
- Create standby redo logs on the standby database to enable real-time apply and reduce risk of data loss.
- F
- Schedule periodic archive log transfers via offline scripts for apply on the standby database.
Show answer and explanation
Correct answers: A, C, E
Explanation
To implement a near-zero data loss disaster recovery solution for your primary database on OCI, you should configure Data Guard with real-time redo transport to a physical standby in a different region. Using Maximum Availability mode, ensuring adequate network bandwidth, and enabling standby redo logs are critical steps. Refer to Oracle documentation (e.g., 'Using Oracle Data Guard on Oracle Cloud Infrastructure') for detailed best practices on setting up Data Guard associations, configuring protection modes, and fine-tuning network paths to achieve continuous and near-zero data loss protection.
- A. Correct.
Correct. Configuring Data Guard through the OCI Console with Maximum Availability mode ensures that redo data is continuously transported and applied, minimizing data loss between the primary and standby databases across regions.
- B. Incorrect.
Incorrect. While block volume cross-region replication can move data files, you would still need continuous redo shipping for near-zero data loss. Manually applying redo once per day introduces a significant delay and likely data loss.
- C. Correct.
Correct. Ensuring that the Standby DB System has sufficient network bandwidth and selecting a lower-latency path between the two regions helps reduce round-trip time for redo data and enhances near-zero data loss capabilities.
- D. Incorrect.
Incorrect. Opening the standby in read-write mode breaks the physical standby synchronization. A physical standby must remain in either a read-only or mounted state for real-time apply. Converting it to read-write halts Data Guard protection.
- E. Correct.
Correct. Standby redo logs enable real-time apply on the standby database, which is a key component in achieving minimal or zero data loss while continuously applying incoming redo.
- F. Incorrect.
Incorrect. Relying on manual archive log transfers via offline scripts creates a gap in real-time application of redo, leading to potential data loss and longer recovery times.