Check the Mirror Replication Agent status

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

No replication takes place when the Mirror Replication Agent instance is in Admin state. See “Understanding Mirror Replication Agent states”.

Checking the current Mirror Replication Agent status

Log in to the Mirror Replication Agent instance with the administrator login.
Use the following command to check the current status of the Mirror Replication Agent:
```
ra_status
```
This command returns the current state of the Mirror Replication Agent instance, as shown in the following example:
```
State  Action
------ ----------------------------
ADMIN  Waiting for operator command
(1 row affected)
```

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

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

If...	Then...
The Mirror Replication Agent instance is in Replicating (Waiting at end of log) state.	Examine the statistics output to check the progress of the replication process. See “Use the ra_statistics command to troubleshoot” for more information.
The Mirror Replication Agent instance is Replicating state. When the Mirror Replication Agent instance is in the Replicating state, all data may not have yet been replicated. You can only be sure that the Mirror Replication Agent instance is finished replicating when the state is Replicating (Waiting at end of log).	The instance is operating normally, but it has not reached the end of the transaction log. Wait until Mirror Replication Agent instance is in Replicating (Waiting at end of log) state. Then repeat the procedure on page §.
The Mirror Replication Agent instance is in Admin state.	Start replication and put the Mirror Replication Agent instance in Replicating state by executing the Mirror Replication Agent resume command. See “Starting replication in the Mirror Replication Agent” for more information. If the Mirror 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. See “Examine the Mirror Replication Agent logs” for more information.

If...

Then...

The Mirror Replication Agent instance is in Replicating (Waiting at end of log) state.

Examine the statistics output to check the progress of the replication process. See “Use the ra_statistics command to troubleshoot” for more information.

The Mirror Replication Agent instance is Replicating state.

When the Mirror Replication Agent instance is in the Replicating state, all data may not have yet been replicated. You can only be sure that the Mirror Replication Agent instance is finished replicating when the state is Replicating (Waiting at end of log).

The instance is operating normally, but it has not reached the end of the transaction log. Wait until Mirror Replication Agent instance is in Replicating (Waiting at end of log) state. Then repeat the procedure on page §.

The Mirror Replication Agent instance is in Admin state.

Start replication and put the Mirror Replication Agent instance in Replicating state by executing the Mirror Replication Agent resume command. See “Starting replication in the Mirror Replication Agent” for more information.

If the Mirror 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. See “Examine the Mirror Replication Agent logs” for more information.