AWS Prescriptive Guidance
Patterns

Migrate an on-premises Oracle database to Amazon RDS for Oracle

R Type :RePlatform

source :Databases: Relational

target :Amazon RDS for Oracle

tags :oracle, database, rds

categories :Independent Software Vendor, Software Infrastructure

Summary

This pattern describes the steps for migrating on-premises Oracle databases to Amazon Relational Database Service (Amazon RDS) for Oracle. It describes two options for migration: using native Oracle tools or using AWS Data Migration Service (AWS DMS).

Assumptions and Prerequisites

Assumptions and limitations

  • Database size limit: 16 TB

Prerequisites

  • An active AWS account

  • An Oracle database (versions 10g, 11g, or 12c), for the Enterprise, Standard, Standard One, or Standard Two edition, in an on-premises data center

Architecture

Source technology stack

  • On-premises Oracle databases (versions 10g, 11g, and 12c), for the Enterprise, Standard, Standard One, and Standard Two editions

Target technology stack

Source and target architecture

Using AWS Database Migration Service (AWS DMS):

U

sing native Oracle tools:

Tools Used

Migration options: AWS DMS or native Oracle tools

AWS DMSAWS Database Migration Services (AWS DMS) supports several types of source and target databases. For information about the database versions and editions that are supported, see Using an Oracle Database as a Source for AWS DMS. If the source database is not supported by AWS DMS, select another method for migrating the data. 

Native Oracle tools - RMAN, Data Pump import/export

Epics

Plan the migration

Tasks

Title Description Skills Predecessor
Validate the versions of the source and target databases. DBA
Identify the hardware requirements for the target server instance. DBA, SysAdmin
Identify storage requirements (storage type and capacity). DBA, SysAdmin
Choose the proper instance type based on capacity, storage features, and network features. DBA, SysAdmin
Identify the network access security requirements for the source and target databases. DBA, SysAdmin
Identify the application migration strategy. DBA, SysAdmin, AppOwner

Configure the infrastructure

Tasks

Title Description Skills Predecessor
Create a virtual private cloud (VPC). SysAdmin
Create security groups. SysAdmin
Configure and start an Amazon RDS instance. SysAdmin

Migrate data - option 1

Tasks

Title Description Skills Predecessor
Use native Oracle tools or third-party tools to migrate database objects and data. DBA, SysAdmin

Migrate data - option 2

Tasks

Title Description Skills Predecessor
Migrate the data with AWS DMS. DBA

Migrate the application

Tasks

Title Description Skills Predecessor
Follow the application migration strategy. DBA, SysAdmin, AppOwner

Cut over

Tasks

Title Description Skills Predecessor
Switch the application clients to the new infrastructure. DBA, SysAdmin, AppOwner

Close the project

Tasks

Title Description Skills Predecessor
Shut down the temporary AWS resources. DBA, SysAdmin
Review and validate the project documents. DBA, SysAdmin, AppOwner
Gather metrics for time to migrate, % of manual vs. tool, cost savings, etc. DBA, SysAdmin, AppOwner
Close out the project and provide feedback.

References and Help

References

Tutorials and videos

Contact and help

Migration Pattern Library Support: aws-mpl@amazon.com