1Z0-1123-25 Question 150
Single answerA financial services company currently runs a mission-critical Oracle Database on-premises and must migrate it to an OCI Exadata Database Service with as little downtime as possible. They have limited maintenance windows and prefer a method that maintains ongoing data synchronization until the final switch-over. Which migration strategy best meets these requirements?
- A
Export the entire database using Data Pump and import it into the target using standard tools.
- B
Leverage Oracle GoldenGate to perform real-time data replication and minimize downtime.
- C
Use RMAN backup and restore processes to move data to the OCI Exadata Database Service.
- D
Rely on Cross-Platform Transportable Tablespaces to move the entire database in one operation.
Show answer and explanation
Correct answer: B
Explanation
In real-world scenarios where downtime must be minimized, Oracle GoldenGate is a robust solution for continuous data replication to OCI Database Services. It keeps source and target databases in sync in near-real time and allows a controlled failover that meets strict SLAs. Oracle's documentation on 'Oracle GoldenGate in Oracle Cloud Infrastructure' provides best practices and details on configuring and monitoring the replication process for minimal disruption.
- A. Incorrect.
Option 1 (Data Pump) is a valid approach for migrating smaller databases but typically involves a full export/import, which can translate into significant downtime, especially for large or mission-critical workloads.
- B. Correct.
Option 2 (Oracle GoldenGate) is the correct answer because it enables real-time data replication, allowing you to keep both environments in sync and minimize downtime during the final switch-over. This is particularly important when strict SLAs leave little room for extended maintenance windows.
- C. Incorrect.
Option 3 (RMAN backup and restore) can be used for some migrations but generally requires placing the source database in a backup mode and performing a restore on the target. This can cause downtime that may be too long for highly available environments.
- D. Incorrect.
Option 4 (Cross-Platform Transportable Tablespaces) is useful when moving only certain tablespaces and can reduce the size of the migration, but it still often requires significant downtime or read-only phases, making it less ideal for zero or near-zero downtime scenarios.