Methods for Migrating the On premise Oracle Databases to the Oracle Cloud Infrastructure(OCI)

Methods for Migrating the On premise Oracle Databases to the Oracle Cloud Infrastructure(OCI)


You can migrate your on-premises Oracle Database to an Oracle Cloud Infrastructure Database service database using a number of different methods that use several different tools. 

  1. Data Pump Conventional Export/Import
  2. Data Pump Full Transportable
  3. Data Pump Transportable Tablespace
  4. Remote Cloning a PDB
  5. Remote Cloning Non-CDB
  6. RMAN Cross-Platform Transportable PDB
  7. RMAN Cross-Platform Transportable Tablespace Backup Sets
  8. RMAN Transportable Tablespace with Data Pump
  9. RMAN DUPLICATE from an Active Database
  10. RMAN CONVERT Transportable Tablespace with Data Pump
  11. SQL Developer and INSERT Statements to Migrate Selected Objects
  12. SQL Developer and SQL*Loader to Migrate Selected Objects
  13. Unplugging/Plugging a PDB
  14. Unplugging/Plugging Non-CDB
  15. GoldenGate
  16. Zero Downtime Migration Service
  17. OCI Database Migration Service

The above methods that applies to a given migration scenario depends on several factors, including the version, character set, and platform endian format of the source and target databases.

Also Oracle now offers two new solutions for migrating Oracle database workloads from on-premises and Oracle Cloud Infrastructure Classic to a variety of Oracle Database Cloud services: Oracle Cloud Infrastructure Database Migration Service and Zero Downtime Migration.

Zero Downtime Migration (ZDM) is an installable tool which provides you with a simplified and automated migration experience, providing zero to negligible downtime for the production system.

OCI Database Migration Service is based on the ZDM tool, and as a managed OCI service it provides you with a user interface to move Oracle databases to Oracle Cloud.

Choosing a Migration Method

Not all migration methods apply to all migration scenarios. Many of the migration methods apply only if specific characteristics of the source and destination databases match or are compatible. Moreover, additional factors can affect which method you choose for your migration from among the methods that are technically applicable to your migration scenario.

To determine which migration methods are applicable to your migration scenario, gather the following information.

Some of the characteristics and factors to consider when choosing a migration method are:

  1. On-premises database version
  2. Database service database version
  3. On-premises host operating system and version
  4. On-premises database character set
  5. Quantity of data, including indexes
  6. Data types used in the on-premises database
  7. Storage for data staging
  8. Acceptable length of system outage
  9. Network bandwidth
  10. Multitenant container database (CDB)
  11. Non-CDB
  12. Endian format (byte ordering) of your on-premises database’s host platform

Some platforms are little endian and others are big endian. Query V$TRANSPORTABLE_PLATFORM to identify the endian format, and to determine whether cross-platform tablespace transport is supported.

The Oracle Cloud Infrastructure Database uses the Linux platform, which is little endian.

Database character set of your on-premises database and the Oracle Cloud Infrastructure Database database.

Some migration methods require that the source and target databases use compatible database character sets.

Migration Connectivity Options

You have several connectivity options when migrating your on-premises databases to the Oracle Cloud Infrastructure. The options are listed below in order of preference.

FastConnect:

Provides a secure connection between your existing network and your virtual cloud network (VCN) over a private physical network instead of the internet. For more information, see FastConnect.

Site-to-Site VPN: 

Provides a secure connection between a dynamic routing gateway (DRG) and customer-premise equipment (CPE), consisting of multiple IPSec tunnels. The IPSec connection is one of the components forming a Site-to-Site VPN between a VCN and your on-premises network. For more information, see Site-to-Site VPN.

Internet gateway:

Provides a path for network traffic between your VCN and the internet.

appsdbahelp

17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows. Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning. Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures. Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment Experience in Terraform, JSON and chef cloud infrastructure automation framework Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache Ability to analyze problem, develops solutions and bring program/project execution to completion.

Post a Comment

Previous Post Next Post