Note
This view is available starting with V4.0.0.
Purpose
This view displays backup Job history records in the current tenant. Physical backups are not supported for the sys tenant and the Meta tenant.
Columns
| Column | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | JOB_ID | bigint(20) | NO | The job ID of the backup task. Each backup job corresponds to one job record. | ||
| INCARNATION | bigint(20) | NO | This value indicates the number of times the database is forked after a flashback. | ||||||||||
| BACKUP_SET_ID | bigint(20) | YES | This value uniquely identifies a backup set. For the sys tenant, the default value is 0. For other tenants, this value starts from 1. | ||||||||||
| INITIATOR_TENANT_ID | bigint(20) | NO | The ID of the tenant that initiated the task. This field indicates the tenant that initiated the task and corresponds to the ID of the tenant that executed the backup SQL command. | ||||||||||
| INITIATOR_JOB_ID | bigint(20) | NO | The ID of the JOB that is initiated by the task. | ||||||||||
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The ID of the tenant to which the backup task belongs. | ||||||||||
| PLUS_ARCHIVELOG | varchar(4096) | NO | Specifies whether to enable the log completion feature: |
||||||||||
| BACKUP_TYPE | varchar(4096) | NO | The backup type. Valid values: |
||||||||||
| JOB_LEVEL | varchar(4096) | NO | This field indicates the job level. Valid values: |
||||||||||
| ENCRYPTION_MODE | varchar(4096) | YES | This column indicates the encryption mode, which can be one of the following values: Currently, only the None and Password modes are supported. |
||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | PASSWORD | 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 a backup job at the JOB level. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | STATUS | varchar(4096) | NO | Backup status | ||
| RESULT | bigint(20) | NO | The backup error code. | ||||||||||
| COMMENT | varchar(4096) | YES | Description of the error code | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | DESCRIPTION | varchar(4096) | YES | User-specified backup description | ||
| PATH | varchar(4096) | YES | Backup path |