Note
This view is available starting with V4.0.0.
Purpose
This view displays the status of all log archives for the current and historical tenants. 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 path. |
| ROUND_ID | bigint(20) | NO | The ID of a complete clog backup data stream. |
| INCARNATION | bigint(20) | NO | The number of incarnations after a flashback database operation. |
| 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 log archive. 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 the current round. |
| USED_PIECE_ID | bigint(20) | NO | The ID of the last PIECE used in the current round. |
| PIECE_SWITCH_INTERVAL | bigint(20) | NO | The interval between piece switches. |
| UNIT_SIZE | bigint(20) | NO | The size of a single log block that is compressed or encrypted in a log archive. This field is not supported. |
| COMPRESSION | varchar(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | bigint(20) | NO | The size of the data read, in bytes. |
| INPUT_BYTES_DISPLAY | varchar(27) | NO | The size of the data read, with the unit specified. For example: 798.01 M or 5.25 G. |
| OUTPUT_BYTES | bigint(20) | NO | The size of the data output, in bytes. |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The size of the data output, with the unit specified. For example: 798.01 M or 5.25 G. |
| COMPRESSION_RATIO | decimal(23,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, with the unit specified. Valid values: MB, GB, TB, and 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, with the unit specified. Valid values: MB, GB, TB, and PB. |
| PATH | varchar(2048) | NO | The archive path. |
| COMMENT | varchar(262144) | NO | The error message. |