1Z0-997-25 Question 134
Single answerYou are migrating a large, mission-critical Oracle Database from your on-premises data center to an Autonomous Database on Oracle Cloud Infrastructure (OCI). Minimizing downtime is paramount, and you need a simplified, near-zero downtime approach. Which recommended method should you choose to achieve a seamless migration with minimal disruption?
- A
Use Oracle Cloud Infrastructure Database Migration, which orchestrates data movement and leverages Oracle GoldenGate to minimize downtime.
- B
Export your entire database to Oracle Cloud Infrastructure Object Storage manually and then import it into the Autonomous Database.
- C
Use the Data Transfer Service to physically ship database backups to OCI and restore them into an Autonomous Database.
- D
Stop all on-premises transactions and copy the entire Oracle home to an OCI compute instance, then attach it to the Autonomous Database.
Show answer and explanation
Correct answer: A
Explanation
OCI Database Migration provides a guided workflow and automates many of the steps involved in migrating an Oracle Database to the cloud. It uses GoldenGate technology for continuous data replication, which reduces downtime by replicating changes until final switchover. For detailed guidance, refer to Oracle� official documentation on OCI Database Migration at https://docs.oracle.com/en-us/iaas/Content/Database-migration/home.htm.
- A. Correct.
CORRECT. Oracle Cloud Infrastructure Database Migration (built using Oracle GoldenGate under the hood) automates the process of migrating on-premises Oracle Databases to OCI with minimal downtime. It handles schema creation, data transfer, and incremental replication until the final cutover.
- B. Incorrect.
INCORRECT. While exporting to Object Storage and importing can work, it generally requires significant downtime and manual steps. This approach doesn't provide near-zero downtime because the production environment must remain static during export/import.
- C. Incorrect.
INCORRECT. The Data Transfer Service is optimal for large bulk file transfers (e.g., for analytics data or backups) but does not inherently handle real-time replication or synchronization necessary for near-zero downtime migrations to an Autonomous Database.
- D. Incorrect.
INCORRECT. Simply copying the Oracle home and data files is not a supported method to directly seed an Autonomous Database. This would also incur significant downtime when the on-premises database is unavailable.