Migrate the Database

Migrate the database by saving an RMAN backup to Oracle Object Storage Service, then instantiate the backup onto the target database.

Create a Backup to Oracle Storage Service

For a 1-node (single instance) database, create an Oracle Recovery Manager (RMAN) backup of the source database in Oracle Cloud Infrastructure Classic and restore the back in Oracle Cloud Infrastructure.

The shell scripts are wrappers for the ansible-playbook utility. Use the scripts to create a backup and restore the backup.
  1. Execute the setup_STEP0_backup.sh script on the source to create a backup on Oracle Cloud Infrastructure Object Storage Classic.
    ./setup_STEP0_backup.sh
  2. Execute the setup_STEP1_restore_SI.sh script on the target Oracle Cloud Infrastructure database system to restore the database.
    ./setup_STEP1_restore_SI.sh

Convert a 1-Node Database to a Virtual Machine Database

Convert a single instance (1-node) database into an Oracle Real Application Clusters (Oracle RAC) One Node database on an Oracle Cloud Infrastructure virtual machine.

  • Run the setup_STEP2_convert_to_VMDB_RAC.sh script:
    ./setup_STEP2_convert_to_VMDB_RAC.sh

Convert a 1-Node Database to an Oracle Database Exadata Cloud Service

Convert a single instance (1-node) database into an Oracle Database Exadata Cloud Service on Oracle Cloud Infrastructure.

  • Run the setup_STEP2_convert_to_ExaCS_RAC.sh script to convert the source 1-node database into an Oracle Database Exadata Cloud Service.
    ./setup_STEP2_convert_to_ExaCS_RAC.sh

Instantiate a Virtual Machine Database From the Backup

For a Virtual Machine Database, execute a script to create a backup in the Oracle Cloud Infrastructure Control Plane using the Automatic Backup feature available in the Oracle Cloud Infrastructure Console and then instantiate from the backup.

Two backup options are available:
  • Automatic backup feature in the Oracle Cloud Infrastructure. You can change the automatic backup configuration by changing the deployment’s backup destination. Console.
  • Manual backup executed with the command-line interface using a pre-defined backup destination.
  1. To use automatic backups, go to the Console and enable the automatic backup configuration.
    1. Under Database, click Bare Metal, VM, and Exadata.
    2. Select your Compartment.
    3. Find the database and click the name to display database details.
    4. Click Configure Automatic Backups.
    5. Check Enable Automatic Backup.
    6. Click Save Changes.
  2. To use manual backup instead of the automatic backup, disable the automatic backup configuration in the Console, create an Oracle Cloud Infrastructure Object Storage for the endpoint URL, and then define all of the oracle_target_database_oci_ variables in the setup.json file.
    When using automatic backup, do not define the variables.
    cat setup.json | grep oracle_target_database_oci_
  3. Using the DBCLI, execute the setup_STEP3_backup_config.sh script to set the backup in Oracle Cloud Infrastructure Control Plane.
    ./setup_STEP3_backup_config.sh
  4. (Optional) Display the list of jobs using the dbcli list-jobs command and review the status of the jobs.
    /opt/oracle/dcs/bin/dbcli list-jobs
  5. Disable the automatic backup in the Oracle Cloud Infrastructure Console.
    1. Under Database, click Bare Metal, VM, and Exadata.
    2. Select your Compartment.
    3. Find the database and click the name to display database details.
    4. Click Configure Automatic Backups.
    5. Check Disable Automatic Backup.
    6. Click Save Changes.

Test and Validate the Migrated Database

Run a script to test and validate that the database migrated as expected.

  1. Test and validate the migrated database by running the test_after_setup.sh script.
    ./test_after_setup.sh
    The script generates a report.
  2. Review the output of the text file report in the /report subdirectory.
    A report is generated for each node of an Oracle RAC database.
    The report shows the following test results after migration:
    • Database Instance Name
    • Database Unique Name
    • Database Oracle Home
    • Database Version
    • Oracle Cloud Infrastructure Platform
    • Oracle Cloud Infrastructure RAC host name
    • Status of the databases on all nodes