Resuming the Mirror Replication Agent instance
The resume command puts the Mirror Replication Agent in a REPLICATING state, reading the ASE active log and sending commands to Replication Server.
To place the Mirror Replication Agent in a REPLICATING state, enter the resume command:
resume
go
If the Mirror Replication Agent successfully transfers to a REPLICATING state, this result is returned:
State Action
----------------------------------- -------------------------
REPLICATING (WAITING AT END OF LOG) Ready to replicate data.
If the state returned is ADMIN, an error prevented the REPLICATING state from being achieved. To determine the error, review the contents of the Mirror Replication Agent instance log. Also, see the Mirror Activator Administration Guide.
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 the ra_status command:
ra_status
go
If the Mirror Replication Agent is in REPLICATING state, this result is returned:
State Action
----------------------------------- -------------------------
REPLICATING (WAITING AT END OF LOG) Ready to replicate data.
If the state returned is ADMIN, an error prevented the REPLICATING state from being achieved. To determine the error, review the contents of the Mirror Replication Agent instance log. Also, see the Mirror Activator Administration Guide.
Exit from the isql session.
To validate that both primary and standby connections are active, issue the following commands:
isql -Usa -P -SSAMPLE_RS
admin who
go
You should not proceed until admin who has a status for threads similar to this:
Spid Name State Info
---- --------- ---------------- --------------------------------------
30 DSI EXEC Awaiting Command 101(1) SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
22 DSI Awaiting Message 101 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
18 SQM Awaiting Message 101:0 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
47 DSI EXEC Awaiting Command 102(1) repit152i2.foo2
23 DSI Awaiting Message 102 repit152i2.foo2
19 SQM Awaiting Message 102:0 repit152i2.foo2
46 DSI EXEC Awaiting Command 103(1) repit152i.foo
24 DSI Awaiting Message 103 repit152i.foo
26 DIST Awaiting Wakeup 103 repit152i.foo
29 SQT Awaiting Wakeup 103:1 DIST repit152i.foo
21 SQM Awaiting Message 103:1 repit152i.foo
20 SQM Awaiting Message 103:0 repit152i.foo
53 REP AGENT Awaiting Command repit152i.f00
25 dSUB Sleeping
15 dCM Awaiting Message
17 dAIO Awaiting Message
27 dREC Sleeping dREC
54 USER Active sa
14 dALARM Awaiting Wakeup
28 dSYSAM Sleeping
