1Z0-997-25 Question 139
Select 2Your organization needs to migrate an on-premises workload that includes a mission-critical Oracle Database (approximately 50 TB in size) and an analytics application to Oracle Cloud Infrastructure (OCI). You have limited network bandwidth and a two-week window for the migration. Which two actions will help achieve your migration goals while minimizing downtime?
- A
Ship your data using the OCI Data Transfer Appliance service, then use a replication tool to synchronize incremental changes once the initial bulk data is available in OCI.
- B
Use a standard site-to-site VPN connection to transfer all 50 TB over the public internet, limiting data transfer activity to off-peak hours to meet the two-week window.
- C
Establish an OCI FastConnect link, perform a live database switchover with Oracle Data Guard without an initial bulk data load, and rely on streaming for the entire data transfer.
- D
Leverage Oracle GoldenGate to capture and apply ongoing database transactions after transferring a full data backup via the OCI Data Transfer Appliance.
Show answer and explanation
Correct answers: A, D
Explanation
A common best practice for migrating large on-premises databases to OCI is to use a physical bulk data transfer (via OCI Data Transfer Appliance) to shorten the initial loading phase. You then use a replication or synchronization tool�such as Oracle GoldenGate�to catch incremental changes that occur during shipment and processing, ensuring data integrity with minimal downtime. Refer to the OCI documentation on Data Transfer (https://docs.oracle.com/en-us/iaas/Content/DataTransfer/Concepts/overview.htm) and Oracle GoldenGate (https://docs.oracle.com/en/middleware/goldengate/) for detailed guidance.
- A. Correct.
Correct. Using the OCI Data Transfer Appliance to ship the initial data can significantly reduce the time needed to move large volumes. After the bulk data import, a replication tool (like Oracle Data Guard or GoldenGate) can synchronize changes and minimize downtime during cutover.
- B. Incorrect.
Incorrect. Transferring 50 TB over a standard VPN with limited bandwidth is unlikely to meet a strict two-week deadline, even with off-peak scheduling. The available bandwidth typically becomes a bottleneck and can extend the migration timeline beyond acceptable limits.
- C. Incorrect.
Incorrect. While FastConnect provides a dedicated and higher-speed connection, relying solely on live replication for 50 TB of data without a bulk load is risky and can exceed the two-week window. Streaming the entire dataset continuously might not complete on time, especially if the bandwidth is still constrained.
- D. Correct.
Correct. Oracle GoldenGate is commonly used to replicate ongoing changes after an initial seeding of data. By combining a bulk load (using OCI Data Transfer Appliance) with a replication tool, you can minimize the final cutover time and reduce overall downtime.