1Z0-997-25 Question 29
Single answerYou manage an online retail platform running in a primary OCI region with multiple Availability Domains. The platform includes a mission-critical Oracle Database that must remain continuously available with minimal data loss, even during a full regional outage. Which design best meets these high availability and disaster recovery requirements?
- A
Deploy the database on multiple compute instances in a single Availability Domain, then replicate database backups daily to the Object Storage in the same region.
- B
Implement a two-node Oracle RAC spanning two Availability Domains in the primary region, with replication to a second region using Data Guard in asynchronous mode.
- C
Use a single Database system in the primary region and schedule weekly offline backups to a second region for disaster recovery.
- D
Set up an Oracle RAC in the primary region and configure a physical standby database in maximum protection mode using Data Guard in another region.
Show answer and explanation
Correct answer: D
Explanation
Designing for both high availability and disaster recovery typically involves local redundancy (such as Oracle RAC across multiple Availability Domains) and remote replication (such as Data Guard) to another region. Maximum protection mode ensures no data loss by waiting for remote writes to complete before committing transactions. For additional details, refer to Oracle documentation on Data Guard Protection Modes and High Availability RAC configurations.
- A. Incorrect.
Option 1 is incorrect. While storing daily backups in Object Storage offers some backup and restore capability, it does not provide continuous data replication or meet near-zero data loss requirements in a regional outage scenario.
- B. Incorrect.
Option 2 is partially correct in providing local high availability and an offsite standby. However, asynchronous Data Guard may incur minimal data loss, and this option does not explicitly aim for near-zero data loss in the event of a region-wide failure if network latency affects the asynchronous log shipping.
- C. Incorrect.
Option 3 is incorrect. Relying on weekly offline backups provides a Recovery Point Objective (RPO) that is too large for a mission-critical, continuously available application, and it does not address real-time failover requirements.
- D. Correct.
Option 4 is correct. Oracle RAC provides high availability within the primary region by spanning multiple Availability Domains, and a physical standby database in maximum protection mode ensures transactional consistency in a remote region, meeting both minimal data loss and disaster recovery objectives.