Difference between revisions of "Checking HANA DB replication status"
From Notes_Wiki
m |
m |
||
Line 14: | Line 14: | ||
#:</pre> | #:</pre> | ||
#: We can get more help via '<tt>sapcontrol -h</tt>' | #: We can get more help via '<tt>sapcontrol -h</tt>' | ||
#: '<tt>HDB start</tt>' is used to start the DB and '<tt>HDB stop</tt>' is used to stop the DB. These internally call sapcontrol appropriately to start/stop DB. See https://blogs.sap.com/2017/11/28/sap-hana-under-the-hood-hdb-by-the-sap-hana-academy/ | |||
# First we can check which machine is primary and which is secondary via: | # First we can check which machine is primary and which is secondary via: | ||
#:<pre> | #:<pre> |
Revision as of 04:22, 21 July 2022
Home > Suse > SAP setup and maintenance > Checking HANA DB replication status
The HANA database would have a ID such as ABC. In that case use following steps to check database replication status
- Login into both primary and secondary servers as root
- Connect to DB admin account on both machines using
- su - <abc>adm
- where <abc> should be replaced with HANA DB ID
- Check whether database is running using:
- HDB info
- sapcontrol -nr 00
- We can get more help via 'sapcontrol -h'
- 'HDB start' is used to start the DB and 'HDB stop' is used to stop the DB. These internally call sapcontrol appropriately to start/stop DB. See https://blogs.sap.com/2017/11/28/sap-hana-under-the-hood-hdb-by-the-sap-hana-academy/
- First we can check which machine is primary and which is secondary via:
- hdbnsutil -sr_state
- Then check replication status using:
- cd /usr/sap/<ABC>/HDB10/exe/python_support
- python systemReplicationStatus.py
- where <ABC> should be replaced with HANA DB ID
Home > Suse > SAP setup and maintenance > Checking HANA DB replication status