Question 1 · choose 1
A company will move a 20 TB Oracle database to Amazon Aurora PostgreSQL. The database takes orders around the clock, and the business allows at most 30 minutes of downtime for the cutover. The schema includes PL/SQL procedures that must be converted. Which migration approach meets these requirements?
- ACreate an Aurora PostgreSQL read replica of the Oracle database and promote it to a standalone cluster at cutover
- BCopy the Oracle data files to Amazon S3 with AWS DataSync and attach the copied files to the new Aurora cluster
- CRun an AWS DMS full-load task only, during the cutover window, after converting the schema
- DConvert the schema with DMS Schema Conversion or AWS SCT, then run a DMS full load with change data capture
Show the answer and why
ACreate an Aurora PostgreSQL read replica of the Oracle database and promote it to a standalone cluster at cutover
Incorrect
Aurora PostgreSQL read replicas can be created from RDS for PostgreSQL DB instances. For a database that is not PostgreSQL-compatible, AWS points to AWS DMS.
BCopy the Oracle data files to Amazon S3 with AWS DataSync and attach the copied files to the new Aurora cluster
Incorrect
DataSync moves files and objects. Aurora PostgreSQL cannot use Oracle data files, and the engines differ.
CRun an AWS DMS full-load task only, during the cutover window, after converting the schema
Incorrect
A full load of 20 TB takes far longer than 30 minutes, and without ongoing replication every change made during the load is lost.
DConvert the schema with DMS Schema Conversion or AWS SCT, then run a DMS full load with change data capture
Correct
Schema conversion translates the Oracle schema and code objects to PostgreSQL, and a DMS task with full load plus ongoing replication keeps the target in sync, so cutover needs only a short pause.
Heterogeneous and near-zero downtime: convert the schema first, then full load plus change data capture with AWS DMS.
AWS documentation
- Converting database schemas using DMS Schema Conversion (opens in a new tab)
- What is the AWS Schema Conversion Tool? (opens in a new tab)
- Creating tasks for ongoing replication using AWS DMS (opens in a new tab)
- What is AWS DataSync? (opens in a new tab)
- Migrating data to Amazon Aurora with PostgreSQL compatibility (opens in a new tab)