1Z0-1123-25 Question 147
Select 2You have been tasked with migrating a mission-critical 24/7 on-premises Oracle Database to the Oracle Cloud Infrastructure (OCI) Database Service. Minimizing downtime and ensuring accurate data transfer are key project requirements. Which two methods would best meet these objectives?
- A
Using Oracle Data Pump Export/Import to move data in a single operation
- B
Leveraging Oracle Zero Downtime Migration (ZDM) for automated, minimized-downtime migration
- C
Using Oracle GoldenGate for real-time data replication to the target database
- D
Performing a cross-platform backup and restore with RMAN
Show answer and explanation
Correct answers: B, C
Explanation
For mission-critical databases where minimal downtime is paramount, Oracle recommends solutions that allow continuous or near-continuous data replication. Oracle Zero Downtime Migration (ZDM) automates much of the migration process and can leverage Oracle GoldenGate for real-time replication. These tools help ensure minimal impact to production operations. Refer to Oracle's Best Practices for Zero Downtime Migration and Oracle GoldenGate documentation for detailed implementation guidelines.
- A. Incorrect.
Option 1: Oracle Data Pump Export/Import is straightforward and useful for smaller or less time-sensitive databases, but it requires a full export and import cycle. This generally incurs longer downtime, making it less suitable for strict minimal-downtime requirements.
- B. Correct.
Option 2: Oracle Zero Downtime Migration (ZDM) automates and orchestrates end-to-end migrations, often combining incremental backups and data replication. It is designed specifically to minimize downtime and reduce manual intervention, making it a recommended approach for mission-critical migrations.
- C. Correct.
Option 3: Oracle GoldenGate provides real-time data replication. By continuously applying changes from the source database to the target, downtime can be drastically reduced or even nearly eliminated. It is a widely used strategy for high-availability migrations.
- D. Incorrect.
Option 4: RMAN cross-platform backup and restore may work for heterogeneous environments, but it typically involves stopping the source database for a snapshot and restoring on the target. While it is feasible, it does not provide the near-zero downtime or continuous replication capabilities needed for truly mission-critical workloads.