Set Up SAP HANA System Replication with the SAP HANA

HANA System Replication is one of the important topic in SAP HANA.
Being used in the context of high availability and disaster recovery scenario, It is really important to learn how to setup HANA System Replication in multi-tier replication scenario.

 

In this scenario we are enabling HANA System Replication – In Multi-tier scenario.

 

There are 3 HANA nodes: A, B and C, named SiteA, SiteB and SiteC
Site A : Primary Database Node
Site B: Secondary Database Node / HA Node
Site C: DR node

  • Replication Mode:
    From Site A –> Site B : SYNC
    From Site B –> Site C : ASYNC
  • Operation Mode:
    From Site A –> Site B : logreplay
    From Site B –> Site C : logreplay

           

HSR Scenario: HANA System Replication

Prerequisites:

  • Install HANA on primary and secondary node
                  With different host names
                  With same HANA system ID
                  With same instance number
                   Start up each HANA independently
  • Ensure, The primary and secondary system are both installed and configured properly. Do verify that both are independently up and running fine without any issue
  • Ensure, that the host-names in the primary system are different from the host-names used in the secondary systems.
  • Ensure, The secondary system must have the same SAP system ID,<SID> and instance number as the primary system.
  • Ensure, The software version of the secondary has to be equal or newer to the version on the primary system
  • Ensure that the following configuration parameters are set
    ini
    [persistence] log_mode = normal
  • Do prepare the secondary system by copying the system SSFS keys from the primary system to the secondary system.
    Manually copy SSFS_<SID>.DAT and SSFS_<SID>.KEY from primary host to secondary host.
    These files are in path /<SID>/global/security/rsecssfs/data and /<SID>/global/security/rsecssfs/key respectively

 

 

HANA System Replication : Primary Node: Site A Configuration

 

[Node A] start database : HDB start or /usr/sap/hostctrl/exe/sapcontrol -nr <instance number> -function Start
[Node A] create data backup
[Node A] enable system replication: hdbnsutil -sr_enable –name=SiteA
[Node A] verify the HSR state : hdbnsutil -sr_state

 

HANA System Replication : Secondary Node- HA Node: Site B Configuration

 

[Node B] Stop Database : HDB stop or /usr/sap/hostctrl/exe/sapcontrol -nr <instance number> -function Stop

[Node B]Register site:
hdbnsutil -sr_register –mode=sync –name=SiteB –remoteInstance=<instId> –remoteHost=<hostname_of_A> –operationMode=logreplay
[Node B] start database : HDB start or /usr/sap/hostctrl/exe/sapcontrol -nr <instance number> -function Start
[Node B] enable this site as replication source system: hdbnsutil -sr_enable
[Node B] verify the HSR state : hdbnsutil -sr_state

 

HANA System Replication : DR Node- : Site C Configuration

 

[Node C] Stop database: HDB stop or /usr/sap/hostctrl/exe/sapcontrol -nr <instance number> -function Stop

[Node C] Register tier 3 secondary:
hdbnsutil -sr_register –mode=async –name=SiteC –remoteInstance=<instId> –remoteHost=<hostname_of_B> –operationMode=logreplay
[Node C] start database : HDB start or /usr/sap/hostctrl/exe/sapcontrol -nr <instance number> -function Start

[Node C] verify the HSR state : hdbnsutil -sr_state

 

Reference command in case of change in replication mode and operation mode :

hdbnsutil -sr_register –name=<secondary_alias> –remoteHost=<primary_host> –remoteInstance=<primary_systemnr>
–replicationMode=[sync|syncmem|async] –operationMode=[delta_datashipping|logreplay|logreplay_readaccess]

 

Check if everything went fine by issuing SELECT * FROM M_SERVICE_REPLICATION on the primary site:

 

For More detail about Replication Mode:

Replication Modes between Sites : HANA Replication

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *