1Z0-1123-25 Question 134
Select 2Your company needs to migrate a mission-critical 10 TB on-premises Oracle Database 19c to Oracle Exadata Cloud Service in OCI with minimal downtime. The database must remain operational as close to 24/7 as possible. You have a stable high-bandwidth connection (FastConnect) between the on-premises data center and OCI. Which two approaches would best meet your minimal downtime requirement?
- A
Use Oracle GoldenGate to establish real-time data replication before switching over to OCI.
- B
Use Oracle Zero Downtime Migration (ZDM) with an Oracle Data Guard-based switchover.
- C
Use Oracle Data Pump export/import to migrate the database schemas and data in one step.
- D
Perform manual RMAN backup and restore from the on-premises database to OCI.
Show answer and explanation
Correct answers: A, B
Explanation
For minimal downtime migrations of large Oracle databases to OCI, replication-based methods such as Oracle GoldenGate or an Oracle Data Guard approach via Zero Downtime Migration are recommended. Data Pump and manual RMAN approaches are more suited for smaller databases or scenarios where some downtime is acceptable. Refer to Oracle� official documentation for ZDM (https://docs.oracle.com/en/solutions/migrate-19c-exadata-cloud-service/index.html) and Oracle GoldenGate for detailed guidance on setting up minimal downtime migrations.
- A. Correct.
Option 1 is correct. Oracle GoldenGate allows near real-time replication of data changes from the source database to the target in OCI. Once the data is synchronized, you can perform a switchover with minimal downtime.
- B. Correct.
Option 2 is correct. Oracle Zero Downtime Migration (ZDM) leverages Oracle Data Guard to maintain a synchronized standby copy of the database in OCI, enabling a switchover with minimal service interruption.
- C. Incorrect.
Option 3 is incorrect. Data Pump requires exporting and importing the entire database schema and data; for a large, mission-critical 10 TB database, this would result in significant downtime while the import completes.
- D. Incorrect.
Option 4 is incorrect. A manual RMAN backup and restore can move data to OCI, but there is no live synchronization of transactions. This typically requires extended downtime to ensure data consistency during the transition.