1Z0-1123-25 Question 138
Single answerYour company has an on-premises Oracle Database 19c environment with 5 TB of critical data that must be migrated to an Exadata Cloud Service on OCI. Business stakeholders require near-zero downtime and want real-time synchronization during migration. They have a 1 Gbps dedicated FastConnect link to OCI. Which approach is most appropriate to achieve this objective?
- A
Use Oracle Data Pump with multiple parallel workers and a final incremental export/import cycle to catch up changes.
- B
Leverage Oracle Zero Downtime Migration (ZDM) in conjunction with Oracle GoldenGate for real-time data replication.
- C
Perform a manual RMAN backup to a local staging server, then restore the backup files to the Exadata Cloud Service.
- D
Use cross-platform transportable tablespaces with incremental backups to move the schema data.
Show answer and explanation
Correct answer: B
Explanation
In order to meet the near-zero downtime requirement, real-time replication is essential. Oracle Zero Downtime Migration (ZDM) helps automate the migration, while Oracle GoldenGate ensures continuous data capture and apply from the source database to the target in OCI. This combination reduces downtime, increases automation, and ensures data consistency throughout the migration. Refer to Oracle documentation on ZDM and GoldenGate for detailed guidance on configuring and optimizing real-time replication.
- A. Incorrect.
Option 1: Using Oracle Data Pump with parallel processes can speed up data transfer, but it does not provide real-time replication. After the final export/import cycle, there could still be downtime when catching up on the last set of changes, which does not meet the near-zero downtime requirement.
- B. Correct.
Option 2: Oracle Zero Downtime Migration (ZDM) coupled with Oracle GoldenGate is designed to enable near-zero downtime migrations by replicating database transactions in real time. ZDM automates much of the process, while GoldenGate continuously captures and applies changes from the source to the target database, ensuring minimal disruption.
- C. Incorrect.
Option 3: Manually using RMAN backups typically involves creating a backup set on-premises, transferring it to OCI, and then restoring it. Although this is a valid method, it can involve higher downtime and does not natively provide real-time replication.
- D. Incorrect.
Option 4: Cross-platform transportable tablespaces can speed up data movement by moving only metadata and data file blocks. However, it does not include built-in real-time replication to synchronize ongoing changes, so additional downtime or extra steps would be needed.