1Z0-1123-25 Question 136
Select 2You need to migrate a 10 TB on-premises Oracle Database 19c to an Autonomous Database (shared Exadata infrastructure) in OCI with minimal downtime. Your on-premises environment has constraints in network bandwidth for large data transfers, but you need to complete the migration in a tight production window. Which TWO strategies should you include in your migration plan to achieve minimal downtime and a reliable cutover?
- A
Use Oracle GoldenGate replication to stream changes to the Autonomous Database after seeding the data.
- B
Rely solely on Oracle Data Pump for an offline export/import during the maintenance window.
- C
Leverage Zero Downtime Migration (ZDM) to perform a hybrid migration with both bulk data loading and GoldenGate replication.
- D
Set up a Data Guard standby directly between the on-premises database and the Autonomous Database.
Show answer and explanation
Correct answers: A, C
Explanation
To achieve a minimal downtime migration of a large on-premises database to OCI� Autonomous Database, combining a bulk data load with continuous change synchronization is key. Oracle GoldenGate or Zero Downtime Migration (ZDM) can be used to reduce maintenance windows significantly by replicating data changes in near-real time. Oracle Data Pump alone, used offline, can cause extended downtime due to the export/import process. Data Guard is not currently supported for establishing a standby Autonomous Database. For more details, see the Oracle Cloud Infrastructure documentation on ZDM and GoldenGate integration with Autonomous Databases.
- A. Correct.
Correct. GoldenGate enables continuous data replication to the target database, allowing you to seed the database and then apply incremental changes. This approach aligns well with minimal downtime requirements, as the final switchover can be short once the database is in sync.
- B. Incorrect.
Incorrect. While Data Pump can be used for bulk loading, using it alone in an offline manner can be time-consuming and network-intensive, leading to considerable downtime. The question specifically states a requirement for minimal downtime, making a purely offline approach less suitable.
- C. Correct.
Correct. Zero Downtime Migration (ZDM) provides an orchestrated process that can combine Oracle Data Pump for initial bulk loading with GoldenGate for near-real-time replication of changed data�ideal for large databases with limited downtime windows.
- D. Incorrect.
Incorrect. Data Guard is not supported for creating a standby directly to an Autonomous Database. Data Guard standby configurations are supported for Oracle Database Cloud Services (like DB Systems), but not for Autonomous Database targets.