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.

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.
--setupconfig

 

Asks a series of questions and generates a configuration file. 

--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.
  • 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. 
--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. For more information, refer to Creating Backups on Amazon S3. 
--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.

See Also

Related Tasks