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.
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 the round of complete Clog backup data. |
| INCARNATION | bigint(20) | NO | The number of incarnations after the 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 start point of the backup. |
| START_SCN_DISPLAY | datetime(6) | NO | The start point of the backup, converted to a time unit. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archive point. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The current archive point, converted to a time unit. |
| 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 interval between piece switches. |
| UNIT_SIZE | bigint(20) | NO | The size of a single log block for compression or encryption in the 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. 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. For example: 798.01 M or 5.25 G. |
| COMPRESSION_RATIO | decimal(23,2) | NO | The compression ratio. This field is not supported by OceanBase Database. |
| 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, converted to 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, converted to MB, GB, TB, or PB. |
| PATH | varchar(2048) | NO | The archive path. |
| COMMENT | varchar(262144) | NO | The error message. |
Sample query
Query the status of all log archives for the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_ARCHIVELOG_SUMMARY\G
The query result is as follows:
*************************** 1. row ***************************
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: 1736233725601484000
CHECKPOINT_SCN_DISPLAY: 2025-01-07 15:08:45.601484
COMPATIBLE: 1
BASE_PIECE_ID: 1
USED_PIECE_ID: 1
PIECE_SWITCH_INTERVAL: 86400000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 85762972
INPUT_BYTES_DISPLAY: 81.79MB
OUTPUT_BYTES: 85762972
OUTPUT_BYTES_DISPLAY: 81.79MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///home/admin/oceanbase/arglog
COMMENT:
1 row in set