1Z0-1151-25 Question 100
Select 2Your company runs a mission-critical Oracle Database on an Azure VM and wants to implement a high availability and disaster recovery solution using Oracle Data Guard with a standby database in Oracle Cloud Infrastructure (OCI). Which two steps must you perform to successfully set up and maintain Data Guard across the Azure-OCI connection?
- A
Enable ARCHIVELOG mode and FORCE LOGGING on the primary database before configuring Data Guard.
- B
Open all inbound ports to the public internet on the standby database for uninterrupted redo traffic.
- C
Establish a secure network connection (VPN, FastConnect, or similar) between Azure and OCI for Data Guard traffic.
- D
Install a different version of Oracle Database in OCI to ensure tighter software isolation.
Show answer and explanation
Correct answers: A, C
Explanation
When implementing High Availability (HA) and Disaster Recovery (DR) for Oracle Database on Azure using Data Guard with a standby in OCI, it is essential to run the database in ARCHIVELOG mode and enable FORCE LOGGING on the primary. This ensures that all redo data required for recovery is captured and transmitted. A secure network connection (for example, VPN or FastConnect) between Azure and OCI is critical to protect data and maintain reliable redo transport. Refer to Oracle Data Guard documentation (e.g., Oracle Database Documentation for Data Guard Administration) for detailed guidelines on configuration steps, supported topologies, and security considerations.
- A. Correct.
Correct. ARCHIVELOG mode and FORCE LOGGING on the primary database are required for Data Guard to capture and ship redo data reliably. Without these, critical redo data may not be logged properly, preventing synchronous or asynchronous standby updates.
- B. Incorrect.
Incorrect. Opening all ports to the public internet is neither secure nor necessary. Data Guard redo traffic should be restricted to private or secured network paths, to limit exposure and comply with best practices.
- C. Correct.
Correct. You need a secure connection between Azure and OCI�such as a site-to-site VPN, ExpressRoute with OCI FastConnect, or another approved method�to transmit redo logs. This ensures data integrity and compliance with security standards.
- D. Incorrect.
Incorrect. The standby database must run the same Oracle Database version and patch level to avoid compatibility issues. Using a different version can lead to Data Guard errors and compromised recovery.