Skip to main content

Search

Welcome to Tibero GTS!

V$STANDBY_DEST GLOBAL_VIEW Feature Added

Document Type | Troubleshooting

Category | Administration

Applicable Product Version | 6FS06

Document Number | TADTS066

 

Issue

In an N-NODE TAC - TSC environment, there is an issue where it is difficult to check the log transmission and connection status of the relative node (PRIMARY 1 or PRIMARY 2) between instances.
 
 

Cause

There was no GLOBAL VIEW feature for V$STANDBY_DEST and V$STANDBY_STATUS.
 
 

Solutions

Apply patch FS06_325130a to resolve the issue.
Caution
Apply the patch through technical support provided by Tmax Tibero. 
In the TSC architecture, the GLOBAL VIEW feature has been added to the V$STANDBY_DEST view, allowing you to check the log transmission and connection status of the relative node of the instance.
---------------------------------------------------------------------------------------------------------------------
|INST_ID|    STANDBY_ADDR    | TYPE | THREAD# |     FLAGS     | SENT_SEQ |SENT_BLKNO|ACKED_SEQ|ACKED_BLKNO| DELAY |
---------------------------------------------------------------------------------------------------------------------
|     1 | 10.10.xx.x:1525    | LGWR |       0 |  CONNECTED     |   47636  |        0 |   47635 |     23138 |     0 |
|     1 | 10.10.xx.x:1525    | LGWR |       1 |NOT CONNECTED   |     -1   |      -1  |     -1  |       -1  |     0 |
|     1 | Not Assigned:0     | LGWR |   65535 |NOT CONNECTED   |     -1   |      -1  |     -1  |       -1  |     0 |
|     1 | Not Assigned:0     | LGWR |   65535 |NOT CONNECTED   |     -1   |      -1  |     -1  |       -1  |     0 |
|     1 | Not Assigned:0     | LGWR |   65535 |NOT CONNECTED   |     -1   |      -1  |     -1  |       -1  |     0 |
..
|     2 | 10.10.xx.x:1525    | LGWR |       1 |  CONNECTED     |   33531  |        0 |   33530 |      1466 |     0 |
|     2 | 10.10.xx.x:1525    | LGWR |       0 |NOT CONNECTED   |     -1   |      -1  |     -1  |       -1  |     0 |
|     2 | Not Assigned:0     | LGWR |   65535 |NOT CONNECTED   |     -1   |      -1  |     -1  |       -1  |     0 |
|     2 | Not Assigned:0     | LGWR |   65535 |NOT CONNECTED   |     -1   |      -1  |     -1  |       -1  |     0 |
|     2 | Not Assigned:0     | LGWR |   65535 |NOT CONNECTED   |     -1   |      -1  |     -1  |       -1  |     0 |
..
---------------------------------------------------------------------------------------------------------------------

Note

If the patch is not applied, you can check the connection status on each node (PRIMARY 1 or PRIMARY 2) using V$STANDBY_DEST and V$STANDBY_STATUS.

 

 

 

Related to