Destroy and Re-Create a New Standby

You can destroy and recreate a new standby by duplicating the new active with the ttRepAdmin -duplicate command.

During these steps, application processing can continue at the active database.

  1. Stop the cache agent on the new standby database:
    ttAdmin –cacheStop ttdb1
  2. As the cache manager user, drop all cache groups using ttIsql:
    DROP CACHE GROUP t_cg;
  3. Destroy the database:
    ttDestroy ttdb1
  4. Re-create the new standby database by duplicating the new active.
    ttRepAdmin -duplicate -from ttdb2 -host ttsrv2 –setMasterRepStart -UID 
    ttAdmin -PWD ttadminpwd -keepCG -cacheUID cacheadmin -cachePWD cadminpwd ttdb1
  5. Start cache and replication agents on the new standby ttdb1 database:
    ttAdmin –cacheStart ttdb1
    ttAdmin –repStart ttdb1

This process defragments both the active and standby databases with only a few seconds of service interruption.