Note
This view is available starting with V4.0.0.
Purpose
This view displays the status of pieces in the backup set of the current tenant. Physical backup is not supported for the sys tenant and Meta tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| DEST_ID | bigint(20) | NO | The path ID. The system assigns a unique ID to each path. |
| ROUND_ID | bigint(20) | NO | The ID of the round of complete Clog backup data streams. |
| PIECE_ID | bigint(20) | NO | The ID of the backup log piece. |
| INCARNATION | bigint(20) | NO | The number of times the database has been flashbacked. |
| DEST_NO | bigint(20) | NO | The number of the log_archive_dest_n parameter. For example, the dest_no of log_archive_dest is 0, and the dest_no of log_archive_dest_1 is 1. |
| STATUS | varchar(64) | NO | The status of the piece. Valid values:
|
| START_SCN | bigint(20) unsigned | NO | The actual start point of the piece. |
| START_SCN_DISPLAY | datetime(6) | NO | The time corresponding to the START_SCN value. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archive point. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The time corresponding to the CHECKPOINT_SCN value. |
| MAX_SCN | bigint(20) unsigned | NO | The maximum archive point. |
| END_SCN | bigint(20) unsigned | NO | The theoretical end point of the piece. |
| END_SCN_DISPLAY | datetime(6) | NO | The time when the piece ends. |
| COMPATIBLE | bigint(20) | NO | The compatible version number of log archiving. |
| UNIT_SIZE | bigint(20) | NO | The size of a single log block that is compressed or encrypted in one operation. This column is not supported. |
| COMPRESSION | varchar(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | bigint(20) | NO | The size of the original data, in bytes. |
| INPUT_BYTES_DISPLAY | varchar(27) | NO | The size of the original data after the unit is converted. |
| OUTPUT_BYTES | bigint(20) | NO | The size of the effective data after encryption and compression. |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The size of the effective data after encryption and compression and the unit is converted. |
| COMPRESSION_RATIO | decimal(23,2) | NO | The compression ratio. This column is not supported. |
| FILE_STATUS | varchar(64) | NO | The status of the backup log piece file. Valid values:
|
| PATH | varchar(2048) | NO | The archive path. |
References
For more information about pieces, see Overview of log archiving.