A migration resource is a definition of your migration containing all settings and parameters that are eventually used when performing a migration.

The following procedure explains how to create migrations, which contain the settings for running migration jobs with Database Migration. You can create multiple migration resources with different parameter settings to test different scenarios.

Creating a Migration

1. Log in to the Console as a user with permissions to access Database Migration.

2. Open the navigation menu. Under Database Migrations click Migrations. A list of the migration resources in the currently selected compartment is displayed.

3. Click Create migration.

   This opens the Create migration wizard.

4. In the General Information step, configure the following settings, then click Next.

   • Name: Enter a unique name for the migration.

     On completion of the Create Migration wizard, the name you enter here is displayed in the list of migrations on the Migrations page.

   • Add an optional Description: for the migration resource.

   • Compartment: Select the compartment in which the Database Migration service is hosted.

5. The Show advanced options section allows you to optionally create tags.

6. In the Select databases step, enter the following information, then click Next.

   Enter the following information in the Source database box.

   • Database connection in Compartment: Select the source database connection entry.

     If the source database is a PDB, make sure you selected the PDB database connection in the drop-down, not the CDB connection.

     Do not choose an Autonomous Database connection, as Autonomous is not supported as a source database.

   • Database is pluggable database (PDB): If the source database is a PDB, check this box so you can also enter the CDB details.

     Container database connection in Compartment: If the source database is a PDB, select the CDB you selected here. The CDB connection is not required if you are doing an offline migration.

   Enter the following information in the Target database box.

   • Database connection in Compartment: Select the target database connection.

7. In the Migration options step, select one of the following transfer mediums based on your requirement for your migration:

   • Select an Initial load option:

     Data Pump via database link: Enable this option to use a direct SQL*Net connection between the source and target databases. Note that using Data Pump with a database link to Autonomous Database targets requires that the source database be set up with SSL encryption.

     Note
     
     If your source database is Oracle Database Standard Edition 2, select the Datapump via database link: option as the transfer medium. Encryption for the exported Datapump dumps is not available for the object storage or file storage transfer mediums.

     Data Pump via object storage: This option lets Data Pump temporarily store the exported database in an Object Storage bucket. If this option is enabled, also configure the following settings.

     • Amazon S3 bucket: Enter the details for the Amazon S3 bucket. This option is only shown if the source database connection is of type Amazon RDS.

       The bucket Name must be between 3 and 63 characters, and can consist only of lower case letters, numbers, dots (.), and hyphens (-). It must begin and end with a letter or number.

       The Region must be in the same region as the RDS Oracle database. For example us-east-1

       For more information about the Amazon RDS source database use case, see Migrating Databases from Amazon Web Services RDS to Oracle Autonomous Database.

     • Export directory object: Enter the file Name and Path to the directory object that will be used by Data Pump export on the source database server file system. Database Migration handles the directory object creation for you.

       The name must comply with Oracle Database directory object rules. See CREATE DIRECTORY in Oracle Database SQL Language Reference.

     Note
     
     Oracle recommends using Data Pump via object storage as the preferred transfer medium. Data Pump via database link is only recommended for small databases as you cannot enable parallelism which affects the migration performance.
     Data Pump via file storage: Enable this option to use a shared File Storage Service (FSS) mount as the transfer medium between source and target databases.

     • Network access to your file system is provided through a mount target (OCID provided in the OCI Console).
     • Your file system must have at least one export in the mount target used to mount and use the file system.
     • When creating the file system using the OCI Console, the workflow also creates a mount target and an associated export.
     • Exports control how NFS clients access file systems when they connect to a mount target.

     Note
     
     Following are the prerequisites to use this option:

     • You must Create a File System and specify the mount target and the export path.
     • You must have the shared file system mounted on both the source and target database hosts.
     • Supported source database: This transfer medium is supported for all the supported on-premises database cases excluding Amazon RDS.
     • Supported target database : This transfer medium is supported for both non-ADB and ADB target databases (All Oracle Cloud Infrastructure co-managed and Exadata).
     • To perform the Data Pump export, you must have the read or write access to the shared mounts on the source host.
     • On the target database host, you must at least have read access to the shared mount to perform the Data Pump import.
     • See Mounting File Systems and Creating a Mount Target for more information.

     Enter the following information in the Source database box:

     • Export directory object name: Name of the export directory object
     • Export directory object path: The shared file system mount path on the source database with read and write access.
     • Source Database file system SSL Wallet Path
       Note
       
       This field is displayed only when the SSH details are not provided during source database connection while performing migration to Autonomous database.

     If you enable this option when the target database is Autonomous database, then configure the following settings. Enter the following information in the Target database box:

     • Shared storage mount target in compartment: The file system mount target to be used in the target database.
       Note
       
       You can use the mount targets only when the target database is Autonomous database. For any other databases, use the shared file system based mount point.
     • Import directory object name: The Data Pump import directory object name used to mount the shared file system.

     If you enable this option when the target database is non Autonomous database, then configure the following settings. Enter the following information in the Target database box:

     • Import directory object name: The Data Pump import directory object name used to mount the shared file system.
     • Import directory object path: The Data Pump import directory object name used to mount the shared file system.

   • Object storage bucket in Compartment: Select the object storage bucket. This bucket is used for any Cloud Premigration Advisor Tool reports, Database Migration, and Data Pump log storage, and Data Pump dump files.

     If the bucket is in a different compartment, click Change Compartment to look in another compartment.

8. If the source or the target database is non-ADB, then the following fields are shown when the initial Data Pump load is performed via object storage or file storage:

   Enter the following information in the Source database box:

   • Export directory object name:
   • Export directory object path:
   • Source Database file system SSL Wallet Path
     Note
     
     This field is displayed only when the SSH details are not provided during source database connection.

   Enter the following information in the Target database box:

   • Import directory object name
   • Import directory object path
   • Target Database file system SSL Wallet Path
     Note
     
     This field is displayed only when the SSH details are not provided during target database connection.
   If your source or target is non-ADB and you did not provide the SSH details for both source and target database when creating your database connection, and your transfer medium is object storage, you must perform the following steps:

   • Download SSL Wallet with Certificates
   • Set up Network ACL

   You can download a pre-created wallet.

   To download a wallet:

   1. Download the wallet file.
   2. Unzip the certificate files to a directory on the file system of your database host.
   3. Enter this location in SSL Wallet Path when creating the migration.

   The user performing the export or import requires the necessary network ACL to be granted to access the network from the source and target database host.

   In the following example, run the following commands as SYS if the export or import user is SYSTEM. If your database is multitenant, then perform the following actions in CDB$ROOT. Restrict the host as required.

   Security consideration: Do not allow a complete network access from the database. Restrict the host access to the required OCI object storage region. For example, https://objectstorage.us-ashburn-1.oraclecloud.com and ACL can be time restricted with relevant start_date and end_date arguments in DBMS_NETWORK_ACL_ADMIN.CREATE_ACL. For example:

   @$ORACLE_HOME/rdbms/admin/sqlsessstart.sql
   define clouduser=<user performing export at src or import at target e.g., SYSTEM>
   define sslwalletdir=< OCI wallet path e.g., /opt/oracle/dcs/commonstore/import_dmp/nossh_wallet>
   begin
   dbms_network_acl_admin.append_host_ace(
           host =>'*',
           lower_port => 443,
           upper_port => 443,
           ace => xs$ace_type(
                   privilege_list => xs$name_list('http', 'http_proxy'),
                   principal_name => upper('&clouduser'),
                   principal_type => xs_acl.ptype_db));
   dbms_network_acl_admin.append_wallet_ace(
       wallet_path => 'file:&sslwalletdir',
           ace => xs$ace_type(privilege_list =>
                   xs$name_list('use_client_certificates', 'use_passwords'),
                   principal_name => upper('&clouduser'),
                   principal_type => xs_acl.ptype_db));
   end;
   
   /
   @$ORACLE_HOME/rdbms/admin/sqlsessend.sql
   

   Once the connect privilege is granted, connect as the relevant user such as, SYSTEM and verify if the privilege is granted using the following query:

   COLUMN host FORMAT A30
   SELECT host, lower_port, upper_port, privilege, status FROM user_network_acl_privileges;
   

   For more information, see How To Set Network ACLs.

9. If you want to create an online migration, check the Use online replication option to enable the replication of all data and metadata transactions from the source to the target database, committed after the initial load has begun. For additional optional configurations, see the Replication tab in the Show advanced options. Optionally, you can set some additional properties which can affect the performance of your online migration.

   Note
   
   Oracle recommends using the default Use online replication option to perform an online replication.
   Note
   
   Skip this step for offline (Data Pump only) migrations.

10. Optionally, select Show Advanced Options to configure advanced Data Pump, validation, and Oracle GoldenGate settings.

    For details about these settings see Selecting objects for Oracle Migration, Configuring initial load advanced options for Oracle migrations, Configuring Validation Options, and Configuring optional replication advanced options.

11. Click Create.

    The migration is loaded, and a new Migration Details page opens showing the information, metrics, and operations for the migration.

    The status of the creation operation is shown under the DM icon. When the status is Active, you can run migration jobs with the migration.

A migration resource is a definition of your migration containing all settings and parameters that are eventually used when performing a migration.

The following procedure explains how to migrate data from a MySQL source database to a MySQL target database, which contain the settings for running migration jobs with Database Migration. You can create multiple migration resources with different parameter settings to test different scenarios.

Creating a Migration

1. Log in to the Console as a user with permissions to access Database Migration.

2. Open the navigation menu. Under Database Migrations click Migrations. A list of the migration resources in the currently selected compartment is displayed.

3. Click Create migration.

   This opens the Create migration wizard.

4. In the General information step, configure the following settings, then click Next.

   • Name: Enter a unique name for the migration.

     On completion of the Create Migration wizard, the name you enter here is displayed in the list of migrations on the Migrations page.

   • Add an optional Description: for the migration resource.

   • Compartment: Select the compartment in which the Database Migration service is hosted.

5. The Show advanced options section allows you to optionally create tags.

6. In the Select databases step, enter the following information, then click Next.

   Select the Source database.

   Select the Target database.

   Note
   
   Currently, MySQL Heatwave service is supported as the target database. For a list of supported databases, see Creating MySQL connections.

7. In the Migration options step, select the Object storage bucket in compartment: transfer medium for initial load option.

   If the bucket is in a different compartment, click Change Compartment to look in another compartment.

8. If you want to create an online migration, check the Use online replication option to enable the replication of all data and metadata transactions from the source to the target database, committed after the initial load has begun. For additional optional configurations, see the Replication tab in the Show advanced options. Optionally, you can set some additional properties which can affect the performance of your online migration.
   Note
   
   Currently, for MySQL to MySQL migrations, Oracle Cloud Infrastructure Database Migration supports GoldenGate Service Integration for replication.
   Note
   
   Skip this step for offline migrations.

9. Optionally, select Show Advanced Options to configure advanced replication, validation, and Oracle GoldenGate settings.

   For details about these settings see Selecting objects for MySQL migration, Configuring initial load advanced options for MySQL migrations, Configuring Validation Options, and Configuring optional replication advanced options.

10. Click Create.

    The migration is loaded, and a new Migration Details page opens showing the information, metrics, and operations for the migration.

    The status of the creation operation is shown under the DM icon. When the status is Active, you can run migration jobs with the migration.

To configure CPAT settings:

When you are creating a migration you can configure CPAT settings in the Migration resource Advanced Settings, Validation tab.

Run CPAT during validation: Enables CPAT to run during a migration validation job, in the Validate Pre-migration Advisor phase

Continue CPAT validation on error: By default, a validation job stops running when CPAT finds an issue. When checked, if CPAT finds an error, the CPAT validation will continue to its conclusion.

This setting is useful if you want to proceed with a migration if error conditions have already been reviewed and the problematic objects have been excluded, because since CPAT does not review the exclusions list, it will still report any blocking issues on objects even if they are excluded.

These settings can be changed after the migration is created. See Editing a Migration.

See Cloud Premigration Advisor Tool Support in the Zero Downtime Migration documentation for more information about CPAT.

In Oracle Cloud Infrastructure Database Migration, for online migrations using Oracle GoldenGate, you can configure some Oracle GoldenGate performance settings in the Migration resource Advanced Settings, Replication tab.

• Acceptable lag (in seconds) specifies the amount of lag. The lag is the time taken to extract or apply the data from the time it was created on the source database. This parameter specifies the amount of lag, in seconds, that triggers Oracle GoldenGate end-to-end latency monitoring. Monitoring continues until the lag time is lower than the specified value. The maximum value is 30 seconds, and the minimum is 2 seconds. The default value is 30 seconds.

• Extraction settings

  • Performance profile Sets the Oracle GoldenGate PERFORMANCEPROFILE parameter. Valid for GoldenGate Extract in Integrated Capture mode.

    • HIGH (default) for high volume use cases
    • MEDIUM
    • LOW RES to minimize resource usage for memory or resource constrained deployment

    This setting helps achieve better performance by tuning the group of Oracle GoldenGate parameters that affect performance. Once the performance profile is set up, this option automatically configures the relevant parameters to achieve the desired throughput and latency.

  • Transaction maximum duration specifies the length of time, in seconds, that a transaction can be open before Extract generates a warning message that the transaction is long-running. You can remove the value from this field if you don't want these error messages generated.

• Replication settings

  • Performance profile simplifies the Replicat performance.
    • Use HIGH when you have no concurrent workload on target. When HIGH is set, set Replicat Mappers to 5 and Appliers to 2 * PDB CPU_COUNT .
    • Use LOW when you have a concurrent workload on target. When LOW is set, set Replicat Mappers to 4 and Appliers to PDB CPU_COUNT / 2 on Target system.
• Advanced parameters lets you specify the advanced parameters for Replication settings for online migrations.

  While creating migration, select a list of parameters for migration. Select the Parameter name and Parameter value from the list. Click + Another parameter to add the parameters.

  For more information, see Zero Downtime Migration Logical Migration Response File Parameters Reference .
  Note
  
  This option is currently applicable for Oracle to Oracle migrations only.
• GoldenGate instance(Optional) Use Marketplace GoldenGate instance: Select this option if you want to perform replication using your own Marketplace GoldenGate instance provisioned by you in your tenancy.
  Note
  
  Currently, the support for the Use Marketplace GoldenGate instance option is limited to Oracle to Oracle online migrations.
  Note
  
  Oracle recommends using the Use online replication default option. Select the Use Marketplace GoldenGate instance option only when you want to use your own Marketplace GoldenGate compute instance.
  Enter the following details:
  • GoldenGate instance OCID: The instance ID of the compute that is hosting the Marketplace GoldenGate.
  • GoldenGate hub URL: Enter a URL containing only the public host name or IP address of your Marketplace GoldenGate instance.
  • GoldenGate administrator username: Enter the user name for connecting to your Marketplace GoldenGate instance.
  • GoldenGate administrator password: Enter the password for connecting to your Marketplace GoldenGate instance.
  Note
  
  You must use Marketplace as the default name for your GoldenGate deployment.

Excluded Objects

The Excluded objects list displays objects that are excluded from migration.

Oracle Maintained: objects owned by Oracle-maintained users (ORACLE_MAINTAINED = Y) are excluded from migration

Unsupported: objects not supported for migration by Oracle GoldenGate, such as those owned by the ggadmin and c##ggadmin users, are excluded from migration

User Excluded: objects explicitly excluded by rules configured in your migration Selected Objects.

See Selecting objects for Oracle Migration for details about objects excluded by default and explicitly selecting objects for migration.

Work Requests

On the Migration Details page, under the migration information box you can find the Work Requests list. Work Requests lists any work requests sent to OCI to facilitate the creation, update, validation, cloning, or deletion of this resource. Click the work request to go to the Work Request Details page for more information about the work request.

Source Database

In the Edit Source Database dialog, you can choose a different source database.

Valid selection of source databases is the same as for when you create a new migration resource; Non-autonomous non-CDBs or PDB/CDB combinations are supported for the source.

Target Database

In the Edit Target Database dialog, you can choose a different target database.

Valid selection of target databases is the same as for when you create a new migration resource; Autonomous Databases are supported for the target.

Migration Type

The Migration Type (Offline or Online) cannot be changed, but you can change the settings that are valid for the migration type originally configured.

In the Edit Initial Load Settings dialog, you can choose to change the following settings.

• Initial Load: You can change the data transfer method to use Object Storage bucket or database link.

• Object Storage Bucket: When your initial load data transfer method is Object Storage, you can change the bucket in which to store the Data Pump dumps.

• Export Directory Object: When your initial load data transfer method is Object Storage, you can change the export directory object by specifying a new name and path.

• Advanced Options: You can change the initial load advanced options. See Configuring initial load advanced options for Oracle migrations for information about these settings.

Replication

In the Edit replication settings dialog, you can enable or disable online replication, and you can change the following GoldenGate settings.

• Use online replication: Select this option if you want to enable the replication of all data and metadata transactions from the source to the target database committed after the initial load.
• Acceptable lag (in seconds)
• Extraction settings
• Replication settings
• GoldenGate instance:
  • (Optional). Use Marketplace GoldenGate instance: If you select this option, then enter the following details:
  • GoldenGate instance OCID: The instance ID of the compute that is hosting the Marketplace GoldenGate.
  • GoldenGate hub URL
  • GoldenGate administrator username
  • GoldenGate administrator password
• See Configuring optional replication advanced options for information about these settings.

Encryption Key

In the Edit Encryption Key dialog, you can choose a different Vault, Encryption Key, and the compartment in which to create a Secret.

Validation

In the Edit Validation Settings dialog, you can enable or disable the use of Cloud Pre-Migration Advisor Tool (CPAT) during migration validation, and you can change whether CPAT validation continues on error.

Selected Objects

You can add or remove Include or Exclude database object rules in the Resources section, under Selected Objects, which is located below the Migration Information box.

To remove a rule, select the rule's checkbox and click Remove, or select the Remove action from the actions list.

To add or edit rules, click Add Objects. See Selecting objects for Oracle Migration for information about configuring selected objects.

You can move a migration resource from one compartment to another.

To move a migration:

After you move the migration to the new compartment, inherent policies apply immediately and may affect access to the migration through the Console. For more information, see Managing Compartments.