Administration and troubleshooting

Monitor the status of cluster

You can check the status of the cluster with the following command as root user:

root@prihana ~]# pcs status
Cluster name: rhelhanaha
Stack: corosync
Current DC: sechana (version 1.1.19-8.el7_6.5-c3c624ea3d) - partition with quorum
Last updated: Thu Nov 12 09:44:08 2020
Last change: Thu Nov 12 09:43:20 2020 by root via crm_attribute on sechana

2 nodes configured
6 resources configured

Online: [ prihana sechana ]

Full list of resources:

 clusterfence   (stonith:fence_aws):    Started prihana
 Clone Set: SAPHanaTopology_HDB_00-clone [SAPHanaTopology_HDB_00]
     Started: [ prihana sechana ]
 Master/Slave Set: SAPHana_HDB_00-master [SAPHana_HDB_00]
     Masters: [ prihana ]
     Slaves: [ sechana ]
 hana-oip       (ocf::heartbeat:aws-vpc-move-ip):       Started prihana

Daemon Status:
  corosync: active/enabled
  pacemaker: active/enabled
  pcsd: active/enabled
[root@prihana ~]#

You can check the SAP HANA replication status with the following command as a <sid>adm user:

hdbadm@prihana:/usr/sap/HDB/HDB00> python 
/usr/sap/HDB/HDB00/exe/python_support/systemReplicationStatus.py
| Database | Host       | Port  | Service Name | Volume ID | Site 
ID | Site Name  | Secondary  | Secondary | Secondary | Secondary    
| Secondary     | Replication | Replication | Replication    |
|          |            |       |              |           |         
|            | Host       | Port      | Site ID   | Site Name    | 
Active Status | Mode        | Status      | Status Details |
| -------- | ---------- | ----- | ------------ | --------- | ------- 
| ---------- | ---------- | --------- | --------- | ------------ 
| ------------- | ----------- | ----------- | -------------- |
| SYSTEMDB | prihana | 30001 | nameserver   |         1 |       1 | 
HDBPrimary | sechana |     30001 |         2 | HDBSecondary | YES           
| SYNCMEM     | ACTIVE      |           |
| HDB      | prihana | 30007 | xsengine     |         2 |       1 | 
HDBPrimary | sechana |     30007 |         2 | HDBSecondary | YES           
| SYNCMEM     | ACTIVE      |           |
| HDB      | prihana | 30003 | indexserver  |         3 |       1 | 
HDBPrimary | sechana |     30003 |         2 | HDBSecondary | YES           
| SYNCMEM     | ACTIVE      |           |

status system replication site "2": ACTIVE
overall system replication status: ACTIVE

Local System Replication State
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

mode: PRIMARY
site id: 1
site name: HDBPrimary
hdbadm@prihana:/usr/sap/HDB/HDB00>