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 backups are 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 configured path. |
| ROUND_ID | bigint(20) | NO | The identifier of the round of complete clog backup data. |
| PIECE_ID | bigint(20) | NO | The ID of the backup log shard. |
| INCARNATION | bigint(20) | NO | The number of incarnations after Flashback Database. |
| DEST_NO | bigint(20) | NO | The identifier 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. |
| CREATE_TIMESTAMP | bigint(20) | NO | The time when the piece was created. |
| STATUS | varchar(64) | NO | The status of the piece: ACTIVE: the piece is active. FREEZING: the piece is being frozen. FROZEN: the piece has been frozen. After this status, the piece will no longer change. |
| START_SCN | bigint(20) unsigned | NO | The actual start point of the piece. |
| START_SCN_DISPLAY | datetime(6) | NO | The display of START_SCN converted to the time unit. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archive point. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The display of CHECKPOINT_SCN converted to the time unit. |
| 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 log archiving operation. This field is not supported. |
| COMPRESSION | varchar(128) | NO | The compression algorithm:
|
| INPUT_BYTES | bigint(20) | NO | The size of the original data. |
| INPUT_BYTES_DISPLAY | varchar(27) | NO | The display of INPUT_BYTES converted to the unit. |
| OUTPUT_BYTES | bigint(20) | NO | The size of the effective data after encryption and compression. |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The display of OUTPUT_BYTES converted to the unit. |
| COMPRESSION_RATIO | decimal(23,2) | NO | The compression ratio. |
| FILE_STATUS | varchar(64) | NO | The file status of the backup log shard: AVAILABLE: indicates a valid backup that can be used for restore. COPYING: indicates that the log file is being backed up. INCOMPELTE: indicates that the logs in the piece are incomplete and some log streams are missing. DELETING: the log file is being deleted. EXPIRED: indicates that the backup file has expired. BROKEN: the backup file is incomplete and cannot be used. DELETED: the log file has been deleted. |
| PATH | varchar(2048) | NO | The archive path. |