1Z0-1123-25 Question 2
Single answerA financial services company needs to migrate a 5 TB on-premises Oracle Database to Oracle Cloud Infrastructure. The database supports mission-critical applications where downtime must be kept to an absolute minimum. The company has enough lead time to plan and a reliable network to Oracle Cloud. Which migration approach provides the least production impact while meeting the minimal downtime requirement?
- A
Use Oracle Data Pump to perform a full export/import while taking the database offline
- B
Implement Oracle Zero Downtime Migration (ZDM) with Oracle GoldenGate to replicate changes in near real-time
- C
Perform an offline backup using the Oracle Data Transfer Appliance and restore to OCI
- D
Manually copy RMAN backup sets to OCI object storage and import them with a script
Show answer and explanation
Correct answer: B
Explanation
For cloud migrations where downtime must be minimized, Oracle Zero Downtime Migration (ZDM) combined with Oracle GoldenGate replication is a recognized best practice. GoldenGate keeps the on-premises and cloud databases in sync, allowing cutover to the OCI environment with minimal disruption. Refer to Oracle� Zero Downtime Migration documentation (https://docs.oracle.com/en/solutions/oci-zdm/index.html) for implementation details and best practices.
- A. Incorrect.
Option 1: This involves taking the source database offline for the duration of the export/import, which can lead to significant downtime. While Data Pump is a straightforward approach, it does not meet the minimal downtime requirement for mission-critical workloads.
- B. Correct.
Option 2: This is correct. Oracle Zero Downtime Migration (ZDM) orchestrates the migration process, and using Oracle GoldenGate allows for near real-time replication of changes. The on-premises database remains operational during most of the migration, reducing downtime to a minimal cutover window.
- C. Incorrect.
Option 3: While the Oracle Data Transfer Appliance is efficient for migrating large volumes of data, it typically requires an offline approach. This does not support continuous replication or minimal downtime because you must ship data physically and then restore it in the cloud.
- D. Incorrect.
Option 4: Manually copying RMAN backups to OCI object storage can work but introduces more steps and potential manual errors. It also requires downtime while the production database is backed up and restored, which is not optimal for mission-critical services demanding minimal downtime.