Backing Up and Restoring an Encrypted Database

TimesTen supports back up and restore operations for encrypted databases.

A backup file for an encrypted database includes the wallet with the master key required to decrypt the data from the checkpoint and transaction log files stored in the backup file. This is to avoid issues of a mismatching master key in a restore operation due to any rekey operations performed after the backup.

The master key and data encryption keys (DEKs) stored in a database backup are from the time the backup was created, and they may have already expired—based on the security policies established by your organization—once the backup is used for a restore operation. Given this, as best practice, it is highly recommended that you perform a rekey operation after restoring an encrypted database. See Re-Keying an Encrypted Database

For more information on how to either back up or restore a database, see Backing Up and Restoring a Database in Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide.