ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Can you delete a vertica archive?

book

Article ID: 16211

calendar_today

Updated On:

Products

CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration

Issue/Introduction



Can you delete a vertica archive if you are low on disk space?

df -h 

Filesystem Size Used Avail Use% Mounted on 

/dev/sdb1 493G 6.8G 461G 2% /catalog 

/dev/sdc1 493G 413G 55G 89% /data 

/dev/sdd1 493G 464G 3.2G 100% /backup

 

drwxr-xr-x 5 dradmin verticadba 4096 Oct 25 09:19 . 

drwxr-xr-x 4 dradmin verticadba 4096 Oct 22 18:45 .. 

drwxrwx--- 4 dradmin verticadba 4096 Oct 25 06:38 PROD_snapshot 

drwxrwx--- 4 dradmin verticadba 4096 Oct 23 19:58 PROD_snapshot_archive20171023_194627 

drwxr-xr-x 2 dradmin verticadba 4096 Oct 25 09:19 .PROD_snapshot.done 

 

du -csh * 

414G PROD_snapshot 

51G PROD_snapshot_archive20171023_194627 

464G total 

Environment

CAPM 3.x

Resolution

(i) Yes, it is okay to remove the archive provided you have the latest FULL back up archive available for your restore operation. If you saved multiple backups, you can specify a specific archive to restore. To list the archives that exist to choose one to restore, use the vbr --listbackup task, with a specific configuration file. 

 

(ii) Running the vbr utility with the --task backup command deletes the oldest backup. This command run whenever the total number that exist exceeds the restorePointLimit value in the configuration file. Suppose the restorePointLimit = 5, and five archives exist. In this case, running the vbr --task backup utility again deletes the backup with the oldest date_timestamp, when vbr completes the current backup command. 

 

(iii) Removing Backups: When you use the vbr task, remove, Vertica updates the manifests affected by the removal and maintains their integrity. If the backup archive contains multiple restore points, removing one does not affect the others. When you remove the last restore point, Vertica removes the backup entirely. 

Additional Information

Here are additional details on removing the backup archive:

https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/RemovingBackups.htm