Oracle Cloud Infrastructure Documentation

Migrating between Oracle Autonomous Database instances with OCI Database Migration service

Following are the prerequisites and procedures for migrating between two Oracle Autonomous Database instances using OCI Database Migration Service. The following data transfer methods can be used: Network File System (NFS) and Database Link (DBLINK).

Required Parameter for Online Migrations

For online migrations, you must use GGADMIN or admin with the following grants on both source and target database. For example:
GRANT SELECT ON SYS.V_$SESSION TO ggadmin;
GRANT SELECT ON SYS.V_$TRANSACTION TO ggadmin;
GRANT SELECT ON SYS.V_$DATABASE TO ggadmin;

ALTER SYSTEM SET GLOBAL_NAMES=FALSE;

ALTER PLUGGABLE DATABASE ADD SUPPLEMENTAL LOG DATA;

GRANT PDB_DBA to ggadmin;

In Migration, go to Replication.

In Advanced parameters, when performing an online migration, you must set the following advanced parameter in the migration configuration:

In GOLDENGATESETTINGS, set the value of Skip Oracle GoldenGatereload_query_advisor to TRUE.

Migration Method 1: Using a Network File System (NFS)

This method uses a shared OCI File Storage (NFS) file system to transfer the Data Pump files. The service orchestrates the mounting and unmounting of this file system directly on the ADB instances.

Before you begin, you must unmount the specific file system when you select in the Oracle Cloud Console.
  1. Unmount File System: On both the source and target ADB instances, ensure the OCI File Storage (NFS) you plan to use for the migration is unmounted.
  2. Clean the source directory: On the source ADB instance, you must clean up ALL files within the DATA_PUMP_DIR directory. The service automatically uses this directory path to mount the NFS share, and the mount operation will fail if the directory is not empty.
  3. Prepare the target directory: On the target ADB instance, you can either specify an existing empty directory or let the service create one. Oracle recommends to let the service create the directory, as it will automatically handle mounting the file system for you.

After completing the prerequisites, you can run the migration job. The service manages the attachment of the NFS file system for the data transfer.

Migration Method 2: Using a Database Link (DBLINK)

Create Database Links: You must create a database link on both the source and target ADB Shared instances.

Note

The database links on the source and target must have the exact same name. For detailed instructions, see Use Database Links with Autonomous Database.

Parent topic: Reference