Tracking VBR Invocations
Jim_Knicely
- Select Field - Administrator
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!
0