Purpose
oceanbase.CDB_OB_BACKUP_PIECE_FILES displays the status of backup pieces in each backup set.
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. |
| ROUND_ID | bigint(20) | NO | The nth complete clog backup data flow. |
| BACKUP_PIECE_ID | bigint(20) | NO | The ID of the log backup piece. |
| COPY_ID | bigint(20) | NO | The copy ID of the log backup piece. |
| CREATE_DATE | bigint(20) | NO | The date when the backup piece was created. |
| START_TS | varchar(26) | NO | The timestamp of when the log backup started. |
| CHECKPOINT_TS | varchar(26) | NO | The maximum timestamp of the committed transactions in the backup piece. The value is null for a backup piece in the ACTIVE state. |
| MAX_TS | varchar(26) | NO | The maximum timestamp of the log backup piece. The value is null for a backup piece in the ACTIVE or FREEZING state. |
| STATUS | varchar(64) | NO | The status of the piece when the log is split. Valid values: ACTIVE: The backup piece is active.FREEZING: The backup piece is being frozen.FROZEN: The backup piece is frozen. The status of a frozen piece no long changes. |
| FILE_STATUS | varchar(64) | NO | The file status of the backup piece. Valid values: AVAILABLE: indicates a valid backup that can be used for restoration.COPYING: indicates that the log file is being backed up.INCOMPELTE: indicates that only a portion of the log file has been copied. This status is applicable only in regular secondary backup of log backups. The value of checkpoint_ts for the copy is earlier than that for the original backup, and the copy can be used for restoring the file to a point in time before the value of checkpoint_ts of the copy.DELETING: indicates that the log file is being deleted.EXPIRED: indicates that the backup file has expired.BROKEN: indicates that the backup file is incomplete and cannot be used.DELETED: indicates that the log file has been deleted. |
| COMPATIBLE | bigint(20) | NO | The log version number supported by the log backup. |
| START_PIECE_ID | bigint(20) | NO | The ID of the first backup piece in the same log backup round. |