AWS Database Migration Service
Step-by-Step Migration Guide (API Version 2016-01-01)

Rolling Back the Migration

If there are major issues with the migration that cannot be resolved in a timely manner, you can roll back the migration. These steps assume that you have already prepared for the rollback as described in Step 8: Cut Over to PostgreSQL.

To roll back the migration

  1. Stop all application services on the target PostgreSQL database.

  2. Let the AWS DMS task replicate remaining changes back to the source Oracle database.

  3. Stop the PostgreSQL to Oracle AWS DMS task.

  4. Start all applications back on the source Oracle database.