Note
This view is available starting with V4.0.0.
Purpose
This view displays the log archiving status of each path in the current tenant. Physical backup is not supported for the sys tenant and 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 incarnations after Flashback Database. |
| DEST_NO | bigint(20) | NO | The log_archive_dest_n identifier. |
| STATUS | varchar(64) | NO | The archiving status. Valid values:
|
| START_SCN | bigint(20) unsigned | NO | The start backup point. |
| START_SCN_DISPLAY | datetime(6) | NO | The start backup point converted into a time unit. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archiving point. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The current archiving point converted into a time unit. |
| 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 PIECE used in the current 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 log archiving operation. This field is not supported in OceanBase Database. |
| COMPRESSION | varchar(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | bigint(21) | NO | The amount of data read. This field is not supported in OceanBase Database. |
| INPUT_BYTES_DISPLAY | varchar(28) | NO | The amount of data read, converted into a unit of MB, GB, TB, or PB. This field is not supported in OceanBase Database. |
| OUTPUT_BYTES | bigint(21) | NO | The amount of data output. This field is not supported in OceanBase Database. |
| OUTPUT_BYTES_DISPLAY | varchar(28) | NO | The amount of data output, converted into a unit of MB, GB, TB, or PB. This field is not supported in OceanBase Database. |
| COMPRESSION_RATIO | decimal(24,2) | NO | The compression ratio. This field is not supported in OceanBase Database. |
| 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. |
| 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. |
| COMMENT | varchar(262144) | NO | The error message. |
| PATH | varchar(2048) | NO | The archiving path. |