Note
This view is available starting with V4.0.0.
Purpose
This view displays the backup Job task history for the current tenant.
Columns
| Column | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | The ID of a backup job. One record in the backup job table corresponds to one backup task. | ||||||||||
| INCARNATION | NUMBER(38) | NO | The number indicating the number of incarnations in Flashback Database. | ||||||||||
| BACKUP_SET_ID | NUMBER(38) | YES | The ID of the backup set. For the sys tenant, it defaults to 0. For a regular tenant, the value starts from 1 and increments by 1. | BACKUP_SET_ID | NUMBER(38) | YES | This column specifies the ID of the backup set. For the sys tenant, the default value is 0. For a regular tenant, the value starts from 1 and increments by 1. | ||||||
| INITIATOR_TENANT_ID | NUMBER(38) | NO | The ID of the task initiator's tenant, which identifies the tenant that initiated the task and corresponds to the tenant ID that executed the backup SQL command. | ||||||||||
| INITIATOR_JOB_ID | NUMBER(38) | NO | The JOB_ID of the task initiator. | ||||||||||
| EXECUTOR_TENANT_ID | VARCHAR2(65536) | NO | The ID of the tenant that is to be backed up for the backup task at the job level | ||||||||||
| PLUS_ARCHIVELOG | VARCHAR2(4096) | NO | Whether the log fill feature is enabled: |
||||||||||
| BACKUP_TYPE | VARCHAR2(4096) | NO | Backup type: |
||||||||||
| JOB_LEVEL | VARCHAR2(4096) | NO | JOB level: |
||||||||||
| ENCRYPTION_MODE | VARCHAR2(4096) | YES | Encryption mode: |
||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | PASSWD | VARCHAR2(4096) | YES | Password. | ||
| START_TIMESTAMP | VARCHAR2(256) | NO | The start time of the backup task at the job level. | ||||||||||
| END_TIMESTAMP | VARCHAR2(256) | NO | The end time of a job-level backup task. | ||||||||||
| STATUS | VARCHAR2(4096) | NO | The status of the backup. | ||||||||||
| RESULT | NUMBER(38) | NO | The backup error code. | ||||||||||
| COMMENT | VARCHAR2(4096) | YES | Error code description | ||||||||||
| DESCRIPTION | VARCHAR2(4096) | YES | The backup description specified by the user | ||||||||||
| PATH | VARCHAR2(4096) | YES | Backup path |
Sample query
Users in the user tenants query the history of backup jobs for the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_JOB_HISTORY \G
The query result is as follows: