Purpose
oceanbase.CDB_OB_BACKUP_VALIDATION_JOB_HISTORY displays the execution progress and details of backup validation jobs on OCP and stores all historical jobs.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the backup validation job. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TENANT_NAME | varchar(0) | NO | The tenant name. The default value is NULL. |
| INCARNATION | bigint(20) | NO | The number of the incarnation of the database. |
| BACKUP_SET_ID | bigint(20) | NO | The ID of the backup set. |
| PROGRESS_PERCENT | bigint(3) | NO | The backup validation progress. |
| STATUS | varchar(64) | NO | The backup validation status. Valid values: |
| VALIDATE_TYPE | bigint(20) | NO | The type of the validation job. |
| 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. |