Tracking VBR Invocations

Posted June 28, 2019 by Jim Knicely, Vertica Principal Solution Architect

Compass rose with true north pointing to "Helpful Tips" text
The Vertica Backup and Recovery tool (vbr) allows you to back up and restore either the full database, or one or more schema and table objects of interest. You can also copy a cluster and list backups you created previously. You can view vbr invocations by querying the DC_VBR_INVOCATIONS data collector table!

Example:
dbadmin=> SELECT DISTINCT component, description
dbadmin->   FROM data_collector
dbadmin->  WHERE table_name = 'dc_vbr_invocations';
   component    |                                                description
----------------+------------------------------------------------------------------------------------------------------------
VbrInvocations  | Monitoring Vbr invocations such as full backup, object backup/restore, object replication and copy cluster
(1 row)

dbadmin=> SELECT * FROM dc_vbr_invocations;
time | node_name | task_name | log_file | identifier | status
-----+-----------+-----------+----------+------------+--------
(0 rows)

dbadmin=> \q

[dbadmin@SE-Sandbox-26-node1 ~]$ vbr -t backup -c backup_restore_full_external.ini
Starting backup of database test_db.
Participating nodes: v_test_db_node0001, v_test_db_node0002, v_test_db_node0003.
Snapshotting database.
Snapshot complete.
Approximate bytes to copy: 38076300334 of 38076300334 total.
[==================================================] 100%
Copying backup metadata.
Finalizing backup.
Backup complete!

[dbadmin@SE-Sandbox-26-node1 ~]$ vsql
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

dbadmin=> \x
Expanded display is on.

dbadmin=> SELECT * FROM dc_vbr_invocations;
-[ RECORD 1 ]-------------------------------------------
time       | 2019-06-27 14:11:22.5663-04
node_name  | v_test_db_node0003
task_name  | Full Backup Task
log_file   | /tmp/vbr/vbr_2019-06-27-141119_15IUQPBV.log
identifier | ENESW7JO2HSLOJOP437GPHMW9DQP29ZA
status     | Start
-[ RECORD 2 ]-------------------------------------------
time       | 2019-06-27 14:24:08.670319-04
node_name  | v_test_db_node0003
task_name  | Full Backup Task
log_file   | /tmp/vbr/vbr_2019-06-27-141119_15IUQPBV.log
identifier | ENESW7JO2HSLOJOP437GPHMW9DQP29ZA
status     | Complete

Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/VBRUtilityReference.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ViewingBackups.htm Have fun!