This pattern describes how to migrate an Oracle database from an on-premises data center to an Amazon Relational Database Service (Amazon RDS) for Oracle DB instance by using Oracle Data Pump. 

The pattern involves creating a data dump file from the source database, storing the file in an Amazon Simple Storage Service (Amazon S3) bucket, and then restoring the data to an Amazon RDS for Oracle DB instance. This pattern is useful when you encounter limitations using AWS Database Migration Service (AWS DMS) for the migration.

Prerequisites and limitations

Prerequisites

• An active AWS account

• The required permissions to create roles in AWS Identity and Access Management (IAM) and for an Amazon S3 multipart upload

• The required permissions to export data from the source database

• AWS Command Line Interface (AWS CLI) installed and configured

Product versions

• Oracle Data Pump is available only for Oracle Database 10g Release 1 (10.1) and later versions.

Architecture

Source technology stack

• On-premises Oracle databases

Target technology stack

• Amazon RDS for Oracle

• SQL client (Oracle SQL Developer)

• An S3 bucket

Source and target architecture

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-oracle-database-to-amazon-rds-for-oracle-using-oracle-data-pump.html?did=pg_card&trk=pg_card