Oracle Cloud Infrastructure Documentation

Viewing migration details

On the Migrations page of Oracle Cloud Infrastructure Database Migration service console, you can view a list of your migrations in a table, which includes the following information:

  • Name

  • State of the migration resource, which can be any one of the following:

    • Creating: The new migration resource is being created in OCI.

    • Updating: Changes to the migration resource are being registered in OCI.

    • Active: The migration resource has finished being created or updated and is ready for validation. A migration resource in this state can be validated but cannot run a migration job.

    • In Progress: A validation job or migration job is currently running on this migration resource.

    • Accepted: The migration resource has been validated and can run another validation job or a migration job.

    • Succeeded: A migration job using this resource has completed successfully. Once a migration resource has reached this state, jobs can no longer be run with it.

    • Canceled: A migration job using this resource was canceled. You can run a new job on a migration resource in this state.

    • Waiting: A migration job using this resource is waiting for user input. This state appears when a migration job is paused.

    • Needs Attention: A validation job or migration job using this resource has failed and is blocked. Note that you must cancel a job before you can rerun it.

    • Inactive: A fallback state for unexpected errors.

    • Deleting: This state appears when you delete a migration resource. The resource remains in this state until deletion is completed, at which point the resource is no longer listed in the console.

    • Failed: There are problems with the migration resource. This can happen during creation, update, and any issues other than job failures. You can review the migration resource work request to investigate the issue.

  • Last Migration shows the time stamp of the last job run with the migration

  • Created time stamp when the migration was created

Select a migration from the Migrations page to view its details.

Viewing migration details: On the Migration Details page you can view the migration information, including:

  • OCID: The resource's unique Oracle Cloud ID
  • Compartment: The compartment where the migration resource resides
  • Created: The date and time when the migration was created
  • Encryption Vault: The link takes you to the Vault Details page
  • Encryption Key: The link takes you to the Key Details page
  • Source Database: The link takes you to the Database Details page. You can select Test connection to test the connectivity of the database connection.
  • Target Database: The link takes you to the Database Details page. You can select Test connection to test the connectivity of the database connection.
  • Migration Type: Online or Offline
  • Replication: Enabled or Disabled
  • Validation: Premigration advisor Enabled or Premigration advisor Disabled
  • Database type

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.

Related Topics

Parent topic: Manage migrations