Oracle Audio Technologies B31679-01 manual Performing an offline upgrade

Performing an offline upgrade

You can do an offline upgrade by exporting the data store into an external file using either the ttMigrate or ttBackup utility, then restoring the data store with the desired changes. These update procedures require that all applications be disconnected from the data store and that the data store be unloaded from shared memory. For applications that require continuous availability, see “Performing an online upgrade with replication” on page 104.

Note: If the data store to be upgraded is replicated, you must use ttMigrate to move the data store between versions. In addition if you rename table owners using the ttMigrate -r-renameoption, you need to also rename the table owners in every other data store involved in the replication scheme.

When exporting a TimesTen data store, you can use either the ttMigrate or ttBackup utility. The ttMigrate utility exports the data store in a release-neutral format that is more flexible, while the ttBackup utility exports an image copy of the data store and is faster. The ttBackup utility may be used if you wish to move the data store to a different machine or directory. The ttMigrate utility must be used if you wish to:

•move to a new major or patch release of TimesTen.

•reduce data store size.

•move between 32-bit and 64-bit data stores.

The general steps in an offline upgrade include:

•Disconnect all applications from the data store and unload the data store from memory. (See “Unloading a data store” on page 95.)

•Use either ttMigrate with the -cand -noRepUpgradeoptions or ttBackup to back up the data store.

•Install the new release of TimesTen. (See Chapter 2, “TimesTen Installation.”)

•Use either ttMigrate with the -rand -noRepUpgradeoptions or ttRestore to restore the backed up data store to the new TimesTen release.

•Reconnect applications to the upgraded data store.

Data Store Upgrades 97