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 |
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 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.