Skip to end of metadata
Go to start of metadata

先决条件

  1. 确保执行了vbr init 及相关配置 051-配置远程备份主机和连接
  2. 数据库是运行状态。对于K-safe设置的数据库来说，并不要求所有节点都是在线状态。但是，离线状态的节点不会被备份
  3. 所有的备份主机是启动且可用状态
  4. 备份主机有充足的空间
  5. 启动vbr的用户具有目标目录的写入权限。（不能是root）
  6. 每个备份都有唯一的文件名
  7. 如果需要保留更长时间的备份，设置restorePointLimit参数（vbr init文件中）

执行备份

  • Full backup

    $  vbr -t backup -c /opt/vertica/share/vbr/example_configs/full_backup_cf.ini
Starting backup of database vdb.
Participating nodes: v_vdb_node0001.
Snapshotting database.
Snapshot complete.
Approximate bytes to copy: 0 of 764489983 total.
Copying backup metadata.
Finalizing backup.
\[==================================================\] 100%
Deleting old restore points.
Backup complete!
\\

  • Object-Level backup

    $ vbr -t backup -c /opt/vertica/share/vbr/example_configs/object_backup_cf.ini
Warning: The following keys have been specified multiple times. => objects
Starting backup of database vdb.
Participating nodes: v_vdb_node0001.
Objects: \['cities'\]
Snapshotting database.
Snapshot complete.
Approximate bytes to copy: 0 of 129552744 total.
Copying backup metadata.
Finalizing backup.
\[==================================================\] 100%
Backup complete!
\\
\\
\\





  • No labels