执行数据备份后,您可以查看备份进度。
通过视图查看数据备份进度
系统租户可以通过
oceanbase.CDB_OB_BACKUP_JOBS 视图和
oceanbase.CDB_OB_BACKUP_TASKS 视图查看数据备份的进度。
-
使用
root 用户登录到数据库的
sys 租户。
-
查看数据备份进度。
示例如下:
obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOBS\G
*************************** 1. row ***************************
TENANT_ID: 1
JOB_ID: 1
INCARNATION: 1
BACKUP_SET_ID: 0
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 1
EXECUTOR_TENANT_ID: 1002
PLUS_ARCHIVELOG: OFF
BACKUP_TYPE: D
JOB_LEVEL: CLUSTER
ENCRYPTION_MODE: NONE
PASSWD:
START_TIMESTAMP: 2022-06-01 17:10:23.975539
END_TIMESTAMP:
STATUS: DOING
RESULT: 0
COMMENT:
DESCRIPTION:
PATH:
*************************** 2. row ***************************
TENANT_ID: 1002
JOB_ID: 1
INCARNATION: 1
BACKUP_SET_ID: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 1
EXECUTOR_TENANT_ID: 1002
PLUS_ARCHIVELOG: OFF
BACKUP_TYPE: D
JOB_LEVEL: USER_TENANT
ENCRYPTION_MODE: NONE
PASSWD:
START_TIMESTAMP: 2022-06-01 17:10:24.046643
END_TIMESTAMP:
STATUS: DOING
RESULT: 0
COMMENT:
DESCRIPTION:
PATH: file:///data/nfs/backup/data
obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASKS\G
*************************** 1. row ***************************
TENANT_ID: 1002
TASK_ID: 1
JOB_ID: 1
INCARNATION: 1
BACKUP_SET_ID: 1
START_TIMESTAMP: 2022-06-01 17:10:24.046643
END_TIMESTAMP:
STATUS: BACKUP_DATA
START_SCN: 1658740213006643504
END_SCN: 0
USER_LS_START_SCN: 1658740229412297106
ENCRYPTION_MODE: NONE
PASSWD:
INPUT_BYTES: 0
OUTPUT_BYTES: 0
OUTPUT_RATE_BYTES: 0.0000
EXTRA_META_BYTES: 0
TABLET_COUNT: 0
FINISH_TABLET_COUNT: 0
MACRO_BLOCK_COUNT: 0
FINISH_MACRO_BLOCK_COUNT: 0
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 1
RESULT: 0
COMMENT:
PATH: file:///data/nfs/backup/data
上面的示例中,租户 ID 为
1002 的租户正在进行数据备份,其备份目的端为
file:///data/nfs/backup/data , 当前的数据备份状态为
DOING。
更多
CDB_OB_BACKUP_JOBS 和
CDB_OB_BACKUP_TASKS 视图的说明,请参见
CDB_OB_BACKUP_JOBS 和
CDB_OB_BACKUP_TASKS。
相关阅读
查看数据备份结果
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/70026124/viewspace-2932881/
,如需转载,请注明出处,否则将追究法律责任。