1Z0-1123-25 Question 141
Select 2Your organization is migrating a 12 TB on-premises Oracle Database to Oracle Cloud Infrastructure (OCI) as part of a critical system upgrade. The application requires continuous availability and you can only accommodate a downtime window of six hours. Which two strategies should be included in your migration plan to achieve minimal downtime and preserve data consistency?
- A
Use Oracle GoldenGate for real-time data replication, then perform a controlled switchover during the final cutover window.
- B
Perform a complete Oracle Data Pump export/import on the scheduled downtime day without capturing incremental changes.
- C
Adopt Zero Downtime Migration (ZDM) with Oracle Data Guard to synchronize data between on-premises and cloud environments before the final cutover.
- D
Suspend on-premises database operations early and rely solely on large downtime to complete a manual backup and restore into OCI.
Show answer and explanation
Correct answers: A, C
Explanation
To design a successful database migration plan with minimal downtime, it is essential to implement continuous or near-real-time replication (e.g., Oracle GoldenGate) or synchronous approaches (e.g., Oracle Data Guard through Zero Downtime Migration). These methods ensure data consistency by continuously capturing and applying changes to the target environment. Oracle Data Pump alone may be suitable for smaller, less critical databases or when ample downtime is available, but it does not fulfill the requirement for minimal interruption in large-scale, mission-critical scenarios. For more information, consult the Oracle GoldenGate documentation and the Zero Downtime Migration guide on the Oracle Help Center.
- A. Correct.
Option 1: CORRECT. Using Oracle GoldenGate for near real-time replication is a proven method to minimize downtime. Changes are continuously captured and applied to the target database. During the final cutover, you switch connections with minimal disruption, ensuring data consistency.
- B. Incorrect.
Option 2: INCORRECT. While Oracle Data Pump is a useful utility, relying solely on a full export/import without capturing incremental changes typically results in a longer cutover. For a 12 TB database, it may exceed your six-hour window and compromise data consistency during busy periods.
- C. Correct.
Option 3: CORRECT. Zero Downtime Migration (ZDM) with Oracle Data Guard allows continuous synchronization between the source and target databases. This approach significantly reduces downtime by enabling a fast switchover once final sync completes.
- D. Incorrect.
Option 4: INCORRECT. Completely suspending on-premises operations to perform a manual backup and restore leads to substantial downtime, which contradicts your six-hour window requirement.