Notes
This view is available starting with V4.0.0.
Purpose
This view displays the backup tasks for the current user. The sys and Meta tenants do not support physical backup.
Columns
| Column | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column | Type | Nullable | Description | --- | --- | --- | --- | JOB_ID | bigint(20) | NO | The ID of the backup task. Each backup task record corresponds to one backup job. | ||
| Column | Type | Nullable | Description | --- | --- | --- | --- | INCARNATION | bigint(20) | NO | Indicates the number of incarnations performed after a flashback. | ||
| BACKUP_SET_ID | bigint(20) | YES | The ID of the backup set. The ID of a backup set in the sys tenant is 0. For a non-sys tenant, the ID starts from 1 and increases by 1. | ||||||||||
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the task initiator. This field indicates the tenant ID of the initiator that executes the SQL statement for backup. | ||||||||||
| INITIATOR_JOB_ID | bigint(20) | NO | Job ID of the task initiator | ||||||||||
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The ID of the tenant for which the backup job is executed. | ||||||||||
| COLUMN | DATA TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | PLUS_ARCHIVELOG | varchar(4096) | NO | Specifies whether to enable log backfilling. |
||
| BACKUP_TYPE | varchar(4096) | NO | Backup type: |
||||||||||
| JOB_LEVEL | varchar(4096) | NO | Level of the backup job: |
||||||||||
| ENCRYPTION_MODE | varchar(4096) | YES | Encryption mode: Currently, 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. | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | STATUS | varchar(4096) | NO | The backup status. | ||
| RESULT | bigint(20) | NO | The backup error code | ||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | COMMENT | varchar(4096) | YES | Error code description. | ||
| DESCRIPTION | varchar(4096) | YES | User-specified backup description | ||||||||||
| PATH | varchar(4096) | YES | Backup path |