查看数据备份结果

数据备份执行完成后，您可以通过视图查看备份任务历史。

系统租户查看数据备份任务历史

1. 使用 root 用户登录集群的 sys 租户。

2. 查看数据备份历史。

   • 查看 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 set
     

     oceanbase.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。

3. 查看对应的备份集信息。

   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。

用户租户查看数据备份任务历史

1. 租户管理员登录到数据库。

2. 查看数据备份历史。

   • 查看 JOB 级任务历史

     租户发起一次备份即对应一条 JOB 任务记录。

     MySQL 模式

     Oracle 模式

     MySQL 模式下的查询示例如下：

     obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_JOB_HISTORY\G
     

     Oracle 模式下的查询示例如下：

     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\G
     

     Oracle 模式下的查询示例如下：

     obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_TASK_HISTORY\G
     

3. 查看对应的备份集信息。

   MySQL 模式

   Oracle 模式

   MySQL 模式下的查询示例如下：

   obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_SET_FILES WHERE BACKUP_SET_ID = 1 \G
   

   Oracle 模式下的查询示例如下：

   obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_SET_FILES WHERE BACKUP_SET_ID = 1 \G