1Z0-1123-25 Question 133
Select 2You are the lead architect for a manufacturing company, tasked with migrating a 5 TB on-premises Oracle Database 19c to a new VM DB System on Oracle Cloud Infrastructure (OCI). The database supports mission-critical workloads and downtime must be kept to a minimum. The company does not have Oracle GoldenGate licensing. Which two approaches would you recommend to achieve a successful migration with minimal downtime?
- A
Use Zero Downtime Migration (ZDM) leveraging Oracle Data Guard-based replication.
- B
Perform a full Oracle Data Pump export/import over a high-speed connection.
- C
Use RMAN cross-platform transportable tablespaces to migrate the database to the target platform.
- D
Implement Oracle GoldenGate for real-time replication and switchover.
Show answer and explanation
Correct answers: A, C
Explanation
Zero Downtime Migration (ZDM) with Oracle Data Guard (Option 1) is a popular method for near-zero downtime migrations to OCI. RMAN cross-platform transportable tablespaces (Option 3) can also minimize downtime by moving data files directly. Data Pump (Option 2) may be simpler but takes significantly longer for large databases, and GoldenGate (Option 4) is ruled out due to licensing unavailability in this scenario. For more details, refer to Oracle's 'Migrate Databases to OCI' documentation and Zero Downtime Migration best practices in Oracle� official guides.
- A. Correct.
Explanation for Option 1: Zero Downtime Migration (ZDM) uses Oracle Data Guard behind the scenes to replicate data to OCI. This allows continuous synchronization and minimal cutover downtime. It's specifically designed for large databases that need minimal downtime.
- B. Incorrect.
Explanation for Option 2: Although Data Pump is often used to migrate Oracle Database objects, it is typically associated with longer downtime because you must export and then import the entire database. For a 5 TB database, this can be quite time-consuming, making it less suitable when downtime must be minimized.
- C. Correct.
Explanation for Option 3: RMAN cross-platform transportable tablespaces can provide a relatively efficient way to migrate large databases with reduced downtime. By transporting data files between platforms, the time-consuming export/import overhead of Data Pump is avoided. While some downtime is still required, it is significantly reduced compared to a full export/import approach.
- D. Incorrect.
Explanation for Option 4: Oracle GoldenGate is a powerful tool for real-time or near real-time replication. However, the company does not hold the necessary licensing, making this option infeasible under the stated constraints.