1Z0-1123-25 Question 53
Select 2You are tasked with migrating a mission-critical on-premises Oracle Database to Oracle Cloud Infrastructure (OCI) with minimal downtime. The team decides to use Oracle GoldenGate for near-real-time replication. Which two tasks are essential to ensure smooth replication and minimal disruption to the source environment?
- A
Configure and enable supplemental logging on the source database.
- B
Temporarily disable all primary keys on the source database to prevent uniqueness conflicts.
- C
Deploy Oracle GoldenGate components in both the on-premises environment and the OCI target environment.
- D
Use the Oracle Data Transfer Service every night to capture incremental backups for replication.
Show answer and explanation
Correct answers: A, C
Explanation
To minimize downtime during database migrations, Oracle GoldenGate is often used to replicate changes in near real-time. Enabling supplemental logging on the source is essential so that all changes are properly recorded for GoldenGate capture. GoldenGate components must be installed and configured in both the source and target environments to coordinate data movement. Refer to Oracle� GoldenGate documentation for additional details on configuring supplemental logging and best practices for a smooth, low-downtime migration (https://docs.oracle.com/en/middleware/goldengate/).
- A. Correct.
Option 1: Correct. Supplemental logging on the source database is required by Oracle GoldenGate to accurately capture all necessary data changes for replication. Failing to enable supplemental logging could result in incomplete or inconsistent replication.
- B. Incorrect.
Option 2: Incorrect. Disabling primary keys is not a recommended practice because it can compromise data integrity and is not required for proper replication. GoldenGate relies on primary keys (or unique constraints) for accurate data capture and conflict detection.
- C. Correct.
Option 3: Correct. Oracle GoldenGate must be deployed on both the source (on-premises) and target (OCI) environments to manage real-time data movement and replication. This ensures a smooth flow of transactions between the two environments.
- D. Incorrect.
Option 4: Incorrect. Oracle Data Transfer Service is generally used for bulk data movement (e.g., initial large-scale data seeding), not real-time or near-real-time replication. GoldenGate continuously applies changes, making nightly incremental backups unnecessary for the replication process.