Error message 18750  Appendix A: Troubleshooting Secondary Points of Failure

Chapter 15: Configuring Adaptive Server for Failover on Windows NT

Recovering from a failed prepare_failback

During fail back, if prepare_failback was executed successfully on the secondary companion but the primary companion does not start, perform the following to roll back and then reissue the prepare_failback command:

  1. Check the primary companion’s system event log to find the reason the server does not start, and correct the problems.

  2. Check that the MSCS group that contains the resource for the primary server is located on the secondary node. If not, it does use Move Group to move it.

  3. Log in to the secondary companion and issue:

    dbcc ha_admin ("", "rollback_failback")
    dbcc ha_admin ("", "rollback_failover")
    
  4. Verify that the secondary companion is in normal companion mode.

  5. Check that the MSCS resource for the primary server is online. If it is not, manually bring the resource online using the Cluster Administrator.

  6. As “root,” start the package for the primary companion to run on secondary node.

    /usr/sbin/cmrunpkg -n <secondary_node> primary_companion_package_name
    

    Your secondary companion is now in failover mode. Once you verify that everything is ready for the primary companion to fail back to normal companion mode, you can either issue sp_companion...prepare_failback or use the Move Group option.





Copyright © 2005. Sybase Inc. All rights reserved. Appendix A: Troubleshooting Secondary Points of Failure

View this book as PDF