A solutions architect is planning to migrate an on-premises Oracle database to an Amazon Aurora MySQL-Compatible Edition DB cluster. The migration must support a heterogeneous schema conversion and continuous replication using Change Data Capture (CDC) to minimize application downtime during the cutover.
Which of the following actions are required to successfully convert the schema and configure the replication process? (Select two.)
- Use the AWS Schema Conversion Tool (SCT) to convert the source database schema, tables, and views to the Aurora MySQL format, and apply the schema to the target database.Answer
- Enable supplemental logging on the source Oracle database and configure the replication task in AWS DMS to capture ongoing changes.Answer
- CEnable binary logging and set the binary log format to ROW on the target Aurora MySQL DB cluster to capture changes from the Oracle database.
- DCreate the AWS DMS replication task using AWS SCT directly to automate both schema conversion and continuous data replication in a single step.
- EConfigure the source Oracle database to use PostgreSQL logical replication slots to stream data changes to AWS DMS.
Answer
The correct actions are using the AWS Schema Conversion Tool (SCT) to convert and apply the schema to the target database, and enabling supplemental logging on the source Oracle database to support Change Data Capture (CDC).
To perform a heterogeneous migration from Oracle to Aurora MySQL with minimal downtime, the solutions architect must first use the AWS Schema Conversion Tool (SCT) to convert the database schema and apply it to the target database. To capture ongoing changes, supplemental logging must be enabled on the source Oracle database so that AWS DMS can read the redo logs during the CDC phase.
Step-by-Step Solution
Key Concept
Heterogeneous database migration involves using AWS SCT for schema conversion and AWS DMS for data replication, which requires configuring source-specific prerequisites like supplemental logging for ongoing replication (CDC).