Purpose
oceanbase.CDB_OB_BACKUP_JOB_DETAILS displays the details of backup jobs.
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 ID of the backup set. |
| BACKUP_TYPE | VARCHAR(1) | NO | D: indicates full backup.I: indicates incremental backup. |
| ENCRYPTION_MODE | varchar(64) | NO | None: indicates that encryption is not implemented.Password: indicates that only the password is used for protection.Password encryption: indicates that encryption is implemented and the password is used for protection.Transparent encryption: indicates that Transparent Data Encryption (TDE) is used for encryption.Dual mode encryption: indicates that TDE is used for encryption and the password is also used for protection. In the current version, only the None and Password modes are supported. |
| START_TIME | timestamp(6) | NO | The start time of the job. |
| END_TIME | timestamp(6) | NO | The end time of the task. |
| INPUT_BYTES | bigint(20) | NO | The size of the read data. |
| OUTPUT_BYTES | bigint(20) | NO | The size of the output data. |
| OUTPUT_DEVICE_TYPE | varchar(64) | NO | The medium for storing backup data. |
| ELAPSED_SECONDS | decimal(21,0) | NO | The time consumed. |
| COMPRESSION_RATIO | decimal(23,2) | NO | The compression ratio. |
| INPUT_BYTES_PER_SEC | decimal(34,4) | NO | The number of bytes that are input per second. |
| OUTPUT_BYTES_PER_SEC | decimal(34,4) | NO | The number of bytes that are output per second. |
| STATUS | varchar(9) | NO | The status of the backup task. Valid values: |
| INPUT_BYTES_DISPLAY | varchar(27) | NO | The number of input bytes. |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The number of output bytes. |
| INPUT_BYTES_PER_SEC_DISPLAY | varchar(39) | NO | The display value of the data input rate in bytes per second. |
| OUTPUT_BYTES_PER_SEC_DISPLAY | varchar(39) | NO | The display value of the data output rate in bytes per second. |
| TIME_TAKEN_DISPLAY | time(6) | NO | The time consumed, in the format of hh:mm:ss. |
| START_REPLAY_LOG_TS | bigint(20) | NO | The minimum value of the log timestamp on which data backup depends. |
| DATE | bigint(20) | NO | The date when the data backup was created. |