Editing a migration

You can modify some of the settings in a migration resource configuration in Oracle Cloud Infrastructure Database Migration.

In the list of migrations on the Migrations page, select the Name of the migration you want to edit.

Select Edit next to any of the following modifiable settings:

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, file storage, or database link.

• Job mode:

  • Full: performs a full database export.

  • Schema (default) lets you specify a set of schemas to export.

• 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. Enter the Source Data Pump settings and Target Data Pump settings if applicable.

• 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. SeeConfiguring 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

• SeeConfiguring 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 Pre-Migration Advisor Tool during migration validation, and you can change whether Pre-Migration Advisor 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.