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 | bigint(20) | NO | The ID of the tenant. |
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| SYNC_LSN | bigint(20) unsigned | NO | The LSN of the maximum consecutive majority checkpoint of the standby database, also known as the maximum consumption checkpoint. |
| SYNC_SCN | bigint(20) unsigned | NO | The SCN of the maximum consecutive majority checkpoint of the standby database, also known as the maximum consumption checkpoint. |
| SYNC_STATUS | varchar(128) | NO | The restore status of the log stream. Valid values:
|
| ERR_CODE | bigint(20) | NO | The error code, which is 0 during normal synchronization. |
| COMMENT | varchar(2048) | NO | The error details. This column is empty during normal synchronization. |