1Z0-997-25 Question 140
Single answerYour organization is planning to migrate a 10 TB on-premises Oracle Database to OCI. Network bandwidth is limited, and your leadership team wants to minimize production downtime. Which approach provides a practical way to reduce downtime while ensuring data consistency and minimal operational overhead?
- A
Use Oracle Data Transfer Appliance to transfer the bulk of the data offline first, then configure Oracle GoldenGate for near-real-time replication before final cutover.
- B
Compress the on-premises database dumps with Data Pump and upload daily to OCI Object Storage over the internet until you are ready for final import.
- C
Perform an offline forklift migration by shutting down the on-premises database, backing it up, and shipping tapes to OCI for restoration.
- D
Use only backup-based migration tools to move the entire database without any replication step, restoring from a single final backup in OCI.
Show answer and explanation
Correct answer: A
Explanation
In scenarios with large databases and minimal downtime requirements, combining an offline bulk transfer (such as Oracle Data Transfer Appliance) with a real-time replication tool (like Oracle GoldenGate) is a best practice. By first seeding the data offline, you avoid lengthy transfers over limited bandwidth. Oracle GoldenGate then keeps your on-premises and OCI databases in sync, allowing a quick final switchover. For additional details, refer to Oracle� documentation on Database Migration in the Oracle Cloud Infrastructure Architecture Center and GoldenGate best practices.
- A. Correct.
Correct. This approach leverages offline bulk transfer to handle the large initial data load, which mitigates bandwidth constraints. Oracle GoldenGate can then replicate ongoing changes in near real time, allowing a quick switchover with minimal downtime.
- B. Incorrect.
Incorrect. Although Data Pump and OCI Object Storage can be used for migrations, repeatedly transferring 10 TB of data over limited bandwidth can introduce long transfer times and repeated full imports, increasing downtime and complexity.
- C. Incorrect.
Incorrect. An offline forklift migration requires taking the on-premises database completely offline, potentially for an extended period. This doesn't meet the 'minimal downtime' requirement.
- D. Incorrect.
Incorrect. A single final backup restoration means no real-time replication of changes. The downtime would be as long as it takes to perform the backup, ship it, and restore it in OCI, which is significant for a 10 TB database.