1Z0-1123-25 Question 139
Select 2Your organization needs to migrate a mission-critical 11 TB Oracle database from on-premises to Oracle Cloud Infrastructure (OCI). The database must remain highly available during the migration, and your network bandwidth is limited and subject to occasional spikes. You anticipate potential schema changes during the move. Which TWO steps are essential to ensure a successful database migration plan that minimizes downtime and maintains data integrity?
- A
Evaluate the current on-premises environment for network throughput, data growth patterns, and peak usage times to decide if an offline or online strategy is appropriate.
- B
Perform the data transfer entirely through the Data Pump export/import method without any additional testing or replication tools.
- C
Conduct a thorough proof-of-concept on a representative subset of data, testing both migration performance and schema changes in OCI.
- D
Configure your target database in OCI with a larger block size than the on-premises database to compensate for limited bandwidth.
Show answer and explanation
Correct answers: A, C
Explanation
A successful database migration plan involves a thorough analysis of existing infrastructure constraints, including network performance and data volume, followed by a carefully tested migration approach. Proof-of-concepts help validate methods, confirm schema compatibility, and mitigate unforeseen risks. Oracle� official documentation advises assessing both offline (like Oracle Data Pump) and online (such as Oracle GoldenGate) strategies and validating the approach in a test environment. Reference: Oracle Cloud Infrastructure Documentation - Database Migration Best Practices.
- A. Correct.
Correct. Analyzing network constraints and data growth patterns is crucial to decide between an offline (batch) or online (continuous) migration method. This step helps you account for bandwidth limitations, data volume, and required cutover periods.
- B. Incorrect.
Incorrect. Relying solely on Data Pump without replication or further testing could cause extended downtime and risk data integrity if not carefully managed. Large databases, in particular, benefit from additional strategies like streaming or incremental backups to reduce downtime.
- C. Correct.
Correct. A proof-of-concept on a smaller dataset helps validate the migration steps, identify performance bottlenecks, and ensure that schema changes are handled correctly before full-scale migration.
- D. Incorrect.
Incorrect. Simply increasing the database block size on the target does not address network bandwidth limitations or ensure minimal downtime. Block size optimization is complex and doesn�t directly solve unpredictable network throughput issues.