1Z0-1123-25 Question 148
Select 2Your organization runs a critical on-premises Oracle Database that supports a high-volume e-commerce application. They need to migrate this database to Oracle Cloud Infrastructure (OCI) Database Services with near-zero downtime to avoid revenue impacts. Which two methods can help achieve minimal or near-zero downtime in this scenario? (Choose two.)
- A
Oracle GoldenGate
- B
Oracle Data Pump
- C
Zero Downtime Migration (ZDM)
- D
RMAN cross-platform backup and restore
Show answer and explanation
Correct answers: A, C
Explanation
Near-zero downtime solutions for migrating databases to OCI typically rely on continuous data replication or highly automated methods. Oracle GoldenGate streams real-time data changes, ensuring the target database remains nearly in sync with the source prior to cutover. Zero Downtime Migration (ZDM) automates replication-based migrations (including GoldenGate) to further minimize downtime. Data Pump and RMAN methods can be effective but usually introduce measurable downtime. For more details, consult Oracle� documentation on Migration to Oracle Cloud Infrastructure Database Services and best practices for continuous replication.
- A. Correct.
Oracle GoldenGate: Correct. GoldenGate supports real-time data replication, enabling near-zero downtime by continuously syncing changes from the source to the target database before final cutover.
- B. Incorrect.
Oracle Data Pump: Incorrect. While Data Pump is useful for logical data migration, it typically requires a database export/import process that involves downtime, making it less ideal for near-zero downtime scenarios.
- C. Correct.
Zero Downtime Migration (ZDM): Correct. ZDM automates and orchestrates data migration with minimal disruption by leveraging methods such as GoldenGate under the hood, minimizing downtime for production systems.
- D. Incorrect.
RMAN cross-platform backup and restore: Incorrect. RMAN-based cross-platform migration involves a backup-restore process and generally requires more downtime. It is best suited for environments that can accommodate more downtime.