How to check correctness of restore archive specification
joergschaber
Vertica Customer ✭
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
Answers
You can validate and possibly repair a backup using the "quick-check" and "quick-repair" tools, e.g.:
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.