Purpose
oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY displays information about completed secondary backup tasks on the baseline backup.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| INCARNATION | bigint(20) | NO | The nth incarnation of the database after the Flashback Database operation. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| BS_KEY | bigint(20) | NO | The value of the backup set. |
| COPY_ID | bigint(20) | NO | The nth copy. |
| BACKUP_TYPE | varchar(1) | NO | The type of the backup. |
| ENCRYPTION_MODE | varchar(64) | NO | The encryption mode. |
| START_TIME | timestamp(6) | NO | The time when the secondary backup of the backup set started. |
| COMPLETION_TIME | timestamp(6) | NO | The time when the secondary backup of the backup set is completed. |
| ELAPSED_SECONDES | decimal(21,0) | NO | The time consumed for the secondary backup. |
| KEEP | varchar(2) | NO | Indicates whether the backup set is kept. |
| KEEP_UNTIL | varchar(0) | NO | The duration for keeping the backup set. |
| SRC_DEVICE_TYPE | varchar(64) | NO | The type of the source device. |
| DST_DEVICE_TYPE | varchar(64) | NO | The type of the destination device. |
| COMPRESSED | varchar(2) | NO | Indicates whether the backup set is compressed. |
| OUTPUT_BYTES | bigint(20) | NO | The size of the output data. |
| OUTPUT_RATE_BYTES | decimal(34,4) | NO | The size of the output data in bytes. |
| COMPRESSION_RATIO | decimal(23,2) | NO | The compression ratio. |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The display value of the size of the output data. |
| OUTPUT_RATE_BYTES_DISPLAY | varchar(39) | NO | The display value of the size of the output data in bytes. |
| TIME_TAKEN_DISPLAY | time(6) | NO | The display value of the time consumed. |
| STATUS | varchar(9) | NO | The secondary backup status. |