A Solutions Architect is planning the heterogeneous database migration of an on-premises Oracle 19c database to an Amazon Aurora PostgreSQL-Compatible Edition DB cluster. The source database supports a critical OLTP application experiencing a high volume of transactions, exceeding write transactions per second. The schema contains complex PL/SQL objects, standard relational tables, and several tables containing Large Binary Objects (LOBs) up to in size. The migration must minimize downtime for the cutover, maintain high replication performance without degrading the source database's CPU utilization, and guarantee that LOB data is not truncated.
Which two actions must the Solutions Architect take to configure the migration components successfully? (Select two.)
- Configure the AWS DMS source endpoint with extra connection attributes to use the AWS DMS Binary Reader instead of Oracle LogMiner to process redo and archive logs directly from the file system.Answer
- BConfigure the AWS DMS replication task to use Limited LOB mode with a Max LOB size of to optimize initial transfer speed, allowing DMS to automatically query the source database to fetch the remaining LOB content exceeding this limit during replication.
- Enable database-level minimal supplemental logging and table-level primary key supplemental logging on the source Oracle database before starting the replication task.Answer
- DInstall the AWS SCT agent on the source database server and configure it to stream real-time transaction changes directly to the target Aurora PostgreSQL DB cluster using PostgreSQL logical replication slots.
- EEnable Amazon Aurora Auto Scaling on the target DB cluster and configure the AWS DMS replication task to write directly to the Aurora Reader endpoint to distribute the write load across multiple read replicas.