
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!