Next steps
After you determine that you can safely downgrade a database to Oracle Database Standard Edition 2 (SE2) on Amazon RDS for Oracle, you can migrate the database by using one or a combination of the following tools:
-
Oracle import and export utilities can move Oracle data in and out of Oracle databases. Oracle offers two types of database import and export utilities: Oracle Export and Import (for earlier releases) and Oracle Data Pump (available in Oracle Database 10g and later).
-
Oracle GoldenGate offers real-time replication capabilities so that you can synchronize your target database after an initial load. This option can help reduce application downtime during go-live.
-
AWS 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 databases. The change data capture (CDC) option of AWS DMS offers continuous replication, so that you can reduce the total downtime during migration. For information about the Oracle database versions and editions that AWS DMS supports, see the AWS DMS documentation.
Depending on your availability requirements during the downgrade, you can adopt any of the following options to safely downgrade your Enterprise Edition database to Standard Edition 2 on Amazon RDS for Oracle.
Downgrading with downtime
-
Use Oracle Data Pump to create consistent export of data from the Enterprise Edition database and import that data into the Standard Edition 2 database. For more information, see Step by Step Procedure to Convert from Enterprise Edition to Standard Edition (Doc ID 465189.1)
. Oracle credentials are required. -
Use AWS DMS to perform a full load of data from the Enterprise Edition database to the Standard Edition 2 database.
-
Use Oracle GoldenGate to perform a full instantiation of the Standard Edition 2 database from the Enterprise Edition database.
Downgrading with reduced downtime
-
Use Oracle Data Pump for consistent export and import of the initial load, and use AWS DMS CDC for data synchronization.
-
Use Oracle Data Pump for consistent export and import of the initial load, and use Oracle GoldenGate for data synchronization.
-
Use AWS DMS for the full load and for data synchronization.
-
Use Oracle GoldenGate for full instantiation and for data synchronization.
For more information on migrating Oracle databases to Amazon RDS for Oracle, see the following AWS Prescriptive Guidance documentation:
