1Z0-997-25 Question 154
Single answerYour organization is migrating a 20 TB on-premises Oracle Database to an Oracle Database Cloud Service on OCI. The team has a 1 Gbps network link and mandates minimal downtime for the migration. They also require a validation phase to ensure data integrity before the final production cutover. Which solution should you recommend?
- A
Use Oracle Data Pump only to perform a full export from on-premises and then a full import to the target database
- B
Employ an RMAN backup-and-restore approach from on-premises to OCI using the OCI Backup Module without any additional tools
- C
Implement Zero Downtime Migration (ZDM) to automate a Data Pump-based migration and use Oracle GoldenGate for near real-time data synchronization before cutover
- D
Perform a one-time data transfer using OCI Data Transfer Appliance and overwrite the on-premises database upon completion
Show answer and explanation
Correct answer: C
Explanation
Zero Downtime Migration (ZDM) automates the entire process of migrating large databases to OCI, leveraging Oracle Data Pump for bulk data movement and Oracle GoldenGate for ongoing replication to achieve minimal downtime. ZDM also ensures you can validate data before cutover, aligning with enterprise requirements. For more details, refer to Oracle� official documentation on Zero Downtime Migration and GoldenGate best practices.
- A. Incorrect.
Option A is incorrect because relying solely on Data Pump for a large 20 TB database over a 1 Gbps link can cause extended downtime, failing the minimal downtime requirement.
- B. Incorrect.
Option B is incorrect because although RMAN backup-and-restore is a valid method, it does not include real-time replication or structured synchronization, making it harder to validate data while minimizing application downtime.
- C. Correct.
Option C is correct. Zero Downtime Migration (ZDM) integrates Oracle Data Pump for initial data transfer and Oracle GoldenGate for near real-time replication. This combination ensures minimal downtime and provides a validation phase prior to the final cutover.
- D. Incorrect.
Option D is incorrect because OCI Data Transfer Appliance is typically used for physical data transfer but doesn�t inherently address continuous replication or validation prior to cutover. Also, overwriting the on-premises database before validation poses risks to data integrity.