Question #758
A solutions architect is migrating critical Oracle databases to AWS. These databases are part of legacy systems, and the architect must transition them to a modern data architecture with near-zero downtime. Which solution meets these requirements?
Use AWS Application Migration Service and the AWS Schema Conversion Tool (AWS SCT). Perform an in-place upgrade before migration. Export the data to Amazon Aurora Serverless after cutover and repoint applications to Aurora.
Use AWS Database Migration Service (AWS DMS) to rehost the database with Amazon S3 as the target. Configure change data capture (CDC) replication. Once synchronized, load the data into an Amazon RDS for Oracle DB instance.
Use Oracle Data Guard for replication. Connect the source database to an Amazon RDS for Oracle DB instance. After synchronization, transition the workload to the RDS instance.
Use AWS Application Migration Service to rehost the database on Amazon EC2. After replication, detach the database, migrate it to an Amazon RDS for Oracle DB instance, reattach it, and cut over networking.
Explanation
Option C uses Oracle Data Guard, Oracle's native replication tool, to create a standby instance on Amazon RDS for Oracle. This ensures continuous synchronization between the source database and the RDS instance. Once synchronized, the standby can be promoted to primary with minimal downtime, meeting the requirement of near-zero downtime. Other options involve risky in-place upgrades (A), indirect S3-based migration (B), or multiple migration steps (D), which introduce potential downtime or complexity. Key points: Oracle Data Guard integrates with RDS for Oracle, CDC ensures real-time replication, and promotion to primary enables seamless cutover.
Answer
The correct answer is: C