Manual Failover

From SybaseWiki
Revision as of 01:29, 21 May 2006 by 1148172799 (Talk | contribs)

Jump to: navigation, search

The failback procedure for an active-standby ASE setup (with OpenSwitch and optionally RCM) has been documented by Sybase but a manual failover not. This procedure is documented below. You can use it when you want to perform maintenance on the active database server and need to transfer connections in a controlled manner to the standby ASE. The procedure assumes you are using RCM.

  • Logon to OpenSwitch as the administrative user
  • Lock the active database server so new connections cannot be made: rp_server_status <active-ase>,locked
  • Stop sessions from invoking new transactions: rp_stop null,<active-ase>,null,1,1
  • Logon to the active ASE
  • Monitor the progress of the RepAgent until all transactions have been transfered to the Replication Server: sp_help_rep_agent <database>,"scan"
  • Kill the cmon user in ASE and do a shutdown: kill <cmon-user-spid> shutdown
  • Logon to OpenSwitch as the administrative user
  • Resume session activity: rp_start null,<active-ase>,null
  • Change the server-status to up: rp_server_status <active-ase>,up
  • Initiate a new session to the active ASE through OpenSwitch: isql -U<user> -P<password> -S<openswitch>. When you have done this RCM will see that the active ASE is down and it will start the failover process.

When you have used this procedure you can be sure that all connections are transfered without the need to logon again. Also, all transactions made on the active ASE are guaranteed to be delivered at the Replication Server.










[We are delicate. We do not delete your content.] [l_sp4]


waterford crystal swarovski crystal bead mesothelioma lawsuits mesothelioma symptoms mesothelioma diagnosis wacoal bras teen bra unsecured signature loan Countrywide Home Loans Formal Prom Dresses Sexy Prom Dress cocktail dresses TMobile water softener tankless water heater rockport shoes reverse osmosis water filter merrell shoes oscar dresses easter dresses flyfone voip plus size prom dresses discount prom dresses Hooters Casino Las Vegas grand casino mille lacs las vegas casino coupons online poker aide pechanga casino grand victoria casino ball gowns rtg casino bonus

rtg casino bonus grand casino coushatta grand casino hinckley isle of capri casino mohegan sun casino pala casino roulette wheels winstar casino Cheap Prom Dresses informal wedding dresses oscar dresses evening gowns