Tracking VBR Invocations

Jim_Knicely

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=> SELECT * FROM dc_vbr_invocations;
             time              |     node_name      |    task_name     |                  log_file                   |            identifier            |  status
-------------------------------+--------------------+------------------+---------------------------------------------+----------------------------------+----------
2019-06-27 14:11:22.5663-04    | v_test_db_node0003 | Full Backup Task | /tmp/vbr/vbr_2019-06-27-141119_15IUQPBV.log | ENESW7JO2HSLOJOP437GPHMW9DQP29ZA | Start
2019-06-27 14:24:08.670319-04  | v_test_db_node0003 | Full Backup Task | /tmp/vbr/vbr_2019-06-27-141119_15IUQPBV.log | ENESW7JO2HSLOJOP437GPHMW9DQP29ZA | Complete
(2 rows)

Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/VBRUtilityReference.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ViewingBackups.htm

Have fun!