Restoring a Database Using an Archive

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

At times, it may be desirable to restore a database from a backup copy of the archive.

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.

The --dba-user and --dba-password options are required when creating a database. However, in the case of creating a database from an existing archive, their values are ignored and the DBA credentials from the archive will be used.