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. |