1Z0-1123-25 Question 1
Single answerYour organization plans to migrate a mission-critical ERP system and its 5 TB Oracle Database from the on-premises data center to Oracle Cloud Infrastructure. The business requires minimal downtime and a seamless cutover window. Which approach best satisfies these requirements for near-real-time data replication and quick switchover?
- A
Use Oracle Cloud Infrastructure Database Migration to establish continuous data replication and perform a short cutover.
- B
Perform a complete offline Data Pump export of the on-premises database, upload it to Object Storage, and then import into a new database instance.
- C
Use a nightly file-based backup script to upload data increments to Object Storage, then restore in Oracle Cloud Infrastructure.
- D
Employ physical shipment through Oracle Data Transfer Disk Service for final import before decommissioning on-premises resources.
Show answer and explanation
Correct answer: A
Explanation
In scenarios requiring near-zero downtime, continuous data replication is essential. Oracle Cloud Infrastructure Database Migration leverages streaming replication technologies to keep the target database synchronized with the operational source. This approach significantly reduces the final cutover window. Offline methods such as Data Pump exports or physical disk transfers can be effective for sizable data sets when downtime is permissible, but they are not optimal for minimal-outage migrations. Refer to OCI Database Migration documentation (docs.oracle.com/en-us/iaas/Content/database-migration/home.htm) for best practices on continuous replication and phased cutovers.
- A. Correct.
Correct. Oracle Cloud Infrastructure Database Migration provides continuous data replication for near-zero downtime. This approach allows you to synchronize production and cloud databases in real time, then perform a final small cutover window to avoid lengthy downtime.
- B. Incorrect.
Incorrect. While Data Pump exports and imports are reliable, they are offline and would require substantial downtime for a 5 TB database, as the system cannot update during the export/import process.
- C. Incorrect.
Incorrect. Nightly file-based backups do not ensure continuous replication. Even if the backups are incremental, you still risk missing transactions that occur between backups, making it unsuitable for minimal downtime requirements.
- D. Incorrect.
Incorrect. While the Data Transfer Disk Service speeds up large offline transfers, it requires shipping physical disks, which introduces extended transit time. This method is effective for cold data migrations but not ideal for near-real-time replication.