Purpose
The oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS view displays the log archiving progress of the current tenant.
Note
This view is introduced since OceanBase Database V4.1.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| DEST_ID | bigint(20) | NO | The ID of the log archiving destination. |
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| ROUND_ID | bigint(20) | NO | The round ID of the log stream. |
| PIECE_ID | bigint(20) | NO | The ID of the latest piece. |
| INCARNATION | bigint(20) | NO | The ID of the incarnation. |
| START_SCN | bigint(20) unsigned | NO | The start SCN of log archiving. |
| MIN_LSN | bigint(20) unsigned | NO | The minimum LSN of the log stream of the current piece. |
| MAX_LSN | bigint(20) unsigned | NO | The maximum LSN of the log stream of the current piece. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The maximum archive checkpoint of the log stream of the current piece. |
| STATUS | varchar(64) | NO | The archiving status. |
| FILE_ID | bigint(20) | NO | The ID of the largest archive file of the current piece. |
| FILE_OFFSET | bigint(20) | NO | The offset of the largest archive file of the current piece. |
| INPUT_BYTES | bigint(20) | NO | The volume of log data that has been read. |
| OUTPUT_BYTES | bigint(20) | NO | The volume of log data that has been archived. |