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: CPAT Enabled or CPAT Disabled
Creating Notifications: On the Migration details page, you can create rules to get notified about changes to your migrations based on events or metrics. You can create notifications by following either of the two ways:
  • Create notifications using the provided templates:
    • Select the hyperlink to open the template.
    • Alternatively, select from the quickstart templates to create notifications.
  • If you click the template selection Menu, you can select the hyperlink, or in the Create notifications template selection option, select a template. The following options are available:
    • Evaluation or Migration job status has changed
    • Evaluation or Migration job completed successfully
    • Evaluation or Migration job failed to complete
    • Migration job went into a waiting state
    • A phase completed for an Evaluation or Migration job
    • Replication latency exceeds 5 seconds

    The rules that trigger notifications can be created using service events or metrics.

  • If you want to create your own templates, you can select Advanced event notifications or Advanced alarm notifications based on the metrics you want to be alerted on.
You can create notifications based on the following options:
  • Quickstarts notifications
  • Advanced event notification
  • Advanced alarm notification
To configure Quickstarts notifications, follows the steps:
  1. Select a template from Template selection.
  2. In Event rule, enter the Rule name.
  3. In Topic and subscriptions,
    1. In the Create new topic , select the compartment that you want to create the topic in and enter a user-friendly name for the topic. The topic you created appears in the list of the Topics. Alternatively, you can Select existing topic.
    2. In the Subscription panel:
      1. Set Subscription protocol for email, Slack, or SMS notification:
        • Email:
          1. Set Protocol to Email.
          2. Enter the email address that should receive the notifications.
        • Slack:
          1. Set Protocol to Slack.
          2. For URL, enter the URL for your Slack Webhook.
        • SMS:
          1. Set the Country.
          2. Set the Phone number.
        In Show advanced options Specify tag information for one or more tag namespaces.

        Click Another tag to specify tag information for another tag namespace.

      When you receive the subscription confirmation email, click the Confirm Subscription link in the body of the message.

      An Oracle Cloud Infrastructure page appears in your browser, indicating that your subscription is confirmed.

  4. Click Create Notifications.
To configure Advanced event notification, follows the steps:
  1. In Event rule, enter the Rule name.
  2. Select the Event type for which you want to be notified.
  3. In Topic and subscriptions,
    1. In the Create new topic , select the compartment that you want to create the topic in and enter a user-friendly name for the topic. The topic you created appears in the list of the Topics. Alternatively, you can Select existing topic.
    2. In the Subscription panel:
      1. Set Subscription protocol for email, Slack, or SMS notification:
        • Email:
          1. Set Protocol to Email.
          2. Enter the email address that should receive the notifications.
        • Slack:
          1. Set Protocol to Slack.
          2. For URL, enter the URL for your Slack Webhook.
        • SMS:
          1. Set the Country.
          2. Set the Phone number.
        • HTTPS (custom URL): Set the URL.
        • PagerDuty: Set the Integration Key.
        • Function:
          1. Set the Function compartment.
          2. Set the Oracle Functions application.
          3. Set the Function.
        In Show advanced options specify tag information for one or more tag namespaces.

        Click Another tag to specify tag information for another tag namespace.

      When you receive the subscription confirmation email, click the Confirm Subscription link in the body of the message.

      An Oracle Cloud Infrastructure page appears in your browser, indicating that your subscription is confirmed.

  4. Click Create Notifications.
You can create alarms to notify you when metrics meet alarm-specified triggers. To configure Advanced alarm notification, follows the steps:
  1. In the Alarms pane, create a Alarm name. Enter a user-friendly name for the alarm. Avoid entering confidential information.
  2. In or Alarm severity, select the perceived type of response required when the alarm is in the firing state.
  3. In the Metric description area, enter values to specify the metric to evaluate for the alarm.
    • Metric name: Select the name of the metric that you want to evaluate for the alarm. You can select any OCI metric or custom metric if the data exists in the selected compartment and metric namespace.
    • Interval: Select the aggregation window, or the frequency at which the alarm needs to be triggered.
    • Statistic: Select the function to use to trigger the alarm.
      • Mean - The value of Sum divided by Count during the specified time period.
      • Rate - The per-interval average rate of change.
      • Sum - All values added together.
      • Max - The highest value observed during the specified time period.
      • Min - The lowest value observed during the specified time period.
      • Count - The number of observations received in the specified time period.
      • P50 - The value of the 50th percentile.
      • P90 - The value of the 90th percentile.
      • P95 - The value of the 95th percentile.
      • P99 - The value of the 99th percentile.
  4. In the Trigger rule area, specify the condition that must be satisfied for the alarm to be in the firing state. The condition can specify a threshold, such as 90% for CPU utilization, or an absence.
    • Operator: Select the operator to use in the condition threshold.
    • Value: Enter the value to use for the condition threshold. For the between and outside operators, enter both values for the range.
    • Trigger delay minutes: Enter the number of minutes that the condition must be maintained before the alarm is in the firing state.
  5. In Topic and subscriptions,
    1. In the Create new topic , select the compartment that you want to create the topic in and enter a user-friendly name for the topic. The topic you created appears in the list of the Topics. Alternatively, you can Select existing topic.
    2. In the Subscription panel:
      1. Set Subscription protocol for email, Slack, or SMS notification:
        • Email:
          1. Set Protocol to Email.
          2. Enter the email address that should receive the notifications.
        • Slack:
          1. Set Protocol to Slack.
          2. For URL, enter the URL for your Slack Webhook.
        • SMS:
          1. Set the Country.
          2. Set the Phone number.
        • HTTPS (custom URL): Set the URL.
        • PagerDuty: Set the Integration Key.
        • Function:
          1. Set the Function compartment.
          2. Set the Oracle Functions application.
          3. Set the Function.
      When you receive the subscription confirmation email, click the Confirm Subscription link in the body of the message.

      An Oracle Cloud Infrastructure page appears in your browser, indicating that your subscription is confirmed.

  6. In Show advanced options Specify:
    • Alarm body
    • Notifications:
      • Message format: Select an option for the appearance of messages that you receive from this alarm (for Notifications only).
        • Send formatted messages: Simplified, user-friendly layout. To view supported subscription protocols and message types for formatted messages (options other than Raw), see Friendly formatting.
        • Send Pretty JSON messages (raw text with line breaks): JSON with new lines and indents.
        • Send raw messages: Raw JSON blob.
      • Repeat notification: If you want to receive notifications at regular intervals when the alarm is firing. Specify the period of time to wait before resending the notification.
      • Suppress notification: To suppress evaluations and notifications for a specified length of time. Specify a start time, end time, and an optional description.
    • Tag information for one or more tag namespaces.
  7. Click Create Notifications.
You can view the created notifications in the Notifications tab. The following details are available:
  • Type
  • Name
  • Topic
  • Created
You can select the Actions (three dots) menu and perform the following tasks:
  • Edit
  • View tags
  • Add tags
  • Delete

Below the migration details, you can view information about resources associated with the migration, such as Jobs (see Manage jobs), Excluded Objects (see below), Work Requests (see below), and Metrics (see Metrics).

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