Oracle Cloud Infrastructure Documentation

Viewing the Replication Channel Status

The channel status is a summary, indicating channel health, whether all received transactions are applied or not, and the lag of the transaction applied with respect to the immediate source of the channel.

This information can be helpful in assessing whether the source and target are ready for a successful failover or switchover.

Use the following methods to view the channel status:

Using the Console

Use the Console to view the channel status.

  1. On the Channels list page, find the channel that you want to work with. If you need help finding the list page or the channel, see Listing Channels - Using the Console.
    The details page opens and displays information about the channel.
  2. To generate the channel status if it is not already generated, click Generate in the Channel status section. In the Generate channel status pane that appears, click Generate to continue.
    The channel status generation work request is created. After the channel status generation work request completes, the Channel status section displays the date and time the channel's runtime status was last updated, the work request state, and errors related to the work request, if any.
    Note

    The generated status expires after 12 hours, after which you need to generate the channel status again. The channel status shown is a point-in-time snapshot. To view the latest information, you must regenerate the channel status.
  3. To regenerate the channel status, select Regenerate from the Actions menu (three dots) in the Channel status section. In the Generate channel status pane that appears, click Generate to continue.
    The channel status generation work request is created. The channel status is updated after the work request completes.
    Note

    If the last generated status has not expired, the regenerate request overwrites it.
  4. To view the last generated channel status, select View details from the Actions menu (three dot) in the Channel status section.
    The channel status is displayed in the Channel status pane.

Channel Status

Use the Channel status pane to view the status of a channel.

Table 13-7 Channels status

Field Description
Status Information
  • Last update: Date and time the status was last generated.
  • Work request state: Whether the status generation work request was successful.
Channel Information
  • Healthy: Indicates if the channel is healthy or not. If healthy, replication target DB system is connected to the source and no replication errors are seen.
  • Received GTID set applied: Indicates if all transactions received by this channel are executed and if their GTIDs are part of the GTID executed set.
  • Lag duration: The channel lag, with respect to the immediate source of the channel. If the channel is configured with replication delay, the channel lag includes the replication delay.
  • Errors: Identified channel errors, if any.