Full Backup Restore to an Alternate Cluster

Vertica supports restoring a full backup to an alternate cluster.

Requirements for Restoring to an Alternate Cluster

The process is similar to the process for Restoring Full Database Backups, with the following additional requirements.

The destination database must:

Restore a Full Backup to an Alternate Cluster

  1. Copy the vbr configuration file that you used to create the backup to any node on the destination cluster.
  2. If you are using a stored password, copy the password configuration file to the same location as the vbr configuration file.
  3. From the destination node, issue a vbr restore command, such as:
    vbr -t restore -c full.ini
  4. After the restore has completed, start the restored database.