Checking HANA DB replication status

From Notes_Wiki
Revision as of 04:18, 21 July 2022 by Saurabh (talk | contribs)

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

  1. Login into both primary and secondary servers as root
  2. Connect to DB admin account on both machines using
    su - <abc>adm
    where <abc> should be replaced with HANA DB ID
  3. Check whether database is running using:
    HDB info
    sapcontrol -nr 00
    We can get more help via 'sapcontrol -h'
  4. First we can check which machine is primary and which is secondary via:
    hdbnsutil -sr_state
  5. 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