1Z0-1123-25 Question 51
Select 2You are migrating a mission-critical on-premises Oracle Database to Oracle Cloud Infrastructure using OCI Database Migration with continuous replication enabled. The goal is to minimize downtime by keeping the source and target systems in sync until the final cutover. Which two tasks must you perform just before issuing the cutover command to ensure data consistency and a successful switchover?
- A
Stop or restrict new transactions on the source database to avoid introducing new data changes during the final sync
- B
Ensure replication lag is zero or near zero before initiating the final cutover procedure
- C
Override the database instance identifier (DBID) on the target to match the source environment
- D
Allow end users to continue transacting on the source during the final replication phase to expedite the migration
Show answer and explanation
Correct answers: A, B
Explanation
Before issuing a cutover in an OCI Database Migration with continuous replication enabled, it is essential to stop or restrict new transactions and verify that replication lag is at or near zero. These steps ensure that no additional data changes occur on the source during the final sync, and that all changes have been accurately applied on the target. Refer to OCI Database Migration documentation for detailed best practices, including scheduling downtime windows and validating replication status before cutover.
- A. Correct.
Option 1 is correct. Stopping or restricting new transactions prevents additional data divergence during the last phase of synchronization. This ensures that no new data is written to the source while you finalize the replication on the target.
- B. Correct.
Option 2 is correct. Validating that the replication lag is zero or near zero means the target environment has fully caught up with all changes from the source, reducing the chance of data loss or inconsistencies after cutover.
- C. Incorrect.
Option 3 is incorrect. Modifying the database instance identifier (DBID) for the target is not typically required for a standard OCI Database Migration process, and can introduce unnecessary complexity. This step is not part of the typical cutover checklist.
- D. Incorrect.
Option 4 is incorrect. Continuing transactions on the source during the final sync period undercuts the entire objective of ensuring data consistency. Allowing new data changes at the source would lead to discrepancies and a risk of losing transactions.