Migrating an On-Premises Database to Oracle Cloud Infrastructure by Creating a Backup in the Cloud

The scripted migration process is compatible with the following bare metal and virtual machine DB system configurations:

On the source database host:

• Outbound internet connectivity for installing Python packages, running yum install, and access to the Oracle Cloud Infrastructure API and Object Storage.

• RMAN configuration to autobackup controlfile and spfile:

  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

  Note
  
  RMAN configuration changes must be completed prior to running the script. The script may modify RMAN parameters as required to complete the backup and migration tasks.

Perform the following tasks on the source database host:

1. Create a directory named /home/oracle/migrate.

   Tip
   
   You can name the migrate portion of the directory path anything you want. If you use a different name, you must adjust all of the paths that appear in this task accordingly. The following examples assume the name migrate for simplicity and clarity.

2. As root, run the CLI installer in the directory you created in step 1. (For example, /home/oracle/migrate.) See Installing the CLI for instructions on running the installer script in either Windows or the Bash environment (for MacOS, Linux, and Unix).

   The installer installs Python 3.6.0 if either Python 2.7 or Python 3.6 does not exist on the machine. The installer also installs the Python script required to create and migrate a standalone backup from an on-premises database.

   On Oracle Linux 6, a newer version of Python (such as Python 3.6.0) is usually required. Use the following instructions to configure Oracle Linux 6 before running the backup script.

3. Copy the following files into the new directory:

   • Oracle Database Backup Module (opc_install.jar)
   • Your API *.pem key file.

4. Respond to the prompts as follows:

   
   (yum install)
   Is this ok [y/N]: y
   
   ===> Missing native dependencies. Continue and install the following dependencies: gcc, libffi-devel, python36u-devel, openssl-devel? (Y/n): Y
   
   ===> In what directory would you like to place the install? (leave blank to use '/root/lib/oracle-cli'): /home/oracle/migrate/lib/oracle-cli
   
   ===> In what directory would you like to place the 'oci' executable? (leave blank to use '/root/bin'): /home/oracle/migrate/bin
   
   ===> In what directory would you like to place the OCI scripts? (leave blank to use '/root/bin/oci-cli-scripts'): /home/oracle/migrate/bin/oci-cli-scripts
   
   ===> Currently supported optional packages are: ['db (will install cx_Oracle)'] What optional CLI packages would you like to be installed (comma separated names; press enter if you don't need any optional packages)?: db
   
   ===> Modify profile to update your $PATH and enable shell/tab completion now? (Y/n): Y
   
   ===> Enter a path to an rc file to update (leave blank to use '/root/.bashrc'): /home/oracle/.bashrc

5. Perform the following file operations:

   
   
   # mv /home/oracle/migrate/lib/oracle-cli/lib/python<version>/site-packages/oci_cli/scripts/dbaas.py /home/oracle/migrate/lib/oracle-cli/lib/python<version>/site-packages/oci_cli/scripts/dbaas_orig.py
   # cp /home/oracle/migrate/dbaas_0704.py /home/oracle/migrate/lib/oracle-cli/lib/python<version>/site-packages/oci_cli/scripts/dbaas.py
   
   
   # chown -R oracle:oinstall /home/oracle/migrate

6. Edit the /home/oracle/migrate/config.txt file

   [DEFAULT]
   tenancy=<your_tenancy_OCID>
   user=<your_user_OCID>
   fingerprint=<fingerprint>
   key_file=/home/oracle/migrate/<your_api_key>.pem
   region=<region>

   If you do not know your API signing key's fingerprint, see How to Get the Key's Fingerprint.

7. As oracle user (not root), run one of the following sets of commands, depending on the type of database you are migrating.

   For a non-TDE database:

   export AD=<destination_availability_domain>
   export C=<destination_compartment_OCID>
   export ORACLE_SID=<ORACLE_SID>
   export ORACLE_HOME=<ORACLE_HOME>
   export PATH=$PATH:$ORACLE_HOME/bin
   export LC_ALL=en_US.UTF-8
   export ORACLE_UNQNAME=<source_DB_unique_name>
   rm -rf /home/oracle/migrate/onprem_upload
   cd /home/oracle/migrate/bin/oci-cli-scripts/
   ./create_backup_from_onprem --config-file /home/oracle/migrate/config.txt --display-name <example_display_name> --availability-domain $AD --edition ENTERPRISE_EDITION_EXTREME_PERFORMANCE --opc-installer-dir /home/oracle/migrate --tmp-dir /home/oracle/migrate/onprem_upload --compartment-id $C --rman-password <password>

   For a TDE-enabled database:

   export AD=<destination_availability_domain>
   export C=<destination_compartment_OCID>
   export ORACLE_SID=<ORACLE_SID>
   export ORACLE_HOME=<ORACLE_HOME>
   export PATH=$PATH:$ORACLE_HOME/bin
   rm -rf /home/oracle/migrate/onprem_upload
   cd /home/oracle/migrate/bin/oci-cli-scripts/
   ./create_backup_from_onprem --config-file /home/oracle/migrate/config.txt --display-name <example_display_name> --availability-domain $AD --edition ENTERPRISE_EDITION_EXTREME_PERFORMANCE --opc-installer-dir /home/oracle/migrate --tmp-dir /home/oracle/migrate/onprem_upload --compartment-id $C

   See the following list of parameters used by the script for more details.

8. Launch a new DB system using the backup you created in the preceding step. See Create a DB System from a Backup Using the Console for information on creating a new DB system from a backup.