1Z0-1151-25 Question 105
Select 2You are designing a high availability and disaster recovery strategy for a mission-critical Oracle Database@Azure deployment. The business requires near-zero downtime for both planned maintenance and unexpected hardware failures in the Azure region, and they also need an offsite disaster recovery solution in Oracle Cloud Infrastructure (OCI) to minimize data loss. Which two configurations best meet these requirements?
- A
Deploy a multi-node Oracle RAC in Azure for local high availability and configure asynchronous Oracle Data Guard to a standby in OCI.
- B
Deploy a single-instance Oracle Database in Azure, rely on local daily backups, and periodically copy backup files to OCI for disaster recovery.
- C
Enable synchronous Oracle Data Guard from Azure to OCI for zero data loss and rely on manual switchover in the event of local hardware failures for HA.
- D
Use Oracle RAC in the Azure region for local HA and leverage Oracle GoldenGate real-time replication to an OCI environment for DR.
Show answer and explanation
Correct answers: A, D
Explanation
Oracle Database@Azure environments can achieve local HA using Oracle RAC, which protects against node or hardware failures. For disaster recovery, Oracle Data Guard and Oracle GoldenGate are proven solutions to maintain a geographically separated standby database. Asynchronous Data Guard avoids performance overhead from cross-cloud latency and offers near-zero data loss, while GoldenGate provides flexible and near real-time replication. For further details and best practices, refer to Oracle's Maximum Availability Architecture (MAA) documentation as well as official Oracle Database@Azure guides.
- A. Correct.
Correct. Using Oracle RAC in Azure provides local high availability to handle node or hardware failures seamlessly. Asynchronous Oracle Data Guard to OCI then ensures an offsite standby with minimal data loss risk, fulfilling DR requirements.
- B. Incorrect.
Incorrect. Relying solely on daily backups for disaster recovery introduces significant potential data loss if a failure occurs before the next backup. It also does not address continuous high availability for local failures.
- C. Incorrect.
Incorrect. While synchronous Data Guard theoretically ensures zero data loss, cross-cloud network latency typically makes synchronous replication impractical or performance-degrading. Additionally, it does not provide automatic local HA for hardware failures in Azure.
- D. Correct.
Correct. RAC handles local high availability, while Oracle GoldenGate continuously replicates changes from Azure to OCI in near real-time. This approach delivers both immediate failover capabilities in Azure and robust DR in OCI.