Note
This view is available starting with V4.0.0.
Purpose
This view shows the backup jobs of the current tenant. Physical backup is not supported in the sys tenant and the Meta tenant.
Columns
| Column | Column | Nullable | Column | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of a backup task. One record of a backup task is generated when a backup job is initiated. | ||||||||||
| INCARNATION | bigint(20) | NO | This view displays the number of times that the Flashback Database has been performed on this node. | ||||||||||
| 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 other tenants, it is incremented from 1. | ||
| INITIATOR_TENANT_ID | bigint(20) | NO | The ID of the initiator tenant. This value indicates the tenant that initiated the task. This value corresponds to the ID of the tenant that executed the backup SQL statement. | ||||||||||
| INITIATOR_JOB_ID | bigint(20) | NO | The job ID of the initiator. | ||||||||||
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The tenant ID of the JOB backup task. | ||||||||||
| PLUS_ARCHIVELOG | varchar(4096) | NO | Specifies whether to enable the log archive function:
|
||||||||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | BACKUP_TYPE | varchar(4096) | NO | Backup type:
|
||
| JOB_LEVEL | varchar(4096) | NO | The job level. Valid values:
|
||||||||||
| ENCRYPTION_MODE | varchar(4096) | YES | Encryption mode:
None and Password are currently the only supported modes. |
||||||||||
| PASSWD | varchar(4096) | YES | Password | ||||||||||
| START_TIMESTAMP | timestamp(6) | NO | The time when the backup task at the job level starts. | ||||||||||
| END_TIMESTAMP | timestamp(6) | NO | The end time of the backup of the job. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | STATUS | varchar(4096) | NO | The backup status. | ||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | RESULT | bigint(20) | NO | The backup error code. | ||
| COMMENT | varchar(4096) | YES | Description of the error code | ||||||||||
| Description | varchar(4096) | YES | User-specified description of the backup | ||||||||||
| PATH | varchar(4096) | YES | Backup path |
References
Query the historical record of job-level backups across all tenants: CDB_OB_BACKUP_JOB_HISTORY
View the task-level backup tasks of all tenants: CDB_OB_BACKUP_TASKS
View the history of task-level backups for all tenants: CDB_OB_BACKUP_TASK_HISTORY
For more information about how to view data backup progress, see View data backup progress.