How to check HANA DB Sync (replication) between the primary system and secondary system
System Replication is in status ACTIVE and you would like to know the status of logs shipped from the primary system to secondary. There are two ways to check it, one by running SQL mini check, other through the hdbcons command.
1. Inorder to find whether the primary system and secondary system are in SYNC, you can run SQL minicheck "HANA_Replication_SystemReplication_Status.txt" attached to SAP Note 1969700.
Output be like:
|PATH |HOSTS |PORT |SHIP_DELAY_H|MODE |STATUS|STATUS_DETAILS |
-------------------------------------------------------------------------------------------------------
|ha1 -> ha2|saphana2100 -> saphana2101|30205| 1.46 |SYNCMEM|ERROR |Log shipping timeout occurred|
-------------------------------------------------------------------------------------------------------
From SHIP_DELAY_H value, you will know the interval for which logreplay has to happen in secondary system. So the changes in primary for that time (SHIP_DELAY_H) are still needed to be made in secondary