Note
This view is available starting with V4.0.0.
Purpose
This view displays the log archive status on each path for 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 identifier. |
| ROUND_ID | bigint(20) | NO | The backup round number. |
| INCARNATION | bigint(20) | NO | The number of times the database has been flashbacked. |
| DEST_NO | bigint(20) | NO | The log_archive_dest_n identifier. |
| STATUS | varchar(64) | NO | The archive status. Valid values:
|
| START_SCN | bigint(20) unsigned | NO | The starting backup SCN. |
| START_SCN_DISPLAY | datetime(6) | NO | The time corresponding to START_SCN. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archive SCN. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The time corresponding to CHECKPOINT_SCN. |
| COMPATIBLE | bigint(20) | NO | The compatibility version. |
| BASE_PIECE_ID | bigint(20) | NO | The ID of the first PIECE in this round. |
| USED_PIECE_ID | bigint(20) | NO | The ID of the PIECE used in this round. |
| PIECE_SWITCH_INTERVAL | bigint(20) | NO | The piece switching cycle. |
| UNIT_SIZE | bigint(20) | NO | The size of a single log block that is compressed or encrypted in one archive operation. This field is not supported. |
| COMPRESSION | varchar(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | bigint(21) | NO | The size of the data read, in bytes. |
| INPUT_BYTES_DISPLAY | varchar(28) | NO | The size of the data read, in MB, GB, TB, or PB. |
| OUTPUT_BYTES | bigint(21) | NO | The size of the data output, in bytes. |
| OUTPUT_BYTES_DISPLAY | varchar(28) | NO | The size of the data output, in MB, GB, TB, or PB. |
| COMPRESSION_RATIO | decimal(24,2) | NO | The compression ratio. This field is not supported. |
| DELETED_INPUT_BYTES | bigint(20) | NO | The size of the original data deleted, in bytes. |
| DELETED_INPUT_BYTES_DISPLAY | varchar(27) | NO | The size of the original data deleted, in MB, GB, TB, or PB. |
| DELETED_OUTPUT_BYTES | bigint(20) | NO | The size of the effective data deleted, in bytes. |
| DELETED_OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The size of the effective data deleted, in MB, GB, TB, or PB. |
| COMMENT | varchar(262144) | NO | The error message. |
| PATH | varchar(2048) | NO | The archive path. |
References
For more information about log archive, see Log archive.