1. Reference
  2. TimesTen Scaleout Utilities
  3. ttGridAdmin
  4. Backup and Restore Operations
  5. Restore a Database (dbRestore)

Restore a Database (dbRestore)

The dbRestore command restores a database backup into a new database. 

ttGridAdmin dbRestore dbname
                      -repository reponame
                      -name backupname

Options

The dbRestore command has the options:

Option Description

dbname

Name of the database to be created, then restored from the backup.

-repository reponame

Name of the repository where the backup is located.

-name backupname

Name of the backup to use for the restore.

Examples

This example creates and restores a database res_db1 from a backup mybkup. 

% ttGridAdmin dbRestore res_db1 -repository repo1 -name mybkup
dbRestore mybkup started

You can then use dbRestoreStatus to check progress, as shown in the example in Display the Status of a Database Restore (dbRestoreStatus). The restore is finished when each element and the database as a whole are indicated as complete.

Notes

  • This database must already be defined (with dbdefCreate) but not yet created.

  • The restore is performed asynchronously. Use the dbRestoreStatus command to check progress.

  • The restored database is loaded into memory when dbRestore completes, but not opened.

  • You can restore to the original database definition or to a newly created database definition.

  • You cannot restore to a database with fewer replica sets than what was backed up. (If the number of data instances on hosts in each data space group is not sufficient to support the number of replica sets in the database that was backed up, you must use dbExport and dbImport instead.)

  • If you restore to a database with more replica sets than what was backed up, only the number of replica sets that were backed up will be added to the database distribution map. For example, if you back up a database with two replica sets and restore to a database with four replica sets, only the elements in two replica sets will be added to the distribution map. You would then have to redistribute data with dbDistribute to get four replica sets.

  • For disk space requirements, see Backing Up and Restoring a Database in Oracle TimesTen In-Memory Database Scaleout User's Guide.