Checking the Current Replication Agent Status

The status of the Replication Agent instance indicates whether it is in Replicating state or in Admin state.

No replication takes place when the Replication Agent instance is in Admin state.

  1. Log in to the Replication Agent instance with the administrator login.
  2. Get the current status of the Replication Agent instance:
    ra_status
    This command returns the current state of the Replication Agent instance and any current activity, for example:
    State  Action
    ------ ----------------------------
    ADMIN  Waiting for operator command
    (1 row affected)

See the Replication Agent Reference Manual for more information about the ra_status command.

When the Replication Agent instance is in one of these states, take the suggested actions.

State

Action

Admin

Start replication and put the Replication Agent instance in Replicating state by executing the Replication Agent resume command.

If the Replication Agent instance returns to Admin state after you invoke the resume command, there is at least one unresolved problem that prevents the instance from going to Replicating state.

Replicating

No action is required. The instance is operating normally.

Replicating (Resynchronization)

No action is required. The instance is in the process of resynchronizing the primary and replicate databases. When resynchronization completes, the Replication Agent instance automatically transitions to the Replicating state.

Replication Down

Replication has stopped due to an error. Examine the Replication Agent error log to diagnose and fix the error. Then, resume the Replication Agent instance.

Related concepts
Replication Agent Instance Availability Monitoring
Primary Database Log Access
Replication Agent Logs
Available Memory
Skipped DDL Commands
JVM Thread Dump
Replication Agent States
Related tasks
Verifying that a Primary Database Object Is Marked for Replication
Using ra_statistics to Check Replication Agent Operations and Performance
Debugging LTL
Starting Replication