Note
This view is available starting with V4.0.0.
Overview
Displays the log archiving status for each path in the current tenant. The sys tenant and Meta tenant do not support physical backup.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| DEST_ID | bigint(20) | NO | Path Identifier |
| ROUND_ID | bigint(20) | NO | Indicates the round of backup. |
| INCARNATION | bigint(20) | NO | Indicates the number of forks after the database is flashed back |
| DEST_NO | bigint(20) | NO | Identifies log_archive_dest_n |
| STATUS | varchar(64) | NO | Archive Status:
|
| START_SCN | bigint(20) unsigned | NO | Start Backup Point |
| START_SCN_DISPLAY | datetime(6) | NO | Display of START_SCN converted to a time unit |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | Current Archive Point |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | Display after converting CHECKPOINT_SCN to a time unit |
| COMPATIBLE | bigint(20) | NO | Compatible Versions |
| BASE_PIECE_ID | bigint(20) | NO | The first PIECE ID of this round |
| USED_PIECE_ID | bigint(20) | NO | PIECE ID Used in This Round |
| PIECE_SWITCH_INTERVAL | bigint(20) | NO | Piece Switching Cycle |
| UNIT_SIZE | bigint(20) | NO | The size of a log block that is compressed or encrypted during log archiving. This field is not supported. |
| COMPRESSION | varchar(128) | NO | Compression algorithm:
|
| INPUT_BYTES | bigint(21) | NO | Volume of data read, in bytes |
| INPUT_BYTES_DISPLAY | varchar(28) | NO | Displays the value of INPUT_BYTES after unit conversion. The supported units are MB, GB, TB, and PB. OceanBase Database does not support this field. |
| OUTPUT_BYTES | bigint(21) | NO | Output data volume, in bytes |
| OUTPUT_BYTES_DISPLAY | varchar(28) | NO | Displays the converted value of OUTPUT_BYTES in one of the following units: MB, GB, TB, or PB. OceanBase Database does not support this field. |
| COMPRESSION_RATIO | decimal(24,2) | NO | Compression ratio. OceanBase Database does not support this field. |
| DELETED_INPUT_BYTES | bigint(20) | NO | The amount of original data deleted, in bytes |
| DELETED_INPUT_BYTES_DISPLAY | varchar(27) | NO | The value of DELETED_INPUT_BYTES is displayed in one of the following units: MB, GB, TB, or PB. |
| DELETED_OUTPUT_BYTES | bigint(20) | NO | The amount of valid data deleted, in bytes |
| DELETED_OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The display format for the converted value of DELETED_OUTPUT_BYTES, which can be one of the following: MB, GB, TB, or PB. |
| COMMENT | varchar(262144) | NO | Display an error message |
| PATH | varchar(2048) | NO | Archive Path |
References
For detailed operations and information about log archiving, see Log Archiving.