1Z0-997-25 Question 137
Select 2A healthcare provider needs to migrate its large, mission-critical patient management database from an on-premises data center to OCI. The provider requires near-zero downtime and consistency to ensure no data loss during the switchover. Which TWO migration strategies would best meet this requirement?
- A
Use Zero Downtime Migration (ZDM) to replicate data from the on-premises Oracle Database to OCI, then perform a switchover once replication is in sync.
- B
Perform an offline bulk data export and import, shutting down the on-premises database until the entire migration is completed.
- C
Leverage Oracle Data Guard to set up a standby database in OCI and switch over when ready.
- D
Rely solely on manual incremental backups to an OCI Archive Storage bucket and restore them upon final cutover.
- E
Configure a cloud-based file transfer of the entire disk image, then run an in-place database upgrade in OCI upon completion.
Show answer and explanation
Correct answers: A, C
Explanation
For mission-critical databases where near-zero downtime is imperative, Oracle ZDM or Oracle Data Guard are commonly recommended solutions. ZDM automates the end-to-end process, while Data Guard sets up a standby database for real-time synchronization. Both approaches significantly reduce downtime and mitigate data-loss risk. Refer to Oracle� documentation on Zero Downtime Migration and Data Guard for guidance on planning and executing these strategies effectively.
- A. Correct.
Option 1 is correct. Zero Downtime Migration (ZDM) automates and orchestrates data migration with minimal or no downtime. It keeps on-premises and OCI databases in sync, allowing a seamless final switchover.
- B. Incorrect.
Option 2 is incorrect. An offline approach involves shutting down the database, which could lead to a long downtime window�not acceptable for mission-critical workloads requiring near-zero downtime.
- C. Correct.
Option 3 is correct. Oracle Data Guard can set up a synchronized standby database in OCI. Once the environment is ready, you can switch over with negligible downtime and no data loss.
- D. Incorrect.
Option 4 is incorrect. Archive Storage is intended for long-term backups and does not provide real-time synchronization. Relying on it alone for migration would introduce significant downtime and risk of data lag.
- E. Incorrect.
Option 5 is incorrect. Simply transferring the entire disk image and performing an in-place upgrade does not ensure near-zero downtime or data consistency. This approach typically requires a longer cutover window and additional configuration steps.