GV$OB_LS_LOG_TRANSPORT_STAT

Overview

The GV$OB_LS_LOG_TRANSPORT_STAT view displays the transmission status of logs pushed from each log stream (LS) to a standby database on all nodes of a tenant in strong sync mode. To query this view, you must log in as the primary tenant (or the sys tenant of the cluster where the primary tenant resides).

Columns

Sample query

In the primary tenant, query the transmission status of logs pushed by each log stream on all nodes of the tenant to the standby tenant.

1. Confirm the synchronization mode of the primary tenant LS.

   obclient(root@oracle001)[SYS]> SELECT SVR_IP, SVR_PORT, LS_ID, ROLE, SYNC_MODE FROM SYS.GV$OB_LOG_STAT WHERE ROLE = 'LEADER';
   

   The query result is as follows:

   +-------------+----------+-------+--------+-----------+
   | SVR_IP      | SVR_PORT | LS_ID | ROLE   | SYNC_MODE |
   +-------------+----------+-------+--------+-----------+
   | 6.xx.xxx.91 |     2882 |     1 | LEADER | SYNC      |
   | 6.xx.xxx.91 |     2882 |  1001 | LEADER | SYNC      |
   +-------------+----------+-------+--------+-----------+
   2 rows in set
   

   If the result is SYNC, it indicates that the current tenant's log stream synchronization mode is strong sync.

2. Query the transmission status of each log stream from all nodes of the primary tenant to the standby tenant.

   obclient(root@oracle001)[SYS]> SELECT SVR_IP, SVR_PORT, LS_ID, ROLE, ENABLED, 
       END_LSN, LAST_SENT_LSN, STANDBY_END_LSN, STANDBY_ADDR
       FROM SYS.GV$OB_LS_LOG_TRANSPORT_STAT WHERE ROLE = 'LEADER';
   

   The query result is as follows:

   +-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   | SVR_IP      | SVR_PORT | LS_ID | ROLE   | ENABLED | END_LSN   | LAST_SENT_LSN | STANDBY_END_LSN | STANDBY_ADDR      |
   +-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   | 6.xx.xxx.91 |     2882 |     1 | LEADER |       1 | 305150963 |     305150963 |       305150963 | 6.xx.xxx.160:2882 |
   | 6.xx.xxx.91 |     2882 |  1001 | LEADER |       1 | 201294294 |     201294294 |       201294294 | 6.xx.xxx.160:2882 |
   +-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   2 rows in set