Note
This view is available starting with V4.0.0.
Overview
Displays the log archiving status for each path in each tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| 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 |
Sample query
The system tenant queries the log archiving status of the tenant with ID 1002.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG WHERE TENANT_ID = 1002\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 1
INCARNATION: 1
DEST_NO: 0
STATUS: DOING
START_SCN: 1736228322307513000
START_SCN_DISPLAY: 2025-01-07 13:38:42.307513
CHECKPOINT_SCN: 1736232524851954000
CHECKPOINT_SCN_DISPLAY: 2025-01-07 14:48:44.851954
COMPATIBLE: 1
BASE_PIECE_ID: 1
USED_PIECE_ID: 1
PIECE_SWITCH_INTERVAL: 86400000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 82476454
INPUT_BYTES_DISPLAY: 78.66MB
OUTPUT_BYTES: 82476454
OUTPUT_BYTES_DISPLAY: 78.66MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
COMMENT:
PATH: file:///home/admin/oceanbase/arglog
1 row in set
References
For detailed operations and information about log archiving, see Log archiving.