Purpose
oceanbase.CDB_OB_BACKUP_VALIDATION_TASK_HISTORY is the history table of oceanbase.CDB_OB_TENANT_BACKUP_VALIDATION_TASK.
Related views
oceanbase.CDB_OB_TENANT_BACKUP_VALIDATION_TASK
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the backup validation job. |
| TASK_ID | bigint(1) | NO | The ID of the backup validation task. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| 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. |
| VALIDATE_TYPE | bigint(20) | NO | The type of the validation job. |
| STATUS | varchar(64) | NO | The backup validation status. Valid values: SUCCESSFAILED |
| BACKUP_DEST | varchar(2048) | YES | 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. |
| TOTAL_PG_COUNT | bigint(20) | NO | The total number of partition groups. |
| FINISH_PG_COUNT | bigint(20) | NO | The number of partition groups that have been validated. |
| TOTAL_PARTITION_COUNT | bigint(20) | NO | The total number of partitions. |
| FINISH_PARTITION_COUNT | bigint(20) | NO | The number of partitions that have been validated. |
| TOTAL_MACRO_BLOCK_COUNT | bigint(20) | NO | The total number of macro blocks. |
| FINISH_MACRO_BLOCK_COUNT | bigint(20) | NO | The number of macro blocks that have been validated. |
| LOG_SIZE | bigint(20) | NO | The size of the log that needs to be validated. |
| RESULT | bigint(20) | NO | The validation results. |
| COMMENT | varchar(4096) | NO | The comment for the validation job. |