Note
This view is available starting with V4.0.0.
Purpose
This view displays backup jobs for all tenants in the cluster. A record is recorded for each backup task initiated by the user.
Columns
| Column | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column | Type | Nullable | Description | --- | --- | --- | --- | TENANT_ID | bigint(20) | NO | Tenant ID | ||
| Column | Type | Nullable | Description | --- | --- | --- | --- | JOB_ID | bigint(20) | NO | The backup job ID. One job record corresponds to one backup job. | ||
| INCARNATION | bigint(20) | NO | This value represents the number of times the flashback database has been performed. | ||||||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | BACKUP_SET_ID | bigint(20) | YES | The ID of the backup set. For the sys tenant, the value is 0. For a user tenant, the value starts from 1 and is incremented by 1 for each backup set. | ||
| INITIATOR_TENANT_ID | bigint(20) | NO | ID of the tenant that initiates the task. The value indicates the ID of the tenant that initiated the task, which corresponds to the ID of the tenant that executes the backup SQL statement. | ||||||||||
| INITIATOR_JOB_ID | bigint(20) | NO | The JOB_ID of the task initiator. | ||||||||||
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The ID of the tenant for which the backup job is performed. | ||||||||||
| PLUS_ARCHIVELOG | varchar(4096) | NO | Specifies whether to enable the log fill-in feature: |
||||||||||
| BACKUP_TYPE | varchar(4096) | NO | Backup type: |
||||||||||
| JOB_LEVEL | varchar(4096) | NO | The backup job level. Valid values: |
||||||||||
| ENCRYPTION_MODE | varchar(4096) | YES | Encryption mode: Currently, only the None and Password modes are supported. |
||||||||||
| PASSWD | varchar(4096) | YES | Password | ||||||||||
| START_TIMESTAMP | timestamp(6) | NO | The start time of the job-level backup task | ||||||||||
| END_TIMESTAMP | timestamp(6) | NO | The end time of a job-level backup task. | ||||||||||
| STATUS | varchar(4096) | NO | Backup status | ||||||||||
| RESULT | bigint(20) | NO | Backup error code result | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | COMMENT | varchar(4096) | YES | Error description | ||
| DESCRIPTION | varchar(4096) | YES | The description that you specify during backup. | ||||||||||
| PATH | varchar(4096) | YES | Backup path |
Sample query
System tenant views the backup job of tenant ID 1002.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOBS WHERE TENANT_ID = 1002\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
JOB_ID: 2
INCARNATION: 1
BACKUP_SET_ID: 2
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID: 1002
PLUS_ARCHIVELOG: OFF
BACKUP_TYPE: FULL
JOB_LEVEL: USER_TENANT
ENCRYPTION_MODE: NONE
PASSWD:
START_TIMESTAMP: 2025-01-07 14:24:12.797543
END_TIMESTAMP: NULL
STATUS: DOING
RESULT: 0
COMMENT:
DESCRIPTION:
PATH: file:///home/admin/oceanbase/backupdata
1 row in set