如何对OceanBase数据库进行备份和恢复之三.pdf
免费下载
382 > 第 5 章：运维 OceanBase 数据库
发起全量备份
发起全量备份之前，您可设置备份密码（这一步是可选的）。设置密码是会话级别设置，不设
置即为空。
MySQL [oceanbase]> set encryption on identified by 'bakBAK123456' only;
Query OK, 0 rows affected (0.225 sec)
全量备份发起命令是 alter system backup database。如果事务日志备份已经开始，那必须等
事务日志备份成功之后才可发起全量备份，否则命令会报错。
alter system backup database;
MySQL [oceanbase]> alter system backup database;
ERROR 9040 (HY000): backup can not start, because log archive is not doing. log arc
hive status : BEGINNING.
此外，重新开始全量备份之前距离事务日志备份开始之后需要进行一次合并，否则命令也会报
错。
MySQL [oceanbase]> alter system backup database;
ERROR 9040 (HY000): backup can not start, because log archive start timestamp is b
igger than frozen timestamp, need major freeze first. start timestamp : 163506932295
1942, frozen timestamp : 1635064748441948 .
查看全量备份任务先看视图 CDB_OB_BACKUP_PROGRESS。
SELECT incarnation, tenant_id, backup_type, bs_key, partition_count, start_time, com
pletion_time, status
FROM CDB_OB_BACKUP_PROGRESS;
383 > 第 5 章：运维 OceanBase 数据库
输出：
+-------------+-----------+-------------+--------+-----------------+----------------------------+----------------------
------+---------+
| incarnation | tenant_id | backup_type | bs_key | partition_count | start_time
| completion_time | status |
+-------------+-----------+-------------+--------+-----------------+----------------------------+----------------------
------+---------+
| 1 | 1 | D | 6 | 0 | 2021-10-24 16:56:
02.682700 | 2021-10-24 16:56:14.035231 | RUNNING |
| 1 | 1001 | D | 6 | 220 | 2021-10-24 16:5
6:02.682700 | 2021-10-24 16:56:12.510089 | RUNNING |
+-------------+-----------+-------------+--------+-----------------+----------------------------+----------------------
------+---------+
2 rows in set (0.456 sec)
如果该视图有记录，表示有全量备份任务在进行。如果视图为空，则表示没有全量备份任务或
者全量备份任务已经结束。可以查看备份历史记录视图 CDB_OB_BACKUP_SET_DETAILS。
select incarnation, tenant_id, bs_key , backup_type, encryption_mode, start_time, co
mpletion_time, elapsed_secondes , keep, output_bytes_display, output_rate_bytes_d
isplay, status
from CDB_OB_BACKUP_SET_DETAILS
order by start_time desc limit 10;
输出：
+-------------+-----------+--------+-------------+-----------------+----------------------------+----------------------
------+------------------+------+----------------------+---------------------------+-----------+
| incarnation | tenant_id | bs_key | backup_type | encryption_mode | start_time
| completion_time | elapsed_secondes | keep | output_bytes_
of 5
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论