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 the 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. |
| PIECE_ID | bigint(20) | NO | The ID of the backup log piece. |
| INCARNATION | bigint(20) | NO | The number of incarnations after Flashback Database. |
| DEST_NO | bigint(20) | NO | The ID of log_archive_dest_n. 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 SCN of the piece. |
| START_SCN_DISPLAY | datetime(6) | NO | The start time of the piece after the START_SCN is converted to a time unit. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archive SCN. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The archive time after the CHECKPOINT_SCN is converted to a time unit. |
| MAX_SCN | bigint(20) unsigned | NO | The maximum archive SCN. |
| END_SCN | bigint(20) unsigned | NO | The theoretical end SCN of the piece. |
| END_SCN_DISPLAY | datetime(6) | NO | The end time of the piece. |
| 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 at a time. 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, in bytes. |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The size of the effective data after the unit is converted. |
| COMPRESSION_RATIO | decimal(23,2) | NO | The compression ratio. |
| FILE_STATUS | varchar(64) | NO | The file status of the backup log piece. Valid values:
|
| PATH | varchar(2048) | NO | The archive path. |
References
For more information about pieces, see Overview of log archiving.