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 |
---|---|
|
Name of the database to export. |
|
Name of the repository where the export will be stored. |
|
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, anddbExport
cannot run concurrently withdbImport
. -
For disk space requirements, see Exporting and Importing a Database in Oracle TimesTen In-Memory Database Scaleout User's Guide.