1Z0-1151-25 Question 103
Select 2You have an Oracle Database running on an Azure virtual machine for your production environment. Your company wants to ensure high availability and disaster recovery by creating a physical standby database on Oracle Cloud Infrastructure (OCI) using Oracle Data Guard. Which two of the following steps must you take to configure this cross-cloud Data Guard solution successfully?
- A
Enable the Data Guard broker on both the primary (Azure) and standby (OCI) databases, ensuring network connectivity is properly configured between both clouds.
- B
Upgrade the database from Oracle Database 19c to 21c, because 19c does not support cross-cloud Data Guard configurations.
- C
Establish private network connectivity between the Azure VNet and OCI VCN via ExpressRoute or FastConnect to enable secure and low-latency replication.
- D
Disable the Archivelog mode on the primary database to ensure rapid log shipping to the standby.
Show answer and explanation
Correct answers: A, C
Explanation
In this scenario, the primary database in Azure and the standby database in OCI must be connected via a secure private network to enable Oracle Data Guard log transport. You should configure a Data Guard broker for easier administration and monitoring of the primary and standby databases. Disabling Archivelog mode would prevent log shipping to the standby, breaking Data Guard functionality. Oracle Database 19c remains supported for cross-cloud replication, so an upgrade to 21c is not strictly necessary. Refer to official Oracle documentation for Data Guard setup steps and best practices in cross-cloud deployments.
- A. Correct.
Option 1 is correct. You must enable and configure Data Guard broker on both the primary and standby databases, and ensure that required ports (for example, 1521) are open. Proper connectivity between the Azure production instance and the OCI standby is essential for log transport and synchronized operations.
- B. Incorrect.
Option 2 is incorrect. Oracle Database 19c supports cross-cloud Data Guard configurations as long as both sides are on compatible versions. There's no requirement to upgrade to 21c solely for cross-cloud Data Guard.
- C. Correct.
Option 3 is correct. Private or low-latency connectivity via ExpressRoute (Azure) and FastConnect (OCI) is a key requirement for reliable transport of redo logs and ensuring data protection. A secure connection between the Azure VNet and OCI VCN is essential.
- D. Incorrect.
Option 4 is incorrect. Archivelog mode must remain enabled in the primary database for Data Guard to function. Disabling Archivelog mode prevents log shipping entirely, making any standby configuration inoperative.