Purpose
oceanbase.CDB_OB_BACKUP_BACKUPPIECE_JOB_HISTORY displays information about completed secondary piece backup jobs.
Related views
oceanbase.CDB_OB_BACKUP_BACKUPPIECE_JOB
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. |
| INCARNATION | bigint(20) | NO | The nth incarnation of the database after the Flashback Database operation. |
| BACKUP_PIECE_ID | bigint(20) | NO | The ID of the backup piece. |
| MAX_BACKUP_TIMES | bigint(20) | NO | The number of redundant backup copies. |
| RESULT | bigint(20) | NO | The result of secondary piece backup. |
| STATUS | varchar(64) | NO | The status of the secondary piece backup task. Valid values: |
| BACKUP_DEST | varchar(2048) | YES | The destination path for storing the secondary backup piece. |
| COMMENT | varchar(4096) | NO | The error message of backup failure. |
| TYPE | bigint(20) | NO | The type of the second piece backup task. Valid values: 0: indicates that pieces in the FROZEN state are to be copied. 1: indicates that pieces in theACTIVE state are to be copied. |