VBR Utility Reference

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.

Most tasks cannot run concurrently; however, replication tasks can run concurrently with each other and with backups. Concurrent tasks must not use the same snapshot name.

The utility is located in the Vertica binary directory (/opt/vertica/bin/vbr on most installations).

Syntax

/opt/vertica/bin/vbr { command }  
... [ --archive timestamp ] 
... [ --config-file file ]
... [ --debug level]
... [ --nodes node1   [,   noden, ...] ] 
... [ --showconfig ]

Where command is one of the following:

Full Command Short Command Description
--help -h

Shows a brief usage guide for the command.
--showconfig   Displays the current configuration settings. 
--task {backup
| 7.2_upgrade
| collect-garbage
| copycluster							
| full-check
| init
| listbackup 
| quick-check
| quick-repair
| remove
| replicate
| restore }
-t

Performs the specified task:

  • 7.2_upgrade — Upgrades an existing 7.1 or earlier backup to the manifest-based backup introduced in version 7.2.
  • backup — Creates a full database or object-level backup, depending on configuration file specification.
  • collect-garbage — Rebuilds the backup manifest and deletes any unreferenced objects in the backup location.
  • copycluster — Copies the database to another Vertica cluster.
  • full-check — Verifies all objects listed in the backup manifest against file system metadata, outputting missing and unreferenced objects.
  • init — Creates a new backup directory, or prepares an existing one, for use and creates necessary backup manifests. You must perform this task before the first time you create a backup in a directory.
  • listbackup — Displays the existing backups associated with the configuration file you supply. View this display to get the name of a backup that you want to restore.
  • quick-check Confirms that all backed-up objects appear in the backup manifest. Outputs any discrepancies between objects in the backup location and objects listed in the backup manifest.
  • quick-repair — Builds a replacement backup manifest, based on storage locations and objects.
  • remove — Removes the specified backup or restore point.
  • replicate— Copies objects from one cluster to an alternate cluster. This task can run concurrently with backup and other replicate tasks.
  • restore — Restores a full or object-level database backup. Requires the configuration file that created the backup.

Parameters

Parameter Description 
--archive timestamp

Used with the --task restore and --task remove commands. Specifies the timestamp of the backup to restore or remove:

> vbr --task restore --config-file myconfig.ini --archive=20160115_182640 

-c file
--config-file file

Indicates the configuration file to use as an absolute or relative path to the location from which you start the backup utility. If no file exists, an error occurs and the utility cannot continue. 

--nodes node1[,...]

Specifies any nodes, in a comma-separated list, on which to perform a vbr task. The nodes listed match the names in the Mapping section of the configuration file.

Caution: Do not try to restore the entire database cluster from a partial database backup created from a subset of the nodes. Data loss could result. 

--debug level

Specifies the level of debugging messages (from 0 to 3) that the vbr utility provides. Level 3 indicates verbose, while level 0, the default, indicates no messages. 

--report-file path/filename
 Optional. Outputs a delimited JSON file that describes the results of the associated full backup integrity check or garbage collection task. 
--restore-objects objects
 Specifies the individual objects to restore from a full or object-level backup. If you are using wildcards, use --include-objects and --exclude-objects instead. 
--s3-force-init
 Used with the --task init command. Forces the init task to succeed on S3 storage targets when there is an identity/lock file mismatch. 
--showconfig

The configuration values being used to perform the task, displayed in raw JSON format before vbr starts begins.

 
--list-all
 Used with the --task listbackup command. Displays a list of all backups stored on the hosts and paths listed in the specified configuration file. 
--json
 Used with the --task listbackup command. Displays a JSON delimited list of all backups stored on the hosts and paths listed in the specified configuration file. 
--list-output-file path/filename
 Used with the --task listbackup command. Outputs a file containing a JSON delimited list of all backups stored on the hosts and paths listed in the specified configuration file. 
--dry-run
 Used with the --task command for backup, restore and replicate tasks. Performs a test run of the specified command without actually performing the task. You can use this command to evaluate the impact of a particular vbr command without actually performing that command. For example, you could see the size of a potential backup, or the objects contained in that backup. Any task performed with the dry-run parameter has no impact on your database. 
--include-objects

Used with the --task command to identify specific database objects and wildcard patterns to include with a restore task. Use a comma to delimit multiple objects and wildcard patterns. For more information, refer to Using Wildcards with Backup, Restore, and Replicate. Do not use this parameter with the --restore-objects parameter

 
--exclude-objects

Used with the --task command to identify specific database objects and wildcard patterns to exclude from a restore task. Use a comma to delimit multiple objects and wildcard patterns. For more information, refer to Using Wildcards with Backup, Restore, and Replicate.

See Also

Related Tasks