Online Defragmentation of TimesTen Databases in an Active Standby Pair Replication Scheme
If you have an active standby pair replication scheme, you can use
ttMigrate -relaxedUpgrade and ttRepAdmin -duplicate
utilities to minimize overall service downtime when defragmenting the databases. Use a
combination of the ttMigrate -relaxedUpgrade and ttRepAdmin
-duplicate utilities to defragment TimesTen databases that are involved in a
replication scheme where TABLE DEFINITION CHECKING is set to
RELAXED. In addition, the ttMigrate -relaxedUpgrade
option condenses table partitions.
Note:
If your TimesTen database uses an active standby pair replication scheme, then you
can only defragment these databases if the active standby pair replication scheme
either does not contain any cache groups or contains only READONLY
cache groups.
The example in this section shows how to perform an online defragmentation
with an active standby pair replication scheme where the active database is
ttdb1 and the standby database is ttdb2.
Note:
The examples provided in each section assume that you are familiar with the configuration and management of replication schemes. See Getting Started in the Oracle TimesTen In-Memory Database Replication Guide.
The following sections describe how to defragment TimesTen databases that are involved in an active standby pair replication scheme: