MEGAZONECLOUD Tech Community Blog

Migrate Oracle DB to RDS with Oracle Data Pump and DMS (2)

- Introduction: This article discusses the migration of an Oracle database from an on-premises server to AWS RDS using DMS.
- Environment: The source database is Oracle Database 12c and the target is Oracle RDS 19c Standard Edition Two.
- Prerequisites: Listeners' name and port must be specified in the listener.ora file for DMS migration. You need a DMS Replication instance, Subnet group, Endpoint for source and target databases, and a replication instance. You also need to create security groups for DMS Replication instance, and enable CloudWatch logs for log collection.
- Steps: 
  1. Create a Subnet group and select the VPC where the target DB is located.
  2. Create security groups for DMS Replication instance.
  3. Create Endpoint configurations for source and target databases.
  4. Create a Database migration task and select the source and target endpoints.
  5. Check for duplicate data in the target tables before starting the migration. 
- Conclusion: This article provides a step-by-step guide to migrate an Oracle database to AWS RDS using DMS.