1Z0-997-25 Question 135
Single answerYou are an OCI Architect tasked with migrating a 15 TB on-premises Oracle Database to Oracle Cloud Infrastructure. The business demands minimal downtime, and security regulations prohibit shipping physical drives. Which approach should you recommend to achieve a streamlined migration with minimal downtime?
- A
Export the entire database with Data Pump, upload the dump files to OCI Object Storage, and import into a new Oracle Database system.
- B
Use Oracle Zero Downtime Migration (ZDM) to orchestrate an online migration leveraging Oracle Data Guard or GoldenGate under the hood.
- C
Copy datafiles manually via secure SCP transfers, then use RMAN to rebuild the control files in OCI.
- D
Schedule rolling backups using tape backup software, then ship tapes to an Oracle data center for offline import.
Show answer and explanation
Correct answer: B
Explanation
For large databases that require minimal downtime and cannot rely on offline data shipping, Oracle Zero Downtime Migration (ZDM) is the recommended approach. It provides end-to-end orchestration, automating the migration steps and significantly reducing application downtime. Refer to the Oracle Zero Downtime Migration guide for more details on using Oracle Data Guard or GoldenGate through ZDM to achieve near-zero downtime (docs.oracle.com).
- A. Incorrect.
Option 1: While Data Pump is a straightforward tool, exporting and importing a 15 TB database would be time-consuming and typically requires more downtime, making this approach less suitable for minimal downtime requirements.
- B. Correct.
Option 2: Oracle Zero Downtime Migration (ZDM) automates and streamlines the migration process for large databases, offering near-zero or minimal downtime by utilizing Oracle Data Guard or GoldenGate workflows. It is designed specifically for large-scale production database migrations to OCI.
- C. Incorrect.
Option 3: Copying datafiles manually is prone to human error, lacks orchestration for large volumes of data, and usually requires extended downtime to ensure data consistency.
- D. Incorrect.
Option 4: Shipping tapes for offline data transfer would violate the stated security regulations and introduce significant delays and complexities, making it unsuitable for minimal downtime.