1Z0-1123-25 Question 144
Select 3You are leading a project to migrate a mission-critical on-premises Oracle Database to Oracle Cloud Infrastructure. Your environment includes a multi-terabyte, active data set with limited downtime tolerance. Which three planning steps are essential to ensure a smooth migration with minimal business disruption?
- A
Evaluate on-premises database version compatibility with the target and plan for upgrades or patching if necessary
- B
Assume that maximum network throughput is always available and ignore potential bandwidth or latency constraints
- C
Identify your RTO and RPO requirements to determine if you require near-zero downtime solutions such as Oracle Data Guard or Oracle GoldenGate
- D
Omit a rollback plan to reduce cutover complexity
- E
Incorporate production-like acceptance testing before the final cutover
Show answer and explanation
Correct answers: A, C, E
Explanation
Planning a database migration to Oracle Cloud Infrastructure involves a detailed assessment of version compatibility, downtime requirements, and network constraints. Defining clear RTO/RPO objectives shapes whether you use tools like Oracle Data Guard or Oracle GoldenGate to minimize downtime. Thorough pre-cutover testing with production-like data reduces the risk of post-migration surprises. Refer to Oracle's documentation on Database Migration (docs.oracle.com/en/solutions/migrate-database-to-oci/) and High Availability guides for further best practices and detailed procedures.
- A. Correct.
Option 1 is correct. Ensuring on-premises and target database version compatibility is essential. If incompatibilities exist, you must plan an upgrade or patch to avoid unexpected errors and ensure supportability.
- B. Incorrect.
Option 2 is incorrect. Network constraints can be a major bottleneck for large data transfers. Overlooking bandwidth and latency issues can lead to missed migration windows and operational slowdowns.
- C. Correct.
Option 3 is correct. Defining RTO (Recovery Time Objective) and RPO (Recovery Point Objective) helps determine whether near-zero downtime strategies like Data Guard or GoldenGate are needed. It ensures that the migration approach aligns with business continuity requirements.
- D. Incorrect.
Option 4 is incorrect. Having a rollback or fallback plan is a critical safety measure. Without it, you risk prolonged outages if unforeseen issues arise during the migration.
- E. Correct.
Option 5 is correct. Production-like acceptance testing helps validate performance, functionality, and configuration in a setting that closely matches real-world usage before committing to the final cutover.