Restoring a Database Using an Archive

It is not possible to restore into a running database. The process documented here creates a new database.

On occasion, it may be desirable to start a database using an existing database archive (database on disk), for example:

  • When migrating a database where nuoagent had been used for domain and database management to an environment where NuoDB Admin (nuoadmin) is the default admin service.

  • When restoring a database archive from a backup copy.

To restore an existing database archive for a specific host, use the nuocmd create archive command with the --restored option.

nuocmd create archive --db-name <database name> --server-id <server ID> --archive-path /var/opt/nuodb/production-archives/<database name> --restored

The archive must be physically present on the host specified using --server-id.

For example, to restore an archive identified for the test database that physically resides on the host running the server1 Admin Process, run the following command:

nuocmd create archive --db-name test --server-id server1  --archive-path /var/opt/nuodb/production-archives/test --restored

The --restored option specifies that the archive being created already contains data, and that an SM started on it does not require the --initialize option. The test database can then be started by running the following commands:

nuocmd create database --db-name test --dba-user test --dba-password test
nuocmd start process --db-name test --engine-type TE --server-id server1
For more information on nuocmd and other command line tools, see Command Line Tools.