1. Replication Guide
  2. Administering an Active Standby Pair With Cache Groups
  3. Recovering From the Failure of a Subscriber Database

Recovering From the Failure of a Subscriber Database

There are a couple of methods you can use to recover from the failure of a subscriber database.

  • Connect to the failed subscriber. This triggers recovery from the local transaction logs. Start the replication agent and let the subscriber catch up.

  • Duplicate the subscriber from the standby database. You can use either the ttRepAdmin -duplicate utility or the ttRepDuplicateEx C function to duplicate a database. Use the -noKeepCG command line option with ttRepAdmin in order to convert the cache group to normal TimesTen tables on the subscriber.

If the standby database is down or in recovery, then duplicate the subscriber from the active database.

After the subscriber database has been recovered, then set up the replication agent policy and start the replication agent. See Starting and Stopping the Replication Agents.