Note
This view is available starting with V4.2.0.
Purpose
This view displays the log restore status at the log stream level for the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| LS_ID | NUMBER(38) | NO | The log stream ID. |
| SYNC_LSN | NUMBER(38) | NO | The latest LSN of the majority of logs in the standby database. |
| SYNC_SCN | NUMBER(38) | NO | The latest SCN of the majority of logs in the standby database. |
| SYNC_STATUS | VARCHAR2(128) | NO | The log restore status. Valid values:
|
| ERR_CODE | NUMBER(38) | NO | The error code. This field is 0 during normal synchronization. |
| COMMENT | VARCHAR2(2048) | NO | The error details. This field is empty during normal synchronization. |
Sample query
Query the log restore status at the log stream level for the current user tenant.
obclient [SYS]> SELECT * FROM SYS.V$OB_LS_LOG_RESTORE_STATUS;
The query result is as follows:
+-----------+-------+-----------+---------------------+-------------+----------+---------+
| TENANT_ID | LS_ID | SYNC_LSN | SYNC_SCN | SYNC_STATUS | ERR_CODE | COMMENT |
+-----------+-------+-----------+---------------------+-------------+----------+---------+
| 1018 | 1 | 283804256 | 1736328456982102000 | NORMAL | 0 | |
| 1018 | 1001 | 196814299 | 1736328433807314000 | NORMAL | 0 | |
+-----------+-------+-----------+---------------------+-------------+----------+---------+
2 rows in set