1Z0-1123-25 Question 143
Select 2A healthcare provider plans to migrate a 6 TB Oracle 19c database from their on-premises data center to an OCI DB System. They have a strict requirement of less than two hours for the final cutover. They also need near real-time synchronization of data and a robust fallback plan in case of any issues during the transition. Which two steps should be included in the migration design to meet these requirements?
- A
- Configure a Data Guard standby in OCI and plan a switchover once the standby is synchronized.
- B
- Set up a Zero Downtime Migration (ZDM) job to automatically stream data continuously without requiring additional tools.
- C
- Schedule regular incremental backups every 48 hours and restore them in OCI if needed.
- D
- Use Data Pump to export and import the full database in a single downtime window.
- E
- Implement Oracle GoldenGate for near real-time replication before final cutover.
Show answer and explanation
Correct answers: A, E
Explanation
When designing a database migration plan with stringent downtime limits, both Data Guard and Oracle GoldenGate are recommended solutions to maintain near real-time data replication and enable a controlled, low-risk cutover. Data Guard sets up a standby database that is constantly synchronized with the primary system, while GoldenGate uses real-time data capture and replication. These methods reduce downtime and provide fallback paths if unforeseen challenges arise. For more details, refer to Oracle's documentation on Data Guard (docs.oracle.com/en/database/oracle/oracle-database) and Oracle GoldenGate (docs.oracle.com/en/middleware/goldengate).
- A. Correct.
- Correct. Data Guard with a synchronized standby is a proven method for minimizing downtime. By creating a physical standby in OCI, you can apply transaction logs in near real-time and perform a fast switchover when ready. This approach also provides a fallback plan if issues arise after cutover.
- B. Incorrect.
- Incorrect. Zero Downtime Migration (ZDM) can automate certain steps, but by itself does not handle near real-time replication without integrating a replication technology such as Data Guard or Oracle GoldenGate. ZDM alone cannot continuously stream changes without an underlying replication mechanism.
- C. Incorrect.
- Incorrect. While incremental backups can help with partial updates, performing them every 48 hours is inadequate for near real-time synchronization. This approach also risks a much larger window of data loss if a failure occurs between backups.
- D. Incorrect.
- Incorrect. Data Pump can be suitable for smaller databases or when offline downtime is acceptable. However, a single Data Pump export/import of a 6 TB database generally exceeds a two-hour window and does not inherently provide a robust fallback plan.
- E. Correct.
- Correct. Oracle GoldenGate is designed for near real-time data replication and minimal downtime cutovers. This enables continuous data synchronization from on-premises to OCI, ensuring a short final cutover and an easy rollback if needed.