Purpose
oceanbase.CDB_OB_BACKUP_VALIDATION_JOB displays the execution progress and details of backup validation jobs in OceanBase Cloud Platform (OCP) and stores only jobs in progress.
Related views
oceanbase.CDB_OB_BACKUP_VALIDATION_JOB_HISTORY
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the job. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TENANT_NAME | varchar(0) | NO | The tenant name. |
| INCARNATION | bigint(20) | NO | The nth incarnation of the database after the Flashback Database operation. |
| BACKUP_SET_ID | bigint(20) | NO | The ID of the backup set. |
| PROGRESS_PERCENT | bigint(1) | NO | The backup validation progress. |
| STATUS | varchar(64) | NO | The backup validation status. Valid values: SUCCESSFAILED |
| VALIDATE_TYPE | bigint(20) | NO | The type of the backup validation task. Valid values:
|
| BACKUP_DEST | varchar(2048) | NO | The position of the original backup, which is the position of the data that needs to be read for backup validation. |
| START_TIME | timestamp(6) | NO | The start time. |
| END_TIME | timestamp(6) | NO | The end time. |
| RESULT | bigint(20) | NO | The validation results. |
| COMMENT | varchar(4096) | NO | The comment for the validation job. |
| BACKUP_CLUSTER_NAME | varchar(128) | NO | The name of the cluster where the data for backup validation is located. This parameter exists in cross-cluster backup validation. |
| BACKUP_CLUSTER_ID | bigint(20) | NO | The ID of the cluster where the data for backup validation is located. This parameter exists in cross-cluster backup validation. |