LMV_REPLICATION_STATUS
This view provides the replication status of every replication link on a single node. This view can be accessed from any node in the cluster.
Column name | Description |
---|---|
| Specifies if the row corresponds to a DR replication link. |
| Specifies if the row corresponds to a synchronous replication link. |
| Specifies if the current node is the primary node or the secondary node in the replication link. |
| The name of the database in the current host. |
| The ID of the database in the current node. |
| The URI of the primary node in the replication link in the |
| The URI of the secondary node in the replication link in the |
| The replication state of the primary node. |
| The replication state of the secondary node. |
| The LSNs lagging to catch up with the primary cluster in the replication link of the nodes. |
| The volume of lag (in MB) in the replication link of the nodes. |
| The replication throughput between the nodes in the replication link. |
| The estimated catchup time (in seconds) between the nodes in the replication link. |