ASE : Sybase HA failback procedure

below are the steps used to failback Sybase HA server from secondary node to primary node.

-check if failed node has rebooted cleanly(no hardware/OS errors)

-check companion status of Secondary server via sp_companion command. sp_companion should give the companion state as “Secondary Failover”

-To have current primary host release data devices and prepare for failback, exec sp_companion “”, “prepare_failback”

-During the failback /opt/VRTSvcs/bin/hagrp -state should give the value change as
ONLINE->ONLINE/STOPPING->OFFLINE or OFFLINE->PARTIAL/STARTING->ONLINE
- Once the switch is completed, check the companion state on both Sybase servers, node0 should be “Primary failback”, node1 should be “Secondary failback”

- go to the primary server, issue sp_companion , resume
This will initiate recovery on database failback

- sp_companion , do_advisory, “all”

-Verify companion state on both servers
sp_companion should show “Primary Normal” on node0 and “Secondary Normal” on node1