1Z0-1123-25 Question 50
Select 3Your organization has completed the initial load of a large on-premises Oracle Database (19c) into Oracle Cloud Infrastructure using Oracle GoldenGate. They now want to ensure minimal downtime by continuously syncing the source and target before performing a final cutover. Which steps must they perform next to achieve a successful migration with minimal disruption? (Choose three.)
- A
Enable Oracle GoldenGate real-time replication between the source and target databases.
- B
Perform incremental Data Pump imports on the target to keep data up to date.
- C
Validate data consistency by comparing key metrics (such as row counts and checksums) between source and target.
- D
Freeze incoming transactions on the source, test the target environment, and verify replication before cutover.
- E
Shut down the source system immediately after the initial load to avoid further data changes.
Show answer and explanation
Correct answers: A, C, D
Explanation
In a minimal-downtime database migration using Oracle GoldenGate, the post-initial-load steps include setting up continuous real-time replication, validating that the replicated data matches the source, and executing a carefully planned cutover after testing on the target. This ensures that both databases stay synchronized until a final, clean switch, as recommended by Oracle GoldenGate best practices in OCI (see Oracle documentation on 'GoldenGate for Oracle Database' for detailed guidelines).
- A. Correct.
Correct. After the initial load, you must enable real-time replication so that any new transactions on the source are captured and applied to the target, ensuring data alignment.
- B. Incorrect.
Incorrect. Relying on multiple incremental Data Pump imports after the initial load is not the recommended approach for near-zero downtime. Oracle GoldenGate real-time replication is more efficient and reduces downtime.
- C. Correct.
Correct. Validating data consistency (e.g., row counts, checksums, or sample data comparisons) helps confirm that the source and target match before final cutover.
- D. Correct.
Correct. Freezing source changes at a controlled moment, followed by thorough testing of the target, ensures that no additional data discrepancies arise before the cutover and final acceptance.
- E. Incorrect.
Incorrect. Immediately shutting down the source system would abruptly stop production usage, leading to unnecessary downtime and potential data loss. Real-time replication allows the source to keep functioning until cutover.