首批通过分布式安全可靠测评，为关键业务系统打造
查看数据备份结果
更新时间：2024-12-18 10:16:53
编辑
分享
数据备份执行完成后，您可以通过视图查看备份任务历史。
系统租户查看数据备份任务历史
使用
root用户登录集群的sys租户。查看数据备份历史。
查看 JOB 级任务历史
租户发起一次备份即对应一条 JOB 任务记录。
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOB_HISTORY\G查询结果如下：
*************************** 1. row *************************** TENANT_ID: 1002 JOB_ID: 1 INCARNATION: 1 BACKUP_SET_ID: 1 INITIATOR_TENANT_ID: 1002 INITIATOR_JOB_ID: 0 EXECUTOR_TENANT_ID: 1002 PLUS_ARCHIVELOG: OFF BACKUP_TYPE: FULL JOB_LEVEL: USER_TENANT ENCRYPTION_MODE: NONE PASSWD: START_TIMESTAMP: 2024-01-31 11:20:59.804836 END_TIMESTAMP: 2024-01-31 11:23:08.773566 STATUS: COMPLETED RESULT: 0 COMMENT: DESCRIPTION: PATH: file:///data/nfs/backup/data *************************** 2. row *************************** TENANT_ID: 1002 JOB_ID: 2 INCARNATION: 1 BACKUP_SET_ID: 2 INITIATOR_TENANT_ID: 1002 INITIATOR_JOB_ID: 0 EXECUTOR_TENANT_ID: 1002 PLUS_ARCHIVELOG: OFF BACKUP_TYPE: INC JOB_LEVEL: USER_TENANT ENCRYPTION_MODE: NONE PASSWD: START_TIMESTAMP: 2024-01-31 13:47:57.218929 END_TIMESTAMP: 2024-01-31 13:50:14.985358 STATUS: COMPLETED RESULT: 0 COMMENT: DESCRIPTION: PATH: file:///data/nfs/backup/data 2 rows in set查看 Task 级任务历史
一个 Task 对应一个备份集的任务。
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASK_HISTORY\G查询结果如下：
*************************** 1. row *************************** TENANT_ID: 1002 TASK_ID: 1 JOB_ID: 1 INCARNATION: 1 BACKUP_SET_ID: 1 START_TIMESTAMP: 2024-01-31 11:20:59.804836 END_TIMESTAMP: 2024-01-31 11:23:08.762451 STATUS: COMPLETED START_SCN: 1706671262627179000 END_SCN: 1706671388756316000 USER_LS_START_SCN: 1706671278153636000 ENCRYPTION_MODE: NONE PASSWD: INPUT_BYTES: 198130272 OUTPUT_BYTES: 16984419 OUTPUT_RATE_BYTES: 131705.4367 EXTRA_META_BYTES: 0 TABLET_COUNT: 617 FINISH_TABLET_COUNT: 617 MACRO_BLOCK_COUNT: 94 FINISH_MACRO_BLOCK_COUNT: 94 FILE_COUNT: 0 META_TURN_ID: 1 DATA_TURN_ID: 0 RESULT: 0 COMMENT: PATH: file:///data/nfs/backup/data MINOR_TURN_ID: 1 MAJOR_TURN_ID: 1 *************************** 2. row *************************** TENANT_ID: 1002 TASK_ID: 2 JOB_ID: 2 INCARNATION: 1 BACKUP_SET_ID: 2 START_TIMESTAMP: 2024-01-31 13:47:57.218929 END_TIMESTAMP: 2024-01-31 13:50:14.974017 STATUS: COMPLETED START_SCN: 1706680089128492000 END_SCN: 1706680214967798000 USER_LS_START_SCN: 1706680104341550000 ENCRYPTION_MODE: NONE PASSWD: INPUT_BYTES: 42941657 OUTPUT_BYTES: 14592769 OUTPUT_RATE_BYTES: 105932.7043 EXTRA_META_BYTES: 0 TABLET_COUNT: 617 FINISH_TABLET_COUNT: 617 MACRO_BLOCK_COUNT: 20 FINISH_MACRO_BLOCK_COUNT: 20 FILE_COUNT: 0 META_TURN_ID: 1 DATA_TURN_ID: 0 RESULT: 0 COMMENT: PATH: file:///data/nfs/backup/data MINOR_TURN_ID: 1 MAJOR_TURN_ID: 1 2 rows in setoceanbase.CDB_OB_BACKUP_JOB_HISTORY视图中的各字段基本与oceanbase.CDB_OB_BACKUP_JOBS视图相对应，oceanbase.CDB_OB_BACKUP_TASK_HISTORY各字段基本与oceanbase.CDB_OB_BACKUP_TASKS相对应。其中，COMMENT用于记录任务失败时的相关错误信息。
更多
CDB_OB_BACKUP_JOB_HISTORY和CDB_OB_BACKUP_TASK_HISTORY视图的说明，参见 CDB_OB_BACKUP_JOB_HISTORY 和 CDB_OB_BACKUP_TASK_HISTORY。查看对应的备份集信息。
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_SET_FILES WHERE TENANT_ID = 1002 AND BACKUP_SET_ID = 1\G查询结果如下：
*************************** 1. row *************************** TENANT_ID: 1002 BACKUP_SET_ID: 1 DEST_ID: 1002 INCARNATION: 1 BACKUP_TYPE: FULL PREV_FULL_BACKUP_SET_ID: 0 PREV_INC_BACKUP_SET_ID: 0 START_TIMESTAMP: 2024-01-31 11:20:59.804836 END_TIMESTAMP: 2024-01-31 11:23:08.762451 STATUS: SUCCESS FILE_STATUS: AVAILABLE ELAPSED_SECONDES: 129 PLUS_ARCHIVELOG: OFF START_REPLAY_SCN: 1706670992366131000 START_REPLAY_SCN_DISPLAY: 2024-01-31 11:16:32.366131 MIN_RESTORE_SCN: 1706671388756316000 MIN_RESTORE_SCN_DISPLAY: 2024-01-31 11:23:08.756316000 INPUT_BYTES: 198130272 OUTPUT_BYTES: 16984419 OUTPUT_RATE_BYTES: 131705.4367 EXTRA_META_BYTES: 0 TABLET_COUNT: 617 FINISH_TABLET_COUNT: 617 MACRO_BLOCK_COUNT: 94 FINISH_MACRO_BLOCK_COUNT: 94 FILE_COUNT: 0 META_TURN_ID: 1 DATA_TURN_ID: 0 RESULT: 0 COMMENT: ENCRYPTION_MODE: NONE PASSWD: TENANT_COMPATIBLE: 4.2.2.0 BACKUP_COMPATIBLE: 3 PATH: file:///data/nfs/backup/data CLUSTER_VERSION: 4.2.2.0 CONSISTENT_SCN: 1706671288404894000 MINOR_TURN_ID: 1 MAJOR_TURN_ID: 1 1 row in set更多
CDB_OB_BACKUP_SET_FILES视图的说明，请参见 CDB_OB_BACKUP_SET_FILES。
用户租户查看数据备份任务历史
租户管理员登录到数据库。
查看数据备份历史。
查看 JOB 级任务历史
租户发起一次备份即对应一条 JOB 任务记录。
MySQL 模式Oracle 模式MySQL 模式下的查询示例如下：
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_JOB_HISTORY\GOracle 模式下的查询示例如下：
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_TASK_HISTORY\G查看 Task 级任务历史
一个 Task 对应一个备份集的任务。
MySQL 模式Oracle 模式MySQL 模式下的查询示例如下：
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_TASK_HISTORY\GOracle 模式下的查询示例如下：
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_TASK_HISTORY\G
查看对应的备份集信息。
MySQL 模式Oracle 模式MySQL 模式下的查询示例如下：
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_SET_FILES WHERE BACKUP_SET_ID = 1 \GOracle 模式下的查询示例如下：
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_SET_FILES WHERE BACKUP_SET_ID = 1 \G
