1Z0-1123-25 Question 54
Select 2Your organization is migrating a production Oracle Database from an on-premises data center to Oracle Cloud Infrastructure (OCI). You have configured Oracle Data Guard to replicate the on-premises primary database to a standby database in OCI. You need to minimize downtime during the final switchover from the on-premises environment to the OCI environment. Which TWO steps must you perform to ensure a valid switchover with minimal downtime?
- A
Disable Flashback Database on both primary and standby before initiating switchover
- B
Verify that the on-premises primary and OCI standby databases have matching versions and are in ARCHIVELOG mode
- C
Open the standby database in read/write mode for testing prior to the final switchover
- D
Use Data Guard Broker to perform the switchover once the standby is in sync with minimal redo lag
Show answer and explanation
Correct answers: B, D
Explanation
In a typical Oracle Data Guard setup for migration, ensuring that the databases share the same version, remain in ARCHIVELOG mode, and relying on the Data Guard Broker for switchover are key best practices. These steps prevent replication issues and reduce the likelihood of extended outages. For more details, refer to Oracle documentation on Data Guard roles and switchover procedures.
- A. Incorrect.
Option 1: Disabling Flashback Database is not inherently mandatory for a successful switchover. Flashback can remain enabled to help recover quickly from errors or to revert the database state if needed. This step is not strictly required to minimize downtime during migration.
- B. Correct.
Option 2: The primary and standby must be running the same database version and both be in ARCHIVELOG mode for Data Guard replication to function correctly and allow a smooth switchover. Performing this verification ensures compatibility and data consistency.
- C. Incorrect.
Option 3: Opening the standby in read/write mode converts it to primary, breaking the standby role. For testing, you typically open the standby in read-only mode or use a snapshot standby. Converting it to read/write prematurely disrupts the replication, making this approach unsuitable for minimal downtime migrations.
- D. Correct.
Option 4: Data Guard Broker automates switchover steps to reduce errors and downtime. Performing the switchover through the Broker once the standby is in sync ensures minimal interruption and automates many of the validation checks.