vertica-备份

配置备份文件，在这里直接配即可，没必要生成

[ dbadmin@T4 ~]$ vi snapshot01.ini

[Misc]

snapshotName = snapshot01

restorePointLimit =  1

objectRestoreMode = createOrReplace

passwordFile = pwd

[Database]

dbName = VMartDB

dbUser = dbadmin

dbPassword = fafa123

[Transmission]

[Mapping]

v_vmartdb_node0001 = 172.16.57.57:/home/dbadmin/backup

[ dbadmin@T4 ~]$  vbr.py --task init  --config-file snapshot01.ini

Initializing backup locations.

Backup locations initialized.

7.2版本特有，需要初始化

[ dbadmin@T4 ~]$  vbr.py --task backup --config-file snapshot01.ini

Starting backup of database VMartDB.

Participating nodes: v_vmartdb_node0001.

Snapshotting database.

Snapshot complete.

Approximate bytes to copy: 590441285 of 590441285 total.

[==================================================] 100%

Copying backup metadata.

Finalizing backup.

Backup complete!

备份在指定路径下生成 Snapshots的文件夹，他的多少和restorePointLimit ，参数有关，vertica会对里面的文件进行循环覆盖，这个大家可以测一测，vertica没有和oracle一样的全备增量被概念

[ dbadmin@T4 Snapshots]$ pwd

/home/dbadmin/backup/Snapshots

[ dbadmin@T4 Snapshots]$ ls

snapshot01_20160422_021600  snapshot01_20160422_021628