We are doing vertica backups to a remote host.
We are concerned about network issues affected file integrity.
How can we verify that our backups are good?
How to check the state of DX NetOps Performance Management Data Repository Vertica DB backups created using the vbr.py script.
All supported DX NetOps Performance Management releases
Tips for vbr.py success:
If we generate the --help usage we'll see these options.
--task { backup | restore | copycluster |
replicate | listbackup | init |
quick-check | full-check | quick-repair |
collect-garbage | remove }
Using that we can generate these commands to check the DB backup states.
Samples from a support team lab for the check options. Yours will be similar but different.
This is the quick-check run:
[dradmin@DR DB Node bin]$ ./vbr.py --task quick-check --config-file /export/dradmin/vertica_local_backup.ini
Checking backup consistency.
List all snapshots in backup location:
Snapshot name and restore point: backup_snapshot_20240828_020004, nodes:['v_drdata_node0001'].
Snapshot name and restore point: backup_snapshot_20240829_020004, nodes:['v_drdata_node0001'].
Backup consistency check complete.
This is the full-check run:
[dradmin@DR DB Node bin]$ ./vbr.py --task full-check --config-file /export/dradmin/vertica_local_backup.ini
Checking backup consistency.
List all snapshots in backup location:
Snapshot name and restore point: backup_snapshot_20240828_020004, nodes:['v_drdata_node0001'].
Snapshot name and restore point: backup_snapshot_20240829_020004, nodes:['v_drdata_node0001'].
Regenerating backup manifest for location [##.##.##.##]:/database/backups
Snapshots that have missing objects(hint: use 'vbr --task remove' to delete these snapshots):
Backup locations have 0 unreferenced objects
Backup locations have 0 missing objects
Backup consistency check complete.