Note
This view is available starting with V4.0.0.
Purpose
This view displays the historical records of backup jobs for the current tenant. Note that physical backups are not supported in the sys or metastore tenant.
Columns
Column |
Column |
Nullable |
Description |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| JOB_ID | bigint(20) | NO | ID of the backup job task. A backup job corresponds to one backup task record. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | INCARNATION | bigint(20) | NO | Indicates the number of times the database has been incarnated after the Flashback Database operation. | ||
| 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, the value is automatically incremented from 1. | ||
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the task initiator, which indicates the tenant that initiated the task. The value is the tenant ID of the tenant that executed the backup SQL statement. | ||||||||||
| INITIATOR_JOB_ID | bigint(20) | NO | task initiator's job id | ||||||||||
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The tenant ID of the backup task at the job level to be backed up. | ||||||||||
| PLUS_ARCHIVELOG | varchar(4096) | NO | Specify whether to enable the log archival feature. 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 | Specifies the encryption mode. Valid values:
|
||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | PASSWD | varchar(4096) | YES | Password | ||
| START_TIMESTAMP | timestamp(6) | NO | The start time of a job-level backup task. | ||||||||||
| END_TIMESTAMP | timestamp(6) | NO | The end time of the job-level backup task. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | STATUS | varchar(4096) | NO | The status of the backup. | ||
| RESULT | bigint(20) | NO | Result of backup error code | ||||||||||
| COMMENT | varchar(4096) | YES | Error description | ||||||||||
| DESCRIPTION | varchar(4096) | YES | User-specified description of the backup task | ||||||||||
| PATH | varchar(4096) | YES | Backup path |
References
View backup job tasks for all tenants: CDB_OB_BACKUP_JOBS
View 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 the data backup progress, see View the data backup progress.