OceanBase SQL语句BACKUP

描述

该语句用来触发备份。有关 OceanBase 数据库的备份与恢复相关的操作，请参见《OceanBase 数据库管理员指南》中的 备份恢复管理 章节。

该语句仅支持在 sys 租户执行。

语法

alter_system_backup_stmt:
    ALTER SYSTEM backup_action;

backup_action:
      SET BACKUP_DEST = 'backup_url' 
    | SET BACKUP_BACKUP_DEST = 'backup_backup_url'
    | ARCHIVELOG | NOARCHIVELOG
    | BACKUP DATABASE | BACKUP ARCHIVELOG
    | BACKUP BACKUPPIECE ALL NOT BACKED UP n TIMES [tenant_identifier] [BACKUP_BACKUP_DEST='url']
    | BACKUP BACKUPPIECE [= n] [tenant_identifier] [BACKUP_BACKUP_DEST='url'] [WITH ACTIVE BACKUPPIECE]
    | BACKUP BACKUPSET ALL NOT BACKED UP n TIMES [tenant_identifier] [BACKUP_BACKUP_DEST='url']
    | BACKUP BACKUPSET = n [tenant_identifier] [BACKUP_BACKUP_DEST='url']
    | CANCEL BACKUP [BACKUPSET | BACKUPPIECE]
    | {START | STOP} BACKUP ARCHIVELOG
    | BACKUP TENANT tenant_name_list TO backup_destination
   

tenant_identifier:
     TENANT_ID = tenant_id | TENANT_NAME = 'name'

tenant_name_list：
      tenant_name [, tenant_name ...]

参数解释

示例

• 设置备份的路径。

  obclient> ALTER SYSTEM SET backup_dest='oss://antsys-oceanbasebackup/backup_dir?host=xxx&access_id=xxx&access_key=xxx';
  obclient> ALTER SYSTEM SET backup_dest='file:///data/nfs/physical_backup_dir';
  

• 备份备份的日志。

  obclient> ALTER SYSTEM BACKUP BACKUPPIECE ALL NOT BACKED UP 2 TIMES BACKUP_BACKUP_DEST= 'file:///ob_backup_backup/ob_cluster_1_backup_piece_20200125';
  obclient> ALTER SYSTEM BACKUP BACKUPPIECE 1 TENANT_NAME tenant_1 BACKUP_BACKUP_DEST= 'file:///ob_backup_backup/ob_cluster_1_backup_piece_20200225';
  

• 租户级别备份。

  obclient> ALTER SYSTEM BACKUP TENANT tenant1,tenant2 TO "file:///ob_backup/";