OceanBase数据库

一起看海

原理介绍：

https://www.oceanbase.com/docs/e ... n-10000000000355061

OceanBase 数据库物理备份的架构如下图所示





备份示例：

https://www.oceanbase.com/docs/e ... n-10000000000357859

# 发起全量备份

obclient> ALTER SYSTEM BACKUP DATABASE;

# 发起增量备份

obclient> ALTER SYSTEM BACKUP INCREMENTAL DATABASE;


恢复示例：

https://www.oceanbase.com/docs/e ... n-10000000000355919

# 全量恢复

obclient> ALTER SYSTEM RESTORE <dest_tenant_name> FROM <source_tenant_name> at 'uri' UNTIL 'timestamp' WITH 'restore_option';

# 表级别恢复

obclient> ALTER SYSTEM RESTORE <table_name_list> FOR <dest_tenant_name>  FROM <source_tenant_name> AT 'uri'  UNTIL 'timestamp' WITH 'restore_option' ;
obclient> ALTER SYSTEM RESTORE `crm`.`sales`, `crm`.`products`, `hr`.`employees` FOR new_tenant1 FROM tenant1 AT 'oss://antsys-oceanbasebackup/backup_rd/?host=cn-hangzhou-alipay-b.oss-cdn.aliyun-inc.com&access_id=xxx&access_key=xxx' UNTIL '2021-02-28 08:59:45' WITH 'backup_cluster_name=ob20daily.backup&backup_cluster_id=1&pool_list=restore_pool';

# 查看正在备份的任务

obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_PROGRESS;

# 查看备份任务的历史

obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_SET_FILES;