Purpose
The 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 | NUMBER(38) | NO | The ID of the log archiving destination. |
| LS_ID | NUMBER(38) | NO | The ID of the log stream. |
| ROUND_ID | NUMBER(38) | NO | The round ID of the log stream. |
| PIECE_ID | NUMBER(38) | NO | The ID of the latest piece. |
| INCARNATION | NUMBER(38) | NO | The ID of the incarnation. |
| START_SCN | NUMBER(38) | NO | The start SCN of log archiving. |
| MIN_LSN | NUMBER(38) | NO | The minimum LSN of the log stream of the current piece. |
| MAX_LSN | NUMBER(38) | NO | The maximum LSN of the log stream of the current piece. |
| CHECKPOINT_SCN | NUMBER(38) | NO | The maximum archive checkpoint of the log stream of the current piece. |
| STATUS | VARCHAR2(64) | NO | The archiving status. |
| FILE_ID | NUMBER(38) | NO | The ID of the largest archive file of the current piece. |
| FILE_OFFSET | NUMBER(38) | NO | The offset of the largest archive file of the current piece. |
| INPUT_BYTES | NUMBER(38) | NO | The volume of log data that has been read. |
| OUTPUT_BYTES | NUMBER(38) | NO | The volume of log data that has been archived. |