Tracking VBR Invocations

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

Designers discussing project in office sample library

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.htmhttps://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ViewingBackups.htm

Have fun!

About the Author

I’ve had the privilege of working with many database technologies in my career. But after being introduced to Vertica in May of 2011 as a client, I was hooked on the new technology after witnessing a query run in milliseconds that had previously ran for hours on the legacy database we had in place. It was then that I knew I wanted to eventually join the Vertica team, and 4 years later I did! I am currently a Vertica evangelist and am ready to help you get on board! Please feel free to reach out to me with any questions you have about Vertica and make sure to follow my Vertica Quick Tips!

Read More Posts From Jim
Connect With Jim on

Sponsored by Vertica

You may also like...