oceanbase.CDB_OB_BACKUP_BACKUPPIECE_JOB

2023-10-24 09:23:03  Updated

Purpose

oceanbase.CDB_OB_BACKUP_BACKUPPIECE_JOB displays the progress of secondary piece backup jobs.

Fields

Field Type Nullable? Description
JOB_ID bigint(20) NO The ID of the job.
TENANT_ID bigint(20) NO The ID of the tenant.
INCARNATION bigint(20) NO The nth incarnation of the database after the Flashback Database operation.
BACKUP_PIECE_ID bigint(20) NO The ID of the backup piece.
MAX_BACKUP_TIMES bigint(20) NO The number of redundant backup copies.
RESULT bigint(20) NO The result of secondary piece backup.
STATUS varchar(64) NO The status of the secondary piece backup task. Valid values:
  • SCHEDULE: indicates that the task was just scheduled.
  • DOING: indicates that the task is in progress.
  • CANCEL: indicates that the job has been canceled.
  • FINISH: indicates that the task is completed.
  • BACKUP_DEST varchar(2048) YES The destination path for storing the secondary backup piece.
    COMMENT varchar(4096) NO The error message of backup failure.
    TYPE bigint(20) NO The type of the secondary piece backup job. Valid values:
  • 0: indicates that pieces in the FROZEN state are to be copied.
  • 1: indicates that pieces in the ACTIVE state are to be copied.
  • Contact Us