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:
NORMAL: Logs are synchronized properly.SOURCE HAS A GAP: The log source has a gap in logs.STANDBY LOG NOT MATCH: A restored log conflicts with a log in the standby database. For example, a log in the standby database is different from the log that has the same LSN in the log source.CHECK USER OR PASSWORD: The log source cannot be accessed because the copied username or password of the account is incorrect.CHECK NETWORK: The log source is unreachable because an incorrect access IP address or port number is specified for the tenant.FETCH LOG TIMEOUT: A log pull task timed out.RESTORE SUSPEND: Logs have been synchronized to the specified maximum synchronization timestamp.STANDBY NEED UPGRADE: The version of the standby database is earlier than that of the primary database, and must be upgraded.CHECK PRIMARY ALIVE: The primary database cannot be accessed. In this case, check whether the primary database has been deleted.NOT AVAILABLE: Log synchronization is unavailable due to other exceptions. |
| 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. |
