Note
This view is available starting with V4.0.0.
Purpose
This view displays backup tasks of the current tenant. Physical backups are not supported for the sys tenant and Meta tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the backup job. Each backup operation corresponds to one job record. |
| INCARNATION | bigint(20) | NO | The incarnation number after a Flashback Database operation. |
| BACKUP_SET_ID | bigint(20) | YES | The ID of the backup set. For the sys tenant, the default value is 0. For other tenants, the value starts from 1 and increments by 1 for each new backup set. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the task initiator. This value indicates the tenant that initiated the task, which is the tenant that executed 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 job-level backup task is to be executed. |
| PLUS_ARCHIVELOG | varchar(4096) | NO | Whether to enable log backfilling. Valid values:
|
| BACKUP_TYPE | varchar(4096) | NO | The backup type. Valid values:
|
| JOB_LEVEL | varchar(4096) | NO | The job level. Valid values:
|
| ENCRYPTION_MODE | varchar(4096) | YES | The encryption mode. Valid values:
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 the job-level backup task. |
| STATUS | varchar(4096) | NO | The backup status. |
| RESULT | bigint(20) | NO | The backup error code result. |
| COMMENT | varchar(4096) | YES | The description of the error code. |
| DESCRIPTION | varchar(4096) | YES | The user-specified backup description. |
| PATH | varchar(4096) | YES | The backup path. |
References
Query the history records of backup jobs at the tenant level: CDB_OB_BACKUP_JOB_HISTORY
View task-level backup tasks for all tenants: CDB_OB_BACKUP_TASKS
View the history of task-level backup tasks for all tenants: CDB_OB_BACKUP_TASK_HISTORY
For more information about how to view the data backup progress, see View the data backup progress.