Purpose
The oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS view displays the log archiving progress of all tenants. You can query this view only from the sys tenant.
Note
This view is introduced since OceanBase Database V4.1.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| 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. Valid values:
|
| 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. |