1Z0-997-25 Question 75
Single answerYour company hosts a mission-critical transaction processing system on an Oracle Database VM DB System in OCI. You need to apply the latest quarterly patch with minimal downtime while also ensuring business continuity in case of an Availability Domain (AD) failure within the same region. Which approach provides the best balance of minimal patching downtime and high availability?
- A
Configure Oracle Data Guard with a standby database in a different AD and perform a rolling upgrade.
- B
Temporarily shut down the primary database, apply the patch, and restart the database in the same AD.
- C
Convert the database to an Autonomous Database and rely on automated patching in a single AD deployment.
- D
Create a new VM DB System in the same AD, manually copy the data, and patch the new instance.
Show answer and explanation
Correct answer: A
Explanation
Using Oracle Data Guard with a standby in a different Availability Domain and performing rolling patching is a recommended practice in OCI to minimize downtime and ensure availability across AD failures. By patching the standby first and then switching roles, you achieve near-continuous operation. Refer to the Oracle Cloud Infrastructure Database Documentation on Data Guard for detailed steps and best practices.
- A. Correct.
Correct. With Oracle Data Guard, you can create a physical standby in a separate Availability Domain and perform a rolling upgrade by patching the standby first. Once verified, you can switch roles, minimizing downtime. This approach also maintains high availability in case of AD-level failures, aligning with OCI best practices.
- B. Incorrect.
Incorrect. Stopping the primary database and applying the patch on the same system incurs significant downtime. This approach does not provide a separate standby for high availability in case of AD failure.
- C. Incorrect.
Incorrect. Moving directly to an Autonomous Database can simplify patching, but deploying in a single AD doesn't address the resiliency requirement. You also cannot perform a rolling patch on Autonomous Databases in a user-controlled manner, so downtime reduction depends on Oracle� internal patch schedule.
- D. Incorrect.
Incorrect. Manually creating a new VM DB System in the same AD and copying data is time-consuming, introduces more risk, and does not ensure high availability if the AD becomes unavailable. It also does not minimize downtime effectively compared to a Data Guard switchover.