oceanbase.CDB_OB_BACKUP_DELETE_JOBS

最終更新:2026-09-04 09:48:49

Note

This view is available starting with V4.0.0.

Purpose

This view displays the execution progress of tenant-level backup cleanup jobs.

Columns

Column	Type	Nullable	Description
TENANT_ID	bigint(20)	NO	The tenant ID.
JOB_ID	bigint(20)	NO	The job ID, which is a monotonic incrementing value.
INCARNATION	bigint(20)	NO	The incarnation ID.
INITIATOR_TENANT_ID	bigint(20)	NO	The tenant ID that initiated the job.
INITIATOR_JOB_ID	bigint(20)	NO	The job ID of the tenant that initiated the job.
EXECUTOR_TENANT_ID	varchar(65536)	NO	The list of tenants that executed the cleanup task.
TYPE	varchar(64)	NO	The cleanup type. Valid values: expired, specified backup_set/round/piece, or canceled.
PARAMETER	timestamp(6)	NO	The content of the parameter is as follows: For automatic cleanup: policy_name = xxx; expired_time = xxx; redundancy:2; backup_copies:1; For manual cleanup of a backup_set: backup_set_id = 1; dest_id = 1; dest = xxxxx; For manual cleanup of a backup_piece: dest_round_id = 1; backup_piece_id = 1; dest_id = 1; dest = xxxx; For manual cleanup of a backup_round: dest_round_id = 1; dest_id = 1; dest = xxxx; For cleanup of all backups in a destination: dest_id = 1; dest = xxx;
JOB_LEVEL	varchar(64)	NO	The job initiation level. Valid values: USER_TENANT, CLUSTER, and SYS_TENANT.
START_TIMESTAMP	timestamp(6)	NO	The current time of the tenant when the job started.
END_TIMESTAMP	timestamp(6)	NO	The current time of the tenant when the job ended.
STATUS	varchar(64)	NO	The job status. Valid values: INIT DOING CANCELING CANCELED COMPLETED FAILED
TASK_COUNT	bigint(20)	YES	The number of backup_set/piece tasks.
SUCCESS_TASK_COUNT	bigint(20)	YES	The number of backup_set/piece tasks that were executed successfully.
RESULT	bigint(20)	NO	The error code.
COMMENT	varchar(4096)	YES	The description of the job execution.

Sample query

Query the execution progress of all tenant-level backup cleanup jobs in the sys tenant.

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

The query result is as follows:

*************************** 1. row ***************************
               TENANT_ID: 1002
                  JOB_ID: 7
             INCARNATION: 1
     INITIATOR_TENANT_ID: 1002
        INITIATOR_JOB_ID: 7
      EXECUTOR_TENANT_ID: 1002
                    TYPE: DELETE OBSOLETE BACKUP
               PARAMETER: 2022-05-31 12:09:40.060284
               JOB_LEVEL: USER_TENANT
         START_TIMESTAMP: 2022-06-01 12:09:53.389512
           END_TIMESTAMP: 
                  STATUS: DOING
              TASK_COUNT: 2
      SUCCESS_TASK_COUNT: 1
                  RESULT: 0
                 COMMENT: 
1 row in set

次のトピック

What's New