oceanbase.DBA_OB_BACKUP_DELETE_JOBS

2025-12-09 07:09:36  Updated

Feature

This view shows the execution progresses of tenant-level backup cleanup JOB tasks.

Fields

Field Type Nullable Description
TENANT_ID bigint(20) NO The ID of the tenant.
JOB_ID bigint(20) NO The task ID, which monotonically increases.
INCARNATION bigint(20) NO The ID of the incarnation.
INITIATOR_TENANT_ID bigint(20) NO The ID of the tenant that initiated the JOB.
INITIATOR_JOB_ID bigint(20) NO The ID of the JOB initiated by the tenant.
EXECUTOR_TENANT_ID varchar(65536) NO The IDs of tenants that execute the cleanup task.
TYPE varchar(64) NO The cleanup type, including cleanup upon expiration, cleanup for a specified backup set/round/piece, and cleanup canceling.
PARAMETER varchar(1024) NO The parameters are as follows:
  • Automatic cleanup or cleanup upon expiration: policy_name = xxx; expired_time = xxx; redundancy:2; backup_copies:1;
  • Manual cleanup for a specified backup set: backup_set_id = 1; dest_id = 1; dest = xxxxx;
  • Manual cleanup for a specified backup piece: dest_round_id = 1; backup_piece_id = 1; dest_id = 1; dest = xxxx;
  • Manual cleanup for a specified backup round: dest_round_id = 1; dest_id = 1; dest = xxxx;
  • Cleanup of backup data on the entire destination: dest_id = 1; dest = xxx;
  • JOB_LEVEL varchar(64) NO The task initiation level. Valid values: USER_TENANT, CLUSTER, and SYS_TENANT.
    START_TIMESTAMP timestamp(6) NO The time on the tenant when the task started.
    END_TIMESTAMP varchar(26) NO The time on the tenant when the task ended.
    STATUS varchar(64) NO The status of the task. Valid values:
  • INIT
  • DOING
  • CANCELING
  • CANCELED
  • COMPLETED
  • FAILED
  • TASK_COUNT bigint(20) YES The number of backup set/piece cleanup tasks.
    SUCCESS_TASK_COUNT bigint(20) YES The number of backup set/piece cleanup tasks that are successfully executed.
    RESULT bigint(20) NO The error code.
    COMMENT varchar(4096) YES The execution description of the task.

    Contact Us