Purpose
oceanbase.CDB_OB_BACKUP_SET_FILES displays the file status of backup sets.
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 copy ID of the backup set. |
| BACKUP_TYPE | varchar(1) | NO | The type of the backup. Valid values: D: indicates full backup.I: indicates incremental backup. |
| ENCRYPTION_MODE | varchar(64) | NO | The encryption mode. Valid values: 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 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. |
| STATUS | varchar(64) | NO | The backup status. |
| FILE_STATUS | varchar(64) | NO | The file status of the backup set. Valid values: COPYING: indicates that the file is being backed up.AVAILABLE: indicates that the backup is valid.DELETING: indicates that the file is being deleted.EXPIRED: indicates that the backup file has expired.INCOMPLETE: indicates that the backup file is incomplete.BROKEN: indicates that the backup file is incomplete and cannot be used.DELETED: indicates that the backup file has been deleted. |
| START_TIME | timestamp(6) | NO | The start time of the backup. |
| COMPLETION_TIME | timestamp(6) | NO | The completion time of the backup. |
| ELAPSED_SECONDES | decimal(22,0) | NO | The time consumed for the backup. |
| KEEP | varchar(2) | NO | Indicates whether the backup set is kept. Valid values: YES: indicates that the backup set will be kept permanently.NO: indicates that the backup set will expire based on the retention time. |
| KEEP_UNTIL | varchar(0) | NO | The duration for keeping the backup set. |
| COMPRESSED | varchar(2) | NO | Indicates whether the backup set is compressed. Valid values: YES: indicates that the backup set is compressed.NO: indicates that the backup set is not compressed. |
| OUTPUT_BYTES | bigint(20) | NO | The number of output bytes. |
| OUTPUT_RATE_BYTES | decimal(28,4) | NO | The number of bytes that are output per second. |
| COMPRESSION_RATIO | decimal(23,2) | NO | The compression ratio. |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The size of the output data with the unit of measurement, for example, 798.01 M or 5.25 G. |
| OUTPUT_RATE_BYTES_DISPLAY | varchar(33) | NO | The data output rate. |
| TIME_TAKEN_DISPLAY | time(6) | NO | The time consumed, in the format of hh:mm:ss. |