Note
This view is available starting with V4.0.0.
Purpose
This view displays the backup jobs for the current tenant.
Columns
| Column | Column | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column | Type | Nullable | Description | --- | --- | --- | --- | JOB_ID | NUMBER(38) | NO | Backup job task ID. A backup job is associated with one record. | ||
| INCARNATION | NUMBER(38) | NO | This view displays the number of times a flashback database has been incarnated. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | BACKUP_SET_ID | NUMBER(38) | YES | The ID of the backup set. For the sys tenant, it is 0 by default. For normal tenants, the ID starts from 1 and is incremented as required. | ||
| INITIATOR_TENANT_ID | NUMBER(38) | NO | The tenant ID of the task initiator, which indicates the tenant that initiated the task. This value corresponds to the tenant ID of the tenant that executed the backup SQL statement. | ||||||||||
| INITIATOR_JOB_ID | NUMBER(38) | NO | The JOB_ID of the task initiator. | ||||||||||
| EXECUTOR_TENANT_ID | varchar2(65536) | NO | The ID of the tenant on which the backup task is performed. | ||||||||||
| PLUS_ARCHIVELOG | varchar2(4096) | NO | Whether to enable the archive log supplement feature:
|
||||||||||
| BACKUP_TYPE | varchar2(4096) | NO | The type of backup, which takes the following values:
|
||||||||||
| JOB_LEVEL | varchar2(4096) | NO | Job level:
|
||||||||||
| ENCRYPTION_MODE | varchar2(4096) | YES | The encryption mode:
Only None and Password encryption modes are supported at present. |
||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | PASSWD | varchar(4096) | YES | Password | ||
| START_TIMESTAMP | VARCHAR2(256) | NO | The start time of a backup task at the job level. | ||||||||||
| END_TIMESTAMP | VARCHAR2(256) | NO | The end time of backup tasks at the job level. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | STATUS | varchar2(4096) | NO | backup status | ||
| RESULT | NUMBER(38) | NO | The error code of the backup task. | ||||||||||
| COMMENT | varchar2(4096) | YES | Error code description | ||||||||||
| DESCRIPTION | varchar2(4096) | YES | User-specified backup description. | ||||||||||
| PATH | varchar2(4096) | YES | The backup path. |
Sample query
User tenants can view backup jobs for their own tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_JOBS\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 1
INCARNATION: 1
BACKUP_SET_ID: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID: 1004
PLUS_ARCHIVELOG: OFF
BACKUP_TYPE: FULL
JOB_LEVEL: USER_TENANT
ENCRYPTION_MODE: NONE
PASSWD: NULL
START_TIMESTAMP: 2025-06-05 10:07:30
END_TIMESTAMP: NULL
STATUS: DOING
RESULT: 0
COMMENT: NULL
DESCRIPTION: NULL
PATH: file:///home/admin/oceanbase/backupdataoracle
1 row in set
References
View the historical records of Job-level backups for the current tenant: DBA_OB_BACKUP_JOB_HISTORY
Query tasks of backup at the tenant level: DBA_OB_BACKUP_TASKS
Query the history of task-level backup tasks of the current tenant: DBA_OB_BACKUP_TASK_HISTORY.
For more information about how to view the data backup progress, see View the data backup progress.