View the data backup history

You can query views for the backup history.

View the backup history in views

1. Log on to the sys tenant of a cluster as the root user.

2. View the data backup history.

   Example:

   obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOB_HISTORY\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 16:54:25.940040
         END_TIMESTAMP: 2022-06-01 16:56:03.779662
                STATUS: COMPLETED
                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 16:54:26.007298
         END_TIMESTAMP: 2022-06-01 16:56:03.629399
                STATUS: COMPLETED
                RESULT: 0
               COMMENT:
           DESCRIPTION:
                  PATH: file:///data/nfs/backup/data
   
   obclient> 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: 2022-06-01 16:54:26.007298
              END_TIMESTAMP: 2022-06-01 16:56:03.576909
                     STATUS: COMPLETED
                  START_SCN: 1658739252505427433
                    END_SCN: 1658739352813474497
          USER_LS_START_SCN: 1658739274182399688
            ENCRYPTION_MODE: NONE
                     PASSWD:
                INPUT_BYTES: 567650229
               OUTPUT_BYTES: 567650229
          OUTPUT_RATE_BYTES: 5817899.8889
            EXTRA_META_BYTES: 0
               TABLET_COUNT: 1285
        FINISH_TABLET_COUNT: 1285
          MACRO_BLOCK_COUNT: 270
   FINISH_MACRO_BLOCK_COUNT: 270
                 FILE_COUNT: 0
               META_TURN_ID: 1
               DATA_TURN_ID: 1
                     RESULT: 0
                    COMMENT:
                       PATH: file:///data/nfs/backup/data
   

   The fields in the oceanbase.CDB_OB_BACKUP_JOB_HISTORY view correspond to those in the oceanbase.CDB_OB_BACKUP_JOBS view. The fields in the oceanbase.CDB_OB_BACKUP_TASK_HISTORY view correspond to those in the oceanbase.CDB_OB_BACKUP_TASKS view. The COMMENT field records the error information of a failed job or task.

   For more information about the CDB_OB_BACKUP_JOB_HISTORY and CDB_OB_BACKUP_TASK_HISTORY views, see CDB_OB_BACKUP_JOB_HISTORY and CDB_OB_BACKUP_TASK_HISTORY.

3. View the backup sets.

   obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_SET_FILES WHERE backup_set_id = 1 AND tenant_id = 1004\G
   *************************** 1. row ***************************
                    TENANT_ID: 1002
                BACKUP_SET_ID: 1
                      DEST_ID: 1001
                  INCARNATION: 1
                  BACKUP_TYPE: FULL
      PREV_FULL_BACKUP_SET_ID: 0
       PREV_INC_BACKUP_SET_ID: 0
              START_TIMESTAMP: 2022-06-01 16:54:26.007298
                END_TIMESTAMP: 2022-06-01 16:56:03.576909
                       STATUS: SUCCESS
                  FILE_STATUS: AVAILABLE
             ELAPSED_SECONDES: 469
              PLUS_ARCHIVELOG: OFF
             START_REPLAY_SCN: 0
     START_REPLAY_SCN_DISPLAY:
              MIN_RESTORE_SCN: 1662389318902587000
      MIN_RESTORE_SCN_DISPLAY: 2022-06-01 16:55:03.902587
                  INPUT_BYTES: 567650229
                 OUTPUT_BYTES: 567650229
            OUTPUT_RATE_BYTES: 5817899.8889
             EXTRA_META_BYTES: 0
                 TABLET_COUNT: 1285
          FINISH_TABLET_COUNT: 1285
            MACRO_BLOCK_COUNT: 270
     FINISH_MACRO_BLOCK_COUNT: 270
                   FILE_COUNT: 0
                 META_TURN_ID: 1
                 DATA_TURN_ID: 1
                       RESULT: 0
                      COMMENT:
              ENCRYPTION_MODE: NONE
                       PASSWD:
            TENANT_COMPATIBLE: 4.0.0.0
            BACKUP_COMPATIBLE: 0
                         PATH: file:///data/nfs/backup/data
   

   For more information about the CDB_OB_BACKUP_SET_FILES view, see CDB_OB_BACKUP_SET_FILES.