Migrate an on-premises Oracle database to Amazon RDS for Oracle - AWS Prescriptive Guidance

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

R Type: Replatform

Source: Databases: Relational

Target: Amazon RDS for Oracle

Created by: AWS

Environment: PoC or pilot

Technology: Databases, Migration

Workload: Oracle

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 AWS Database Migration Service (AWS DMS) or using native Oracle tools such as Oracle Data Pump import/export and Oracle GoldenGate.

Prerequisites and limitations

Prerequisites

  • An active AWS account

  • An Oracle database in an on-premises data center

Limitations

  • Database size limit: 64 TB

Product versions

Architecture

Source technology stack

  • On-premises Oracle databases 

Target technology stack

  • Amazon RDS for Oracle

Source and target architecture

Using AWS DMS:

Using native Oracle tools:

Tools

  • AWS DMSAWS Database Migration Service (AWS DMS) helps you migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud, between on-premises instances (through an AWS Cloud setup), or between combinations of cloud and on-premises setups. For information about the Oracle database versions and editions that are supported, see Using an Oracle Database as a Source for AWS DMS.  

  • Native Oracle tools - Oracle Data Pump import/export, Oracle GoldenGate

Epics

Task Description Skills required
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
Task Description Skills required
Create a virtual private cloud (VPC). SysAdmin
Create security groups. SysAdmin
Configure and start an Amazon RDS DB instance. SysAdmin
Task Description Skills required
Use native Oracle tools or third-party tools to migrate database objects and data. These tools include Oracle Data Pump import/export and GoldenGate. DBA, SysAdmin
Task Description Skills required
Migrate the data with AWS DMS. DBA
Task Description Skills required
Follow the application migration strategy. DBA, SysAdmin, AppOwner
Task Description Skills required
Switch the application clients to the new infrastructure. DBA, SysAdmin, AppOwner
Task Description Skills required
Shut down the temporary AWS resources. DBA, SysAdmin
Review and validate the project documents. DBA, SysAdmin, AppOwner
Gather metrics for time to migrate, percentage of manual vs. tool, cost savings, etc. DBA, SysAdmin, AppOwner
Close out the project and provide feedback.

References

Tutorials and videos