Upgrading TimesTen

There is a separate process for upgrading to a new release of TimesTen.

Offline Upgrades for TimesTen

In TimesTen, offline upgrades are performed either by using the ttInstanceModify or the ttMigrate utilities.

Offline upgrades can be used to:

  • Apply a patch set or a patch level within a patch set, run the ttInstanceModify utility to upgrade the instance and its databases.

  • Move to a different major release, you must run ttMigrate to export the database to a flat file and then use ttMigrate again to import the data into the new database.

During an offline upgrade, the database is not available to applications. Offline upgrades usually require enough space on the file system for an extra copy of the upgraded database.

See Upgrades in TimesTen Classic in the Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide.

Online Upgrades for TimesTen

In TimesTen, replication enables online upgrades, while the database and its applications remain operational and available to users. Online upgrades are useful for applications where continuous availability of the database is critical.

Upgrading a database to a new release is performed by disconnecting all applications from one of two replicated copies of a database, making a backup of the database with the ttMigrate utility from the older release, loading the backup into a newer release database using the ttMigrate utility from the newer release, and then reconnecting all applications to the database in the upgraded instance.

See Upgrades in TimesTen Classic in the Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide.