1. Cache Guide
  2. Managing a Caching Environment
  3. Backing Up and Restoring a TimesTen Classic Database with Cache Groups

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 and ttRestore 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.

    See SQL*Plus Scripts for Cache.

  • If the restored database connects to a different backend Oracle database than what it had originally connected with, then perform one of the following: