Skip to main content
Question

How to check correctness of restore archive specification

  • February 17, 2021
  • 1 reply
  • 4 views

joergschaber
Forum|alt.badge.img+2

Hi,
we tried to backup/restore a database instance and ran into errors during restore:
Restoring from restore point: backup_snapshot_20210216_133917
Error: Failed to get snapshot metadata files from backup location. If you specified an archive to restore, please check the correctness of the archive specification. Otherwise run backup validation task.

We conducted following steps according to specifications:
1. We ran a backup an exisiting database that resided in a docker container (vbr -t init -c vbr.ini; vbr -t backup -c vbr.ini)
2. We produced a tarball of the resulting backup-directory.
3. We copied and extracted the tarball on the target server, where a database was already created.
4. We ran the restore command (vbr -t restore -c restore_full.ini)
From the error message something with the archive is wrong. How can we check its correctness?
Thanks,
Jordi

1 reply

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • February 18, 2021

You can validate and possibly repair a backup using the "quick-check" and "quick-repair" tools, e.g.:

vbr -t quick-check -c restore_full.ini

The "full-check" tool may produce more detailed messages. Please see the full documentation at https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/VBRUtilityReference.htm
If you continue to have issues, please open a ticket if you can, or share the full vbr log file with option "--debug 3" to print verbose logs.