Description
oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB displays information about secondary backup jobs on the baseline backup. Each SQL statement corresponds to one job.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The job ID. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. For a system tenant, the value is 1. |
| INCARNATION | bigint(20) | NO | Indicates the nth incarnation of the database after the Flashback Database operation. |
| BACKUP_SET_ID | bigint(20) | NO | The ID of the backup set. |
| TYPE | varchar(17) | NO | Indicates whether a single backup set or a collection of all backup sets are backed up. Valid values: * S: a single backup set. * A: all backup sets. |
| TENANT_NAME | varchar(128) | NO | The name of the tenant.oceanbase.CDB_OB_RESTORE_PROGRESS |
| STATUS | varchar(64) | NO | The backup status. Valid values: * SCHEDULE: indicates that the job was just scheduled. * DOING: indicates that the job is being executed. * CANCEL: indicates that the job is canceled. * FINISH: indicates that the job is completed. |
| BACKUP_DEST | varchar(2048) | YES | The destination of the backup. |
| MAX_BACKUP_TIMES | bigint(20) | NO | The number of redundant backup copies. |
| RESULT | bigint(20) | NO | The result of the secondary backup. |