Returns the current state of the Replication Agent instance.
ra_status
When ra_status is invoked, it returns the current state of the Replication Agent instance, and a brief description of the current state, as follows:
State Action ------ ---------------------------- ADMIN Waiting for operator command (1 row affected)
If the first word in the description is “Transitioning,” the Replication Agent instance
is in transition between states. Some commands are not valid when
the Replication Agent instance is in state transition.
Replication Agent states are:
Admin – in this state, the Replication Agent instance is running, but no connections are up. You can change any configuration parameter when the Replication Agent instance is in Admin state.
Replicating – in this state, the Log Reader component is scanning the transaction log for operations to replicate from the primary database. If there are operations to be replicated, the Log Transfer Interface component is sending LTL commands to the Replication Server.
Replicating (Resynchronization) – in this state, Replication Agent has been restarted and is resynchronizing the primary and replicate databases.
Replication Down – in this state, replication has stopped due to an error. After the error has been resolved, Replication Agent may return to the Replicating state.
Replication Agent behavior in the Replication
Down state is the same as behavior in the Admin state,
the only difference between the two states being that the Replication
Down state is reached through a Replication Agent error.
See the Replication Agent Administration Guide for more information about Replication Agent states.
The ra_status command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.
