Purpose
The V$OB_LS_LOG_RESTORE_STATUS view displays the log restore status at the log stream level.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| LS_ID | NUMBER(38) | NO | The ID of the log stream. |
| SYNC_LSN | NUMBER(38) | NO | The LSN of the maximum consecutive majority checkpoint of the standby database, also known as the maximum consumption checkpoint. |
| SYNC_SCN | NUMBER(38) | NO | The SCN of the maximum consecutive majority checkpoint of the standby database, also known as the maximum consumption checkpoint. |
| SYNC_STATUS | VARCHAR2(128) | NO | The restore status of the log stream. Valid values:
|
| ERR_CODE | NUMBER(38) | NO | The error code, which is 0 during normal synchronization. |
| COMMENT | VARCHAR2(2048) | NO | The error details. This column is empty during normal synchronization. |