Migrating from Oracle Database 11g to Oracle Database 12c in the Cloud

You can migrate Oracle Database 11g databases from on-premises to Oracle Database 12c databases in the Database service using several different methods.

The applicability of some of the migration methods depends on the on-premises database's version, database character set and platform endian format.

If you have not already done so, determine the database version and database character set of your on-premises database, and determine the endian format of the platform your on-premises database resides on. Use this information to help you choose an appropriate method.

  • Data Pump Conventional Export/Import

    This method can be used regardless of the endian format and database character set of the on-premises database.

    For the steps this method entails, see Data Pump Conventional Export/Import.

  • Data Pump Transportable Tablespace

    This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and the Databaseservice database are compatible.

    For the steps this method entails, see Data Pump Transportable Tablespace.

  • RMAN Transportable Tablespace with Data Pump

    This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and the Database service database are compatible.

    For the steps this method entails, see RMAN Transportable Tablespace with Data Pump.

  • RMAN CONVERT Transportable Tablespace with Data Pump

    This method can be used only if the database character sets of your on-premises database and the Database service database are compatible.

    This method is similar to the Data Pump Transportable Tablespace method, with the addition of the RMAN CONVERT command to enable transport between platforms with different endianness. Query V$TRANSPORTABLE_PLATFORM to determine if the on-premises database platform supports cross-platform tablespace transport and to determine the endian format of the platform. The Database service platform is little-endian format.

    For the steps this method entails, see RMAN CONVERT Transportable Tablespace with Data Pump.

  • Data Pump Full Transportable

    This method can be used only if the source database release version is 11.2.0.3 or later, and the database character sets of your on-premises database and the Database service database are compatible.

    For the steps this method entails, see Data Pump Full Transportable.