Note
This view is available starting with V4.0.0.
Overview
Displays the status of pieces in the backup set of the current tenant. The sys tenant and Meta tenant do not support physical backup.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| DEST_ID | bigint(20) | NO | Path number. The system assigns a unique ID to each configured path. |
| ROUND_ID | bigint(20) | NO | Identifies the round of the complete clog backup data stream. |
| PIECE_ID | bigint(20) | NO | Backup log shard ID |
| INCARNATION | bigint(20) | NO | Indicates the number of forks after the database is flashed back |
| DEST_NO | bigint(20) | NO | Identifies the log_archive_dest_n, for example, log_archive_dest_0 indicates that dest_no is 0, and log_archive_dest_1 indicates that dest_no is 1. |
| STATUS | varchar(64) | NO | Status of the piece: ACTIVE: The current active piece. FREEZING: The piece is being frozen. FROZEN: The piece has been frozen. After reaching this state, the piece's status will not change. |
| START_SCN | bigint(20) unsigned | NO | Actual Start Offset of Piece |
| START_SCN_DISPLAY | datetime(6) | NO | Display of START_SCN converted to a time unit |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | Current Archive Point |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | Display after converting CHECKPOINT_SCN to a time unit |
| MAX_SCN | bigint(20) unsigned | NO | Maximum Archive Timestamp |
| END_SCN | bigint(20) unsigned | NO | Theoretically final offset of the piece |
| END_SCN_DISPLAY | datetime(6) | NO | End time of the piece |
| COMPATIBLE | bigint(20) | NO | Compatible version number for log archiving |
| UNIT_SIZE | bigint(20) | NO | The size of a log block that is compressed or encrypted during log archiving. This field is not supported. |
| COMPRESSION | varchar(128) | NO | Compression algorithm:
|
| INPUT_BYTES | bigint(20) | NO | Original data volume, in bytes |
| INPUT_BYTES_DISPLAY | varchar(27) | NO | Display after converting the unit of INPUT_BYTES |
| OUTPUT_BYTES | bigint(20) | NO | The amount of encrypted and compressed data, in bytes |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | Display of OUTPUT_BYTES after unit conversion |
| COMPRESSION_RATIO | decimal(23,2) | NO | Compression Ratio |
| FILE_STATUS | varchar(64) | NO | File status of the backed-up log shard: AVAILABLE: The backup is valid and can be used for restoration. COPYING: The log file is being backed up. INCOMPLETE: The logs under the piece are incomplete, missing some log streams. DELETING: The log file is being deleted. EXPIRED: The backup file has expired. BROKEN: The backup file is incomplete and unusable. DELETED: The log file has been deleted. |
| PATH | varchar(2048) | NO | Archive Path |
References
For more information about pieces, see Log archiving overview.