1Z0-1123-25 Question 3
Single answerYour organization is migrating a mission-critical on-premises Oracle Database to Oracle Cloud Infrastructure (OCI). The business demands near-zero downtime to avoid revenue loss, and you must maintain data consistency throughout the transition. Which migration strategy best fulfills these requirements?
- A
Perform a one-time, big-bang cutover during off-peak hours to minimize impact.
- B
Set up Oracle GoldenGate to replicate data in real-time before switching production to OCI.
- C
Take the on-premises database offline, export the data, and import it into a new instance in OCI.
- D
Create a full backup and restore it to OCI, then handle any subsequent data changes manually.
Show answer and explanation
Correct answer: B
Explanation
For mission-critical migrations where near-zero downtime is required, a real-time replication strategy is recommended. Oracle GoldenGate synchronizes on-premises and cloud databases continuously, allowing you to perform a final switchover with minimal impact. Refer to Oracle GoldenGate documentation in the Oracle Help Center for detailed setup guidelines and best practices.
- A. Incorrect.
Option 1: This one-time cutover might seem appealing, but if the environment is mission-critical, any downtime can impact business operations. Even during off-peak hours, a 'big-bang' approach risks extended outages if unexpected issues arise.
- B. Correct.
Option 2: Using Oracle GoldenGate is the most appropriate method to achieve near-zero downtime. GoldenGate can replicate changes in real-time from the on-premises database to OCI, ensuring continuous data synchronization. Once the databases are in sync, you can switch production with minimal business disruption.
- C. Incorrect.
Option 3: Exporting and importing the entire database while it is offline can introduce significant downtime. This approach may be suitable for smaller or less critical applications but does not meet the requirement for near-zero downtime.
- D. Incorrect.
Option 4: Taking full backups and manually applying updates is prone to errors and latency. It does not provide real-time replication or seamless switchover, making it unsuitable for minimizing downtime in mission-critical environments.