Note
This view is available starting with V4.0.0.
Purpose
This view displays the status of all historical and current log archives 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 streams. |
| 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 archive status. Valid values:
|
| START_SCN | bigint(20) unsigned | NO | The start backup point. |
| START_SCN_DISPLAY | datetime(6) | NO | The start backup point converted to a time unit. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archive point. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The current archive point converted to a time unit. |
| COMPATIBLE | bigint(20) | NO | The compatibility version. |
| BASE_PIECE_ID | bigint(20) | NO | The ID of the first PIECE of the current round. |
| USED_PIECE_ID | bigint(20) | NO | The ID of the PIECE used in the current round. |
| PIECE_SWITCH_INTERVAL | bigint(20) | NO | The piece switch cycle. |
| UNIT_SIZE | bigint(20) | NO | The size of a single log block that is compressed or encrypted in the current round. This field is not supported. |
| COMPRESSION | varchar(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | bigint(20) | NO | The amount of data read. |
| INPUT_BYTES_DISPLAY | varchar(27) | NO | The amount of data read, with a unit. For example: 798.01 M or 5.25 G. |
| OUTPUT_BYTES | bigint(20) | NO | The amount of data output. |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The amount of data output, with a unit. For example: 798.01 M or 5.25 G. |
| COMPRESSION_RATIO | decimal(23,2) | NO | The compression ratio. |
| DELETED_INPUT_BYTES | bigint(20) | NO | The amount of original data deleted. |
| DELETED_INPUT_BYTES_DISPLAY | varchar(27) | NO | The amount of original data deleted, with a unit. Valid values: MB, GB, TB, and PB. |
| DELETED_OUTPUT_BYTES | bigint(20) | NO | The amount of effective data deleted. |
| DELETED_OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The amount of effective data deleted, with a unit. Valid values: MB, GB, TB, and PB. |
| PATH | varchar(2048) | NO | The archive path. |
| COMMENT | varchar(262144) | NO | The error message. |