Oracle Audio Technologies B31679-01 manual Oracle TimesTen In-Memory Database Installation Guide

the steps outlined in “Moving between 32-bit and 64-bit data stores” on page 101.

If you need to upgrade two or more data stores that are replicating to each other, you must perform a few extra steps in order to ensure that replication will continue to operate during and after the upgrade. For example, to migrate two replicating data stores, master1 on host machine masterhost and subscriber1 on host machine subscriberhost, from TimesTen release 5.1 to TimesTen release 7.0, perform the following steps:

1.Configure the replication scheme on both data stores to use static TCP/ IP ports for replication. This is necessary because the intermediate result of these steps is that replication occurs between two different versions of TimesTen, and each version will not necessarily know how to find the main daemon of the other in order to have the replication ports assigned dynamically. See "Dynamic vs. static port assignments" in the TimesTen to TimesTen Replication Guide for more information.

2.On the machine masterhost, use the 5.1 release’s ttAdmin utility to stop the replication daemon on the data store:

ttAdmin -repStop master1

3.Next, use the 5.1 release’s ttMigrate utility with the -coption to back up data store master1 to a binary file:

ttMigrate -c DSN=master1 master1.bak

4.Use the 5.1 release’s ttDestroy utility to destroy data store master1, where the data store’s files are located in the directory data_store_path:

ttDestroy /data_store_path/master1

5.Use the 7.0 release’s ttMigrate utility with the -roption to restore data store master1 from the binary file. Restoring the data store automatically upgrades it from release 5.1 to release 7.0. If you are restoring a very large data store, you should use the -Coption to tell ttMigrate to perform a checkpoint operation on the data store periodically. This saves time if the restore fails at some point before the operation has been completed. For more information, see "Checkpoints" in the Oracle TimesTen In-Memory Database Operations Guide.

ttMigrate -r -C 20 DSN=master1 master1.bak

6.Use the 7.0 release’s ttAdmin utility to start the replication daemon: ttAdmin -repStart master1

Replication is now occurring between the data store master1 on release 7.0 and the data store subscriber1 on release 5.1.

102 Oracle TimesTen In-Memory Database Installation Guide