Restore a Database from a Hard-Link Backup

  1. Create EBS volumes from your backup snapshots.
    Note: Before you attach your new volumes, stop and detach any existing RAID volumes mounted to the target cluster.
  2. Attach the new EBS volumes to their respective nodes and volumes on the target cluster.
    Important: You must use the correct device mapping. For example, a backup snapshot taken for node 1, volume /dev/xvdf must be re-created in the new cluster at node 1, volume /dev/xvdf.
  3. Rebuild your RAID-0 device by restoring your RAID configuration file:
    /etc/mdadm.conf
  4. When the volumes have finished attaching, remount the RAID:
    for IP in 10.0.10.13 10.0.10.14 10.0.10.15; do ssh $IP sudo mount /vertica/data ;
  5. Create an empty database on the target cluster with the same dbadmin username, password, datapath, and database name as your source database.
  6. Run a restore operation:
    /opt/vertica/bin/vbr --config-file vmart_backup.ini --task restore