Vertica backup

book

Article ID: 145379

calendar_today

Updated On:

Products

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

Issue/Introduction

"Prepare to Install the Data Repository" guide:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/performance-management/3-7/installing/prepare-to-install-the-data-repository.html

Cause

Some customers has doubts in start the Vertica backup

Environment

PM Release : 3.7

Resolution

Here are the backup example:

[[email protected] example_configs]# ls -al /opt/vertica/config/password.txt
-rw------- 1 dradmin verticadba 33 Feb 18 14:09 /opt/vertica/config/password.txt
[[email protected] example_configs]#

[[email protected] example_configs]# cat /opt/vertica/config/password.txt
[Passwords]
dbPassword = dbpass
[[email protected]_configs]#


backup_restore_full_local.ini file:
v_drdata_node0001 = []:/export/dradmin/backups
snapshotName = backup_snapshot
dbName = drdata
tempDir = /tmp/vbr
restorePointLimit = 1
passwordFile = /opt/vertica/config/password.txt
dbUser = dradmin


Commands:
[[email protected] /] $ /opt/vertica/bin/vbr.py --task init --config-file /opt/vertica/share/vbr/example_configs/backup_restore_full_local.ini
Initializing backup locations.
Backup locations initialized.

[[email protected] /] $ /opt/vertica/bin/vbr.py --task backup --config-file /opt/vertica/share/vbr/example_configs/backup_restore_full_local.ini
Starting backup of database drdata.
Participating nodes: v_drdata_node0001.
Snapshotting database.
Snapshot complete.
Approximate bytes to copy: 11925616224 of 11925616224 total.
[==================================================] 100%
Copying backup metadata.
Finalizing backup.
Backup complete!
[[email protected] /]$


Results:
[[email protected] example_configs]# ls -al /export/dradmin/backups/
total 904
drwxr-xr-x 4 dradmin verticadba 88 Feb 18 14:14 .
drwx------ 7 dradmin verticadba 176 Feb 18 13:33 ..
-rw-r--r-- 1 dradmin verticadba 886605 Feb 18 14:14 backup_manifest
-rw-r--r-- 1 dradmin verticadba 2 Feb 18 14:12 .index
-rw------- 1 dradmin verticadba 63 Feb 18 14:12 .lock
drwxr-xr-x 502 dradmin verticadba 12288 Feb 18 14:14 Objects
drwxr-xr-x 3 dradmin verticadba 45 Feb 18 14:14 Snapshots
[[email protected] example_configs]#