1Z0-1151-25 Question 47
Select 2Your organization runs a critical financial application on Oracle Cloud Infrastructure (OCI) using a Base Database system with a physical standby configured in another Availability Domain for disaster recovery. Management requires that the application remain operational during the next scheduled patching window. Which TWO steps should you take to minimize downtime while applying patches to the environment?
- A
A. Apply the patch to the standby database first, perform a switchover to the standby, and then patch the original primary.
- B
B. Take a full backup of the primary database, then apply the patch directly on the primary; if the patch fails, restore from backup.
- C
C. Use the Data Guard Rolling Upgrade (Transient Logical Standby) approach to apply the patch with minimal downtime.
- D
D. Patch both the primary and standby simultaneously, relying on Automatic Failover to occur if the patch disrupts the primary.
Show answer and explanation
Correct answers: A, C
Explanation
To achieve near-zero downtime during patching of OCI Base Databases with physical standby, the recommended approaches involve either patching the standby first and performing a controlled switchover (Option A) or using the Data Guard Rolling Upgrade method (Option C). Both strategies allow the standby to be updated without affecting the primary's availability. After the standby is patched, you switch roles so the patched standby becomes the new primary, letting you patch the old primary with minimal impact on ongoing operations. Refer to Oracle Data Guard documentation for details on configuring rolling upgrades and switchover procedures.
- A. Correct.
Option A is correct. This approach leverages the physical standby by patching it first and then switching over to make it the new primary. Once the original standby is running as the primary, you can patch the old primary database with minimal downtime.
- B. Incorrect.
Option B is incorrect. While taking a backup is a best practice, simply patching the primary without leveraging the standby for a switchover will result in application downtime if the primary is offline during the patch process.
- C. Correct.
Option C is correct. The Data Guard Rolling Upgrade (Transient Logical Standby) method allows you to convert the standby to a logical standby temporarily, apply patches, and then switch over to minimize downtime on the production database.
- D. Incorrect.
Option D is incorrect. Applying patches on both the primary and standby at exactly the same time is risky. There is no guarantee the failover would be seamless if the primary encounters issues mid-patch.