1Z0-1151-25 Question 102
Select 2An enterprise runs a critical Oracle Database workload in Microsoft Azure and wants to set up a high availability and disaster recovery (HA/DR) environment by deploying a standby database on Oracle Cloud Infrastructure (OCI). They have already established a dedicated private interconnect between Azure and OCI with sufficient bandwidth and low latency. They aim for near-zero data loss (Maximum Availability). Which TWO actions must be taken to properly configure Data Guard in synchronous mode between the primary database on Azure and the standby on OCI?
- A
Enable Force Logging, Flashback Database, and standby redo logs on the primary database before configuring Data Guard.
- B
Create a database link that uses public Internet endpoints to connect between the primary and standby databases.
- C
Set the Data Guard protection mode to Maximum Availability and ensure synchronous redo transport is configured if network latency allows.
- D
Use asynchronous redo transport to avoid any performance impact on the primary database.
Show answer and explanation
Correct answers: A, C
Explanation
For a Data Guard setup to achieve near-zero data loss between Azure and OCI, you must use synchronous redo transport (Maximum Availability or Maximum Protection mode) and ensure that all best practice prerequisites � such as Force Logging, Flashback Database, and standby redo logs � are in place on the primary. The dedicated private interconnect helps maintain low latency, making synchronous replication feasible. For more details, refer to the Data Guard Concepts and Administration Guide in Oracle Documentation.
- A. Correct.
Option 1: Correct. Enabling Force Logging ensures that all transactions are logged, standby redo logs are needed for real-time apply, and enabling Flashback Database helps in quickly resolving data-related issues on both the primary and standby. These are standard prerequisites in Data Guard setups for near-zero data loss.
- B. Incorrect.
Option 2: Incorrect. Using a public endpoint over the Internet would introduce additional latency and potential security risks. A private and stable interconnect is essential for synchronous redo transport in a Data Guard environment requiring near-zero data loss.
- C. Correct.
Option 3: Correct. Configuring the protection mode to Maximum Availability along with synchronous redo transport is key to achieving near-zero data loss, provided the network latency is sufficiently low and bandwidth is adequate. This mode ensures that transactions are not acknowledged at the primary until they are safely written to the standby's redo logs.
- D. Incorrect.
Option 4: Incorrect. Asynchronous redo transport (Maximum Performance mode) mitigates performance impacts but does not provide near-zero data loss. Critical data changes could be lost if a failure occurs before shipping the redo from the primary to the standby.