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 | Column | Nullable | Column | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | JOB_ID | bigint(20) | NO | Backup JOB task ID. Each backup corresponds to a JOB task record. | ||
| INCARNATION | bigint(20) | NO | This column indicates how many incarnations have occurred since the last Flashback Database operation. | ||||||||||
| BACKUP_SET_ID | bigint(20) | YES | The ID of the backup set. For the sys tenant, it is 0. For ordinary tenants, it starts from 1. | ||||||||||
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the task initiator. This value indicates the tenant that initiated the task and the tenant that executed the backup SQL command. | ||||||||||
| INITIATOR_JOB_ID | bigint(20) | NO | The ID of the task initiator. | ||||||||||
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The tenant ID of the backup tenant associated with the job-level backup task. | ||||||||||
| PLUS_ARCHIVELOG | varchar(4096) | NO | Indicates whether the archive log feature is enabled. Valid values: ON and OFF. | ||||||||||
| BACKUP_TYPE | varchar(4096) | NO | Backup type:
|
||||||||||
| JOB_LEVEL | varchar(4096) | NO | The job level. Valid values:
|
||||||||||
| ENCRYPTION_MODE | varchar(4096) | YES | Encryption mode:
This view is available starting with V1.0.0. Currently, only None and Password are supported. |
||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | PASSWD | varchar(4096) | YES | Password | ||
| START_TIMESTAMP | timestamp(6) | NO | Start time of the backup task at the job level | ||||||||||
| END_TIMESTAMP | timestamp(6) | NO | The end time of a job-level backup task. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | STATUS | varchar(4096) | NO | The backup status. | ||
| RESULT | bigint(20) | NO | Backup error code result | ||||||||||
| COMMENT | varchar(4096) | YES | Description of error code | ||||||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | description | varchar(4096) | YES | User-specified description for the backup. | ||
| PATH | varchar(4096) | YES | 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.