Restoring Hard-Link Local Backups
Before attempting a hard-link local backup, you must be aware of issues around restoring from this type of backup, whether full or object level.
Process for Restoring Full and Object-Level Hard Link Local Backups
If you have created both full and object-level backups and the database fails, restore the backups in this order:
- Restore the full database backup.
- Restore from any object-level backups.
Transferring Backups to and from Remote Storage
When a full hard-link local backup exists, you can use a utility (other than vbr
) to transfer the backup to another storage media, such as tape. Transferring hard-link local backups to another storage media may copy the data files associated with the hard file links.
You can use a different directory when you return the backup files to the hard-link local backup host. However, you must also change the backupDir
parameter value in the configuration file before restoring the backup.
Complete the following steps to restore hard link local backups from external media:
-
If the original backup directory no longer exists on one or more local backup host nodes, re-create the directory.
The directory structure into which you restore hard link backup files must be identical to what existed when the backup was created. For example, if you created hard-link local backups at the following backup directory, you can then re-create that directory structure:/home/dbadmin/backups/localbak
-
Copy the backup files to their original backup directory, as specified for each node in the configuration file. For more information, refer to [Mapping].
-
Restore the backup, using one of three options:
- To restore the latest version of the backup, move the backup files to the following directory:
/home/dbadmin/backups/localbak/node_name/snapshotname
-
To restore a different backup version, move the backup files to this directory:
/home/dbadmin/backups/localbak/node_name/snapshotname_archivedate_timestamp
- To restore the latest version of the backup, move the backup files to the following directory:
-
When the backup files are returned to their original backup directory, use the original configuration file to invoke
vbr
as follows:>/opt/vertica/bin/vbr --task restore --config-file localbak.ini
- Confirm that the backup has succeeded. Verify that:
- The physical files are restored from tape into the correct directories.
- You are using the configuration file that specifies
hardLinkLocal = true
.
Note: You can use a different directory when you return the backup files to the hard-link local backup host. However, you must also change the backupDir
parameter value in the configuration file before restoring the backup.