Export a Database (dbExport)

The dbExport command exports data from the specified database into a specified repository. The dbExport and dbImport commands are used, for example, to migrate a database between two grids or between versions of TimesTen that are not patch-compatible. See Migrating, Backing Up and Restoring Data in Oracle TimesTen In-Memory Database Scaleout User's Guide for additional information.

ttGridAdmin dbExport dbname 
                     -repository reponame 
                     [-name exportname]

An export is stored as a collection under a repository. You first must create the repository. See Repository Operations.

Options

The dbExport command has the options:

Option	Description
dbname	Name of the database to export.
-repository reponame	Name of the repository where the export will be stored.
-name exportname	Specifies a name for the export. The default is the letter "M" followed by the date and time of the backup, in the format: Myyyymmddhhmmss

Examples

% ttGridAdmin dbExport database1 -repository repo1 -name exp_db1
...
dbExport exp_db1 started

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

Notes

• The export is performed asynchronously. Use the dbExportStatus command to check progress.

• Each replica set of the database is stored as a sub-collection.

• The database must be in a closed state with all connections closed when you run dbExport.

• Only one dbExport command can be run for a database at any given time, and dbExport cannot run concurrently with dbImport.

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