Returns the current state of the Mirror Replication Agent instance.
ra_status
When ra_status is invoked, it returns the current state of the Mirror 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 Mirror Replication Agent instance
is in transition between states. Some commands are not valid when
the Mirror Replication Agent instance is in state transition.
Mirror Replication Agent states are:
Admin – in this state, the Mirror Replication Agent instance is running, but no connections are up. You can change any configuration parameter when the Mirror Replication Agent instance is in Admin state.
Replicating – in this state, the Mirror Replication Agent 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 (Waiting at end of log) – in this state, the Mirror Replication Agent Log Reader component has reached the end of the transaction log, and the Mirror Replication Agent has finished processing all operations in the transaction log and successfully sent LTL commands for all replicated operations to the Replication Server.
If the primary database is not quiesced or otherwise inactive, transactions may arrive in the log immediately after the state is returned by the Log Transfer Manager component, so even though the state is returned as Replicating (Waiting at end of log), the Mirror Replication Agent may actually be in Replicating state and processing log records.
See “Mirror Replication Agent states” for more information.
The ra_status command is valid when the Mirror Replication Agent instance is in either Admin or Replicating state.
pdb_init, pdb_quiesce, quiesce, ra_init, ra_statistics, resume, shutdown, suspend
