|
原理介绍:
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;
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|