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
-
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.
-
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
-
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
-
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.
-
Create an orapki wallet as detailed in Updating applications to use new SSL/TLS certificates.
-
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.
-
Set the parameter
DATATRANSFERMEDIUM
toDBLINK
. -
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 inDATA_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.
-
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.
-
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.
-
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:
-
Set the parameter
DATATRANSFERMEDIUM
toAMAZONS3
. -
Set the
SOURCEDATABASE_ENVIRONMENT_*
as shown in Setting Amazon as a Source Environment. -
Set the following additional parameters:
DUMPTRANSFERDETAILS_S3BUCKET_NAME=
DUMPTRANSFERDETAILS_S3BUCKET_REGION=
DUMPTRANSFERDETAILS_S3BUCKET_ACCESSKEY=
DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME=