AWS Prescriptive Guidance
Patterns

Migrate an on-premises Oracle database to Oracle on Amazon EC2

R Type :ReHost

source :Databases: Relational

target :Oracle on Amazon EC2

tags :oracle, database, amazon ec2

categories :Independent Software Vendor, Software Infrastructure

Summary

This pattern walks you through the steps for migrating an on-premises Oracle database to Oracle on an Amazon Elastic Compute Cloud (Amazon EC2) instance. It describes two options for migration: using native Oracle tools or using AWS Data Migration Service (AWS DMS).

Assumptions and Prerequisites

Prerequisites

  • An active AWS account

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

Limitations

  • The target operating system (OS) must be supported by Amazon EC2. For a complete list of supported systems, see Amazon EC2 FAQs.

Architecture

Source technology stack

  • An on-premises Oracle database: version 10g, 11g, or 12c, for the Enterprise, Standard, Standard One, or Standard Two edition. For a complete, up-to-date list of sources, see "On-premises and Amazon EC2 instance databases" in

    Sources for Data Migration

    in the AWS DMS documentation.

Target technology stack

  • An Oracle database instance on Amazon EC2: version 10g, 11g, or 12c, for the Enterprise, Standard, Standard One, or Standard Two edition. For more information, see "On-premises and Amazon EC2 instance databases" in Sources for Data Migration in the AWS DMS documentation.

Source and target architecture

AWS data migration architecture

Using AWS DMS:

Using native Oracle tools:

Tools Used

Migration options: AWS DMS or native Oracle tools

AWS DMS -AWS 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, transportable tablespaces, Oracle GoldenGate                                                         

Epics

Plan the migration

Tasks

Title Description Skills Predecessor
Validate the versions of the source and target databases. DBA
Identify the version of the target OS. DBA, SysAdmin
Identify hardware requirements for the target server instance based on the Oracle compatibility list and capacity requirements. DBA, SysAdmin
Identify storage requirements (storage type and capacity). DBA, SysAdmin
Identify network requirements (latency and bandwidth). DBA, SysAdmin
Choose the proper instance type based on capacity, storage features, and network features. DBA, SysAdmin
Identify network/host access security requirements for source and target databases. DBA, SysAdmin
Identify a list of OS users required for Oracle software installation. DBA, SysAdmin
Download AWS Schema Conversion Tool (AWS SCT) and drivers. DBA
Create an AWS SCT project for the workload, and connect to the source database. DBA
Generate SQL files for the creation of objects (tables, indexes, sequences, etc.). DBA
Determine a backup strategy. DBA, SysAdmin
Determine availability requirements. DBA
Identify the application migration/switch-over strategy. DBA, SysAdmin, AppOwner

Configure the infrastructure

Tasks

Title Description Skills Predecessor
Create a virtual private cloud (VPC) and subnets in your AWS account. SysAdmin
Create security groups and network access control lists (ACLs). SysAdmin
Configure and start the EC2 instance. SysAdmin

Install the Oracle software

Tasks

Title Description Skills Predecessor
Create the OS users and groups required for the Oracle software. DBA, SysAdmin
Download the required version of Oracle software.
Install the Oracle software on the EC2 instance. DBA, SysAdmin
Create objects like tables, primary keys, views, and sequences by using the scripts generated by AWS SCT. DBA

Migrate data - option 1

Tasks

Title Description Skills Predecessor
Use native Oracle tools or third-party tools to migrate database objects and data. Oracle tools include Data Pump import/export, RMAN, transportable tablespaces, and GoldenGate. DBA

Migrate data - option 2

Tasks

Title Description Skills Predecessor
Determine the migration method. DBA
Create a replication instance in the AWS DMS console. DBA
Create source and target endpoints. DBA
Create a replication task. DBA
Enable change data capture (CDC) to capture changes for a continuous replication. DBA
Run the replication task and monitor logs. DBA
Create secondary objects like indexes and foreign keys when the full load is done. DBA

Migrate the application

Tasks

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

Cut over

Tasks

Title Description Skills Predecessor
Follow the application cutover/switch-over strategy. DBA, SysAdmin, AppOwner

Close the project

Tasks

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

References and Help

References

Tutorial & videos

Contact and help

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