ON Source:
sp_ctrl>Stop export
Â
ON Failover:
1. Shutdown shareplex
sp_ctrl> shutdown - do not shutdown force
Â
2. Run the prodir/bin cleanup.sql script as the splex user in SQLPLUS to cleanup the shareplex internal tables:
SQL> @ cleanup.sql
Â
3. Go to qview and delete the capture, export(s) queues only. DO NOT DELETE THE POST QUEUE.
Â
qview -i
qview> qsetup <port>
qview> deleteq c
qview> deleteq x
NOTE: If using multiple export queues, repeat for each export queue
qview> exit
Â
4. touch the statusdb file located in vardir/data ( i.e. this file should be empty 0 bytes)
Â
ON SOURCE:
1. shutdown shareplex
sp_ctrl> shutdown
Â
2. Delete the post queue on SOURCE
qview -i
qview> qsetup <port>
qview> deleteq p
NOTE: If using multiple post queue, delete the correct one and repeat for each one if necessary.
qview > exit
Â
3. Login to SQLPLUS as the splex user and truncate the shareplex_trans table
SQL> truncate table shareplex_trans
Â
4. Start sp_cop on both sides
Â
ON Failover:
1. Start sp_cop
Â
2. stop the export - sp_ctrl>stop export
Â
3. Activate reverse config
sp_ctrl> activate config <name>
Â
4. Verify export is stopped (after activation is complete)
Â
After the activation is finished, you can go back to the Online server (Source) and start export on source.
