1Z0-1123-25 Question 146
Select 2Your on-premises finance department relies on a mission-critical Oracle Database that needs minimal disruption during migration. You must move this database quickly to OCI Database Services with near-zero downtime. Which two methods are recommended for achieving near-zero downtime in this scenario?
- A
Use Zero Downtime Migration (ZDM) with Oracle GoldenGate for continuous data replication
- B
Migrate the database using Oracle Data Pump export and import with scheduled downtime
- C
Implement an Oracle Data Guard standby on OCI and perform a role transition
- D
Perform a full RMAN backup and restore with a maintenance window for downtime
Show answer and explanation
Correct answers: A, C
Explanation
When near-zero downtime is critical, Oracle recommends using solutions such as Zero Downtime Migration (ZDM) with Oracle GoldenGate or leveraging Data Guard to keep databases synchronized until a final switchover. Data Pump and RMAN backups are effective migration methods but typically incur more downtime. Detailed guidance can be found in Oracle's Official Documentation, including best practices for near-zero downtime migrations.
- A. Correct.
Option 1 is correct because Zero Downtime Migration (ZDM) with Oracle GoldenGate allows real-time data replication, minimizing downtime during the switch-over. This is one of the recommended Oracle solutions for near-zero database migration to OCI.
- B. Incorrect.
Option 2 is incorrect because Data Pump export/import requires taking the source database offline or read-only for part of the migration process, which does not meet the requirement of near-zero downtime.
- C. Correct.
Option 3 is correct. Configuring a Data Guard standby on OCI and then performing a switchover is a proven approach to minimize downtime, as the database remains fully operational until the final role transition.
- D. Incorrect.
Option 4 is incorrect because performing a complete RMAN backup and restore typically requires an extended maintenance window, which does not align with near-zero downtime requirements.