Vertica Backup locations have missing objects

Products

• DX NetOps
• CA Performance Management - Usage and Administration

Issue/Introduction

I just checked our Backup integrity on our DR and the full-Check showed:

Backup locations have 0 unreferenced objects
Backup locations have 303831 missing objects
Backup consistency check complete.

A quick-repair did not fix it.

Is there a way to correct this other than resetting the Backup?

Environment

Any Performance Management release

Cause

corrupted backup

Resolution

full-check will provide you list of backups which are corrupted.

$ vbr -t full-check -c your_backup.ini

and once you identify these backups , you can remove using below command.

$ vbr -t remove -c configfile.ini --archive timestamp

$ vbr -t remove -c FullBkp.ini --archive 20240625_182354
Enter vertica password:
Removing restore points: 20240625_182354

Once all the corrupted backups are removed you can take a fresh backup using existing .ini file.

Additional Information

Backup may heal itself soon depending on your configuration.

 

restorePointLimit states how many max backups you can have at a given time. If it's 2 you can have max 3 backups and when new backup will run it will remove the oldest backup .

If you are taking backup daily it will removed backups which were possibly having missing files in previus days.