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 |