V$OB_LS_LOG_TRANSPORT_STAT

Overview

The V$OB_LS_LOG_TRANSPORT_STAT view displays the transmission status of logs pushed from each log stream (LS) to a standby database in strong sync mode for the current node of a tenant. 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 the current node to the standby tenant.

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

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

   The query result is as follows:

   +-------+--------+-----------+
   | LS_ID | ROLE   | SYNC_MODE |
   +-------+--------+-----------+
   |     1 | LEADER | SYNC      |
   |  1001 | LEADER | SYNC      |
   +-------+--------+-----------+
   2 rows in set
   

   The result SYNC 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 LS_ID, ROLE, ENABLED, 
       END_LSN, LAST_SENT_LSN, STANDBY_END_LSN, STANDBY_ADDR
       FROM SYS.V$OB_LS_LOG_TRANSPORT_STAT WHERE ROLE = 'LEADER';
   

   The query result is as follows:

   +-------+--------+---------+-----------+---------------+-----------------+-------------------+
   | LS_ID | ROLE   | ENABLED | END_LSN   | LAST_SENT_LSN | STANDBY_END_LSN | STANDBY_ADDR      |
   +-------+--------+---------+-----------+---------------+-----------------+-------------------+
   |     1 | LEADER |       1 | 305300441 |     305300441 |       305300441 | 6.xx.xxx.160:2882 |
   |  1001 | LEADER |       1 | 201421647 |     201421647 |       201421647 | 6.xx.xxx.160:2882 |
   +-------+--------+---------+-----------+---------------+-----------------+-------------------+
   2 rows in set