Online Defragmentation of TimesTen Databases in a Non Active Standby Pair Replication Scheme

This section explains how to perform an online defragmentation with bidirectional and unidirectional replication schemes with two TimesTen databases. In bidirectional replication schemes, each database is both a master and a subscriber. In unidirectional replication schemes, one database acts as the master, and the other as the subscriber.

Use a combination of the ttMigrate -relaxedUpgrade and ttRepAdmin -duplicate utilities to defragment TimesTen databases (to minimize overall service downtime) 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:

The examples provided in each section assume that you are familiar with the configuration and management of replication schemes. For more information, see Getting Started in the Oracle TimesTen In-Memory Database Replication Guide.

For the unidirectional replication example, ttdb1 represents the master and ttdb2 represents the subscriber.

The following sections describe how to defragment TimesTen databases that are involved in a non active standby pair replication scheme:

• Migrate and Rebuild a Database

• Alter the Replication Scheme

• Destroy and Re-Create a Database