Migrating from Amazon Web Services RDS Oracle to Oracle Cloud

You can migrate an Oracle Database from Amazon Web Services (AWS) RDS to Oracle Autonomous Database (ADB), OCI user-managed databases, and Exadata Cloud at Customer using the Zero Downtime Migration logical migration method (online and offline).

Setting Amazon as the Source Environment

In the Zero Downtime Migration logical migration response file, set the following parameters to migrate Oracle databases from Amazon Web Services:

SOURCEDATABASE_ENVIRONMENT_NAME=AMAZON

SOURCEDATABASE_ENVIRONMENT_DBTYPE=RDS_ORACLE

Configure Secure Connections

Ensure that the subnet Amazon RDS security policy allows connections from Zero Downtime Migration to the DB instance on the specified secure port. See the AWS documentation for details:

Scenarios for accessing a DB instance in a VPC

Scenarios for accessing a DB instance not in a VPC

Setting Endpoint Information

  1. Find the Amazon RDS Oracle Instance endpoint (DNS name) and port number in the RDS console DB Instance Connectivity & security tab.

    See Finding the endpoint of your Oracle DB instance for detailed help.

  2. Specify the endpoint and port number information in following Zero Downtime Migration logical response file parameters:

    SOURCEDATABASE_ADMINUSERNAME

    SOURCEDATABASE_CONNECTIONDETAILS_HOST

    SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME

    SOURCEDATABASE_CONNECTIONDETAILS_PORT

  3. If connecting to Amazon RDS from the Zero Downtime Migration service host requires a proxy, then specify these logical response file parameters:

    SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME

    SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT

Allowing Zero Downtime Migration to connect to Amazon RDS Oracle DB instance using SSL/TLS

  1. Enable Secure Socket Layer (SSL) or Transport Layer Security (TLS) in the Amazon RDS Oracle Instance to secure the connection from Zero Downtime Migration to Amazon RDS Oracle Instance. See Encrypting client connections with SSL for details.

  2. Create an orapki wallet as detailed in Updating applications to use new SSL/TLS certificates.

  3. Set the following parameters in the Zero Downtime Migration logical response file:

    SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME

    SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION

Configuring the Data Transfer Method

To transfer the data from AWS, you have the following options:

  • Amazon Simple Storage Service (Amazon S3) Bucket
  • Database link (DBLINK)

Setting Up Database Link Transfer Method

To use a database link (DBLINK) to migrate Amazon RDS Oracle Database schema to Oracle Autonomous Database (ADB), you must have direct network connectivity between the Amazon RDS Oracle instance and the ADB target.

Set the following parameters in the Zero Downtime Migration logical response file.

  1. Set the parameter DATATRANSFERMEDIUM to DBLINK.

  2. Set the parameter SOURCEDATABASE_ENVIRONMENT_* as shown in Setting Amazon as a Source Environment.

Setting Up S3 Bucket Data Transfer Medium

Zero Downtime Migration performs the following steps to migrate an Amazon RDS Oracle Database schema to Oracle Autonomous Database target using an S3 bucket:

  • Export dumps - Invoke the DBMS_DATAPUMP procedure in the Amazon RDS Oracle Database instance to generate dumps in DATA_PUMP_DIR.

  • Upload dumps to S3 using RDSADMIN – Upload dumps from the RDS instance to the specified S3 bucket.

  • Import dumps from S3 to ADB – Import the schema to the ADB instance from the S3 bucket.

To configure the environments to use the S3 bucket for data transfer, complete the following tasks.

Complete AWS RDS Prerequisites

The RDS Oracle instance must have been integrated with S3 and the DB user should be allowed to upload the dumps to S3 bucket via RDSADMIN package.

  1. Integrate RDS and S3 - Ensure that the RDS instance and S3 are integrated.

    Enable RDS and S3 integration for the Oracle Database instance if not configured already.

    See Amazon S3 integration for the detailed steps.

  2. S3 Access Key - Create and provide Zero Downtime Migration with the AWS S3 Access Key and Access secret.

    See AWS Account and Access Keys for the detailed steps.

  3. S3 and RDS region - Ensure that the S3 bucket and RDS Oracle Database instance are in the same region, for example us-east-2.

Set Required Response File Parameters

Set the following parameters to perform a migration using the S3 bucket:

  1. Set the parameter DATATRANSFERMEDIUM to AMAZONS3.

  2. Set the SOURCEDATABASE_ENVIRONMENT_* as shown in Setting Amazon as a Source Environment.

  3. Set the following additional parameters:

    DUMPTRANSFERDETAILS_S3BUCKET_NAME=

    DUMPTRANSFERDETAILS_S3BUCKET_REGION=

    DUMPTRANSFERDETAILS_S3BUCKET_ACCESSKEY=

    DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME=