Backing Up and Restoring a TimesTen Classic Database with Cache Groups
TimesTen Classic databases containing cache groups can be backed up and restored with either the ttBackup
or ttMigrate
utilities.
-
If the restored database connects to the same backend Oracle database, then use the
ttBackup
andttRestore
utilities, then drop and recreate all cache groups in the restored TimesTen database. If they are static cache groups, you may be required to reload them. For dynamic cache groups, the reload is optional as data is pulled in from the Oracle database as it is referenced.Note:
If another TimesTen database is used to connect to the original backend Oracle database (and now no longer connects) and if all cache groups in the TimesTen database were not cleanly dropped, then run the
cacheCleanUp.sql
SQL*Plus script against the original Oracle database to remove all leftover objects. Specify the host and path for the original TimesTen database. -
If the restored database connects to a different backend Oracle database than what it had originally connected with, then perform one of the following: