Overview
Displays the log stream archiving progress for the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| DEST_ID | bigint(20) | NO | Archive Destination ID |
| LS_ID | bigint(20) | NO | Log Stream ID |
| ROUND_ID | bigint(20) | NO | Log Stream Round ID |
| PIECE_ID | bigint(20) | NO | Latest Piece ID |
| INCARNATION | bigint(20) | NO | Avatar ID |
| START_SCN | bigint(20) unsigned | NO | Archive Start SCN |
| MIN_LSN | bigint(20) unsigned | NO | Minimum LSN of Current Piece Log Stream |
| MAX_LSN | bigint(20) unsigned | NO | Maximum LSN of Current Piece Log Stream |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | Maximum Archiving Progress of Current Piece Log Stream |
| STATUS | varchar(64) | NO | Archive Status |
| FILE_ID | bigint(20) | NO | Maximum Archived File ID of Current Piece |
| FILE_OFFSET | bigint(20) | NO | Maximum Archived File Offset for the Current Piece |
| INPUT_BYTES | bigint(20) | NO | Volume of log data read, in bytes |
| OUTPUT_BYTES | bigint(20) | NO | Volume of Archived Log Data, in Bytes |
Sample query
You can view the log stream archiving progress of the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS\G
The query result is as follows:
*************************** 1. row ***************************
DEST_ID: 1001
LS_ID: 1
ROUND_ID: 1
PIECE_ID: 1
INCARNATION: 1
START_SCN: 1736228322307513000
MIN_LSN: 67104768
MAX_LSN: 130864876
CHECKPOINT_SCN: 1736235046704454000
STATUS: DOING
FILE_ID: 2
FILE_OFFSET: 63760108
INPUT_BYTES: 63760108
OUTPUT_BYTES: 63760108
*************************** 2. row ***************************
DEST_ID: 1001
LS_ID: 1001
ROUND_ID: 1
PIECE_ID: 1
INCARNATION: 1
START_SCN: 1736228322307513000
MIN_LSN: 67104768
MAX_LSN: 92335200
CHECKPOINT_SCN: 1736235046402227000
STATUS: DOING
FILE_ID: 2
FILE_OFFSET: 25230432
INPUT_BYTES: 25230432
OUTPUT_BYTES: 25230432
2 rows in set