1Z0-1123-25 Question 135
Single answerYour organization needs to migrate a 2TB Oracle Database 19c from an on-premises environment to an Oracle Cloud Infrastructure (OCI) Virtual Machine DB System. The database runs critical applications that cannot tolerate extended downtime, and you need to keep the source and target databases in sync until the final cutover. Which migration method is most appropriate for meeting these minimal downtime requirements?
- A
Use Oracle Data Pump to export the on-premises database and import into the OCI DB System.
- B
Perform an RMAN backup of the on-premises database and restore it to the OCI DB System.
- C
Implement Oracle GoldenGate to replicate data in near-real-time from on-premises to OCI.
- D
Take an offline backup of the on-premises database protected by Transparent Data Encryption (TDE) and upload to OCI.
Show answer and explanation
Correct answer: C
Explanation
When minimizing downtime for critical Oracle Databases during migration, Oracle GoldenGate is a leading choice because it continuously captures and applies changes in near-real-time. This ensures the source and target remain synchronized and the final switchover is fast. For more details, refer to Oracle� documentation on GoldenGate-based migrations for OCI (https://docs.oracle.com/en/middleware/goldengate/) and best practices for near-zero downtime database migrations.
- A. Incorrect.
Data Pump is straightforward for migrating smaller or less active databases, but it typically requires a full export/import, leading to a period of downtime while the export and import occur. This does not best satisfy the requirement of minimal disruption for a 2TB critical database.
- B. Incorrect.
RMAN is useful for scripting and automating backups, but it does not inherently provide near-real-time synchronization. You would still incur downtime while restoring and recovering the database in OCI before going live.
- C. Correct.
Oracle GoldenGate offers near-real-time data replication, allowing the on-premises database and the OCI database to stay in sync. This approach minimizes downtime by leaving the source fully operational until cutover, and then switching users and applications to the new environment with minimal disruption.
- D. Incorrect.
Offline backups using TDE protect data at rest but do not address the requirement to keep the databases synchronized. The offline nature of this method implies downtime while you take a backup and restore it in OCI.