1Z0-1123-25 Question 149
Select 2Your organization hosts a 12 TB on-premises Oracle Database 19c that needs to be migrated to Oracle Autonomous Database (Shared Exadata Infrastructure) in OCI. The business requires minimal downtime, given a limited cutover window, and the migration must maintain transaction consistency. Which two migration methods would best meet these requirements?
- A
Use Oracle Data Pump to export and import all data during the scheduled outage
- B
Use Oracle GoldenGate to continuously replicate on-premises changes to the target environment
- C
Use Zero Downtime Migration (ZDM) to automate and orchestrate a near-zero-downtime migration
- D
Use RMAN cross-platform transport and manually handle all post-migration tasks
- E
Use operating system file copy to move data files, then apply rolling logs at cutover
Show answer and explanation
Correct answers: B, C
Explanation
For large databases requiring minimal downtime, near-real-time solutions like Oracle GoldenGate or automated frameworks like Zero Downtime Migration are ideal. They ensure continuous data movement and synchronization, reducing production downtime. Oracle� official documentation recommends Zero Downtime Migration (ZDM) for seamless automation and near-zero-downtime transitions, while GoldenGate is a proven strategy for real-time replication. For further details, refer to the Oracle Cloud Infrastructure documentation on Database Migration Methods, GoldenGate Best Practices, and ZDM Implementation Guides.
- A. Incorrect.
Option 1 (Oracle Data Pump) - INCORRECT: While Oracle Data Pump is a straightforward method, it typically requires a full export and import cycle. For large databases (like 12 TB) and limited downtime, Data Pump alone may force an extended outage, which does not fit the minimal downtime requirement.
- B. Correct.
Option 2 (Oracle GoldenGate) - CORRECT: GoldenGate allows near-real-time replication from on-premises to OCI. This reduces cutover to a short window because data is kept in sync, making it suitable for large databases that need minimal downtime.
- C. Correct.
Option 3 (Zero Downtime Migration) - CORRECT: ZDM provides an automated framework to minimize downtime by managing data transfer and synchronization workflows. It� designed to handle large data volumes while orchestrating workload migrations to Oracle Cloud platforms.
- D. Incorrect.
Option 4 (RMAN cross-platform transport) - INCORRECT: RMAN cross-platform transport can work for migrating data, but it usually requires significant manual handling and downtime. It� less seamless than GoldenGate or ZDM for large-scale production workloads.
- E. Incorrect.
Option 5 (Operating system file copy) - INCORRECT: Copying data files at the OS level and then applying incremental logs is manual and prone to errors. It also requires you to manage downtime carefully, which can be unpredictable and lengthy for a 12 TB database.