To verify the Mirror Replication Agent REPLICATING state
Enter:
resume go
If the Mirror Replication Agent successfully transfers to a REPLICATING state, the following result is returned:
State Action ------------------------------------- REPLICATING Ready to replicate data.
A returned state of ADMIN indicates that an error prevented the REPLICATING state from being achieved. To determine the error, review the contents of the Mirror Replication Agent system log.
The ra_status command returns the state of the Mirror Replication Agent. It is good practice to verify that the Mirror Replication Agent remains in REPLICATING state, even after the resume command executes successfully.
To detect an error that occurred after replication start-up, execute:
ra_status go
If the Mirror Replication Agent is in REPLICATING state, ra_status returns:
State Action ------------ ------------------------- REPLICATING Ready to replicate data.
A returned state of ADMIN indicates that an error prevented the REPLICATING state from being achieved. To determine the error, review the contents of the Mirror Replication Agent system log.
Validate that both primary and standby connections are active:
isql -Usa -P -SSAMPLE_RS admin who go
Be aware that:
The DSI connection for the primary database connection is usually down because you are not replicating data back to the primary database.
The Mirror Replication Agent connection, if established for the standby database connection, is usually down, because you are not replicating data from the standby database.
The following is displayed:
Spid Name State Info
---- --------- ---------------- --------------------------------------
14 DSI EXEC Awaiting Command 101(1) SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
10 DSI Awaiting Message 101 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
9 SQM Awaiting Message 101:0 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
19 DSI EXEC Awaiting Command 102(1) my_standby_mssql_service.standby
18 DSI Awaiting Message 102 my_standby_mssql_service.standby_db
17 SQM Awaiting Message 102:0 my_standby_mssql_service.standby_
11 dSUB Sleeping
6 dCM Awaiting Message
7 dAIO Awaiting Message
12 dREC Sleeping dREC
21 USER Active sa
5 dALARM Awaiting Wakeup
13 dSYSAM Sleeping
