Learn About Migrating a Database Cloud Service Deployment to a New Shape with the ibkup Utility

Consider moving your single-instance database from Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure to take advantage of the additional regions, services, and features. Oracle's Generation 2 Cloud infrastructure is based on the latest cloud technologies and standards, and typically provides better performance and more localized geographic locations than Oracle Cloud Infrastructure Classic.

Architecture

Migrate your single-instance database from Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure using the ibkup utility.

You can use the ibkup utility to restore a database on the cloud from a backup. Oracle recommends that you keep the database on the source Oracle Cloud Infrastructure Classic shape down until migration to the target Oracle Cloud Infrastructure shape is complete.

Description of the illustration mm-3269_ocips_pb_001c.eps

Use the ibkup utility to populate the target database from a backup of the source database.

The utility supports migrating the following single-instance Oracle Database releases from Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure:

• Oracle Database 11g release 2 (11.2.0.4)

• Oracle Database 12c release 1 (12.1.0.2) and release 2 (12.2.0.1)

• Oracle Database 18c

Perform the migration as follows:

1. Plan the migration.

   Planning the migration entails taking inventory of the source environment (the source Oracle Database) and deciding on the best migration strategy. To inventory the source environment, you must perform tasks such as determining the sizes of database files and checking which disaster recovery plans are in place. To decide on the best strategy, you should plan, for example, the best time of day to perform the migration.

2. Prepare for the migration.

   To prepare to migrate to the target environment (the target Oracle Database), you must perform tasks such as ensuring that the database that you want to migrate is running and applying the latest patches to the target database.

3. Perform the migration.

   Finally, perform the migration by backing up the source database and using the backup to create the target database using the ibkup utility.

Requirements for Oracle Database Migration

Before you begin migrating an Oracle database, be aware of the following:

• You have completed all prerequisites necessary to enable Oracle Database Cloud Service on the target Oracle Cloud Infrastructure shape.

• The single-instance database you want to migrate from the source Oracle Cloud Infrastructure Classic shape to the target Oracle Cloud Infrastructure shape is up and running.

• Because you use the ibkup utility to migrate the Oracle database, complete downtime during the migration occurs. Oracle recommends that you keep the database on the source Oracle Cloud Infrastructure Classic shape down until migration to the target Oracle Cloud Infrastructure shape is complete.

• This migration procedure is applicable only for single-instance Oracle Database Cloud Service because the ibkup utility is applicable only to single-instance databases and not for Oracle Real Application Clusters databases.

• Ensure that you have applied all patches (including one-off patches), equally, to both the source and the target databases. If the patch level of the source and target databases are different, then run data patch to apply the SQL portion of the most recent patches available on the target database. Follow the patch README for exact statements you must run.

• Apply any one-off patches to the target database that you have applied to the source database.

For this document, the following names have been used for the source and target database systems:

• Service Name
  • Source Database: MIGDB
  • Target Database: MIGDBOCI
• Database Name
  • Source Database: TSTDB
  • Target Database: TSTDB

About Required Services and Roles

This solution requires the following services:

• Oracle Cloud Infrastructure Classic
• Oracle Database Cloud Service

• Oracle Cloud Infrastructure Tenancy

These are the roles needed for each service:

Service Name: Role	Required to...
Oracle Cloud Infrastructure Classic: Administrator (SYSDBA privileges)	Perform SYS-related administration tasks.
Oracle Cloud Infrastructure: Administrator (SYSDBA privileges)	Perform SYS-related administration tasks.

See Learn how to get Oracle Cloud services for Oracle Solutions to get the cloud services you need.

Before You Begin

Learn more about migrating databases. See Learn about reducing downtime during a database migration.