Notes
This view is available starting with V4.0.0.
Purpose
This view displays the history of backup tasks for the current tenant. The sys and Meta tenants do not support physical backup.
Columns
| Column | Column | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column | Type | Nullable | Description | --- | --- | --- | --- | JOB_ID | bigint(20) | NO | The backup job ID. Each backup task corresponds to a JOB task record. | ||
| INCARNATION | bigint(20) | NO | The number of Flashback Database incarnations. | ||||||||||
| BACKUP_SET_ID | bigint(20) | YES | Backup set ID. For the sys tenant, the value is 0. For other tenants, the value is an integer starting from 1. | ||||||||||
| INITIATOR_TENANT_ID | bigint(20) | NO | ID of the task initiator, indicating the tenant that initiated the task. This value corresponds to the ID of the tenant that executed the backup SQL command. | ||||||||||
| 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 backup is to be performed, which is associated with the job-level backup task. | ||||||||||
| PLUS_ARCHIVELOG | varchar(4096) | NO | Specifies whether to enable log filling feature:
|
||||||||||
| BACKUP_TYPE | varchar(4096) | NO | Backup type:
|
||||||||||
| JOB_LEVEL | varchar(4096) | NO | The job level. Valid values:
|
||||||||||
| ENCRYPTION_MODE | varchar(4096) | YES | Encryption mode:
Only the None and Password modes are supported. |
||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | PASSWD | varchar(4096) | YES | The password. | ||
| START_TIMESTAMP | timestamp(6) | NO | The time when the job-level backup task starts. | ||||||||||
| END_TIMESTAMP | timestamp(6) | NO | The end time of a job-level backup task. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | STATUS | varchar(4096) | NO | Backup status. | ||
| RESULT | bigint(20) | NO | Backup error code | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | COMMENT | varchar(4096) | YES | The description of the error code. | ||
| DESCRIPTION | varchar(4096) | YES | The description information specified by the user. | ||||||||||
| PATH | varchar(4096) | YES | Backup path |
References
Query the jobs of all tenants: CDB_OB_BACKUP_JOBS
View the tasks of task-level backups for all tenants: CDB_OB_BACKUP_TASKS
Query the historical records of backup tasks at the task level 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.