Skip to Content

Upgrade Hana Database to 2.0 in System replication scenario


We have to Perform Hana Database Upgrade from 1.0 SPS12 to 2.0 SP02, and we have

3-Tier System replication Configured.

I understand we have to start the upgrade from Tier-3 then Tier-2 and finally the Primary Server.

As per the Upgrade guide, we have to Disable replication before starting the upgrade.

And for disabling the replication ,we have to unregister the Secondary site.

Could you suggest if my below steps are fine for the upgrade.

Step1 :- Upgrade Tier-3 Server to Hana 2.0 SPS02

Step 2 :-To upgrade the Tier-2 Server, unregister Tier-3 and disable the replication on Tier-2,

Then perform the upgrade to 2.0 SPS02 and after this , register Tier-3 back.


Step 3 :- To Upgrade the Primary Server, Unregister Tier-2 and Tier-3 Servers ,disable the replication on Primary,

Then perform the upgrade to 2.0 SP02 and then register both Tier-2 Tier-3 Servers back again.

However as per sapnote :-1945676 :- Correct usage of hdbnsutil -sr_unregister,

we use the -sr_unregister only for 2 scenarios mentioned in the sapnote and not used otherwise(ex:- upgrade).

Please suggest



Ahmed Mohammed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 31, 2018 at 02:00 PM
    Add comment
    10|10000 characters needed characters exceeded

    • Hello

      From lower to higher versions replication is supported but from higher to lower versions replication is not supported.

      From 1999880 - FAQ: SAP HANA System Replication

      15. Is it supported to set up a replication scenario between systems with a different SAP HANA patch level?

      It is allowed to use different SAP HANA patch levels in a replication scenario as long as the patch level of the replicated system is not lower than the patch level of the primary system. It is also allowed that the replicated system is on a higher SPS level than the primary system. This possibility can be used for near zero downtime (NZDT) upgrades in replicated environments. For more information see the near zero downtime upgrade section in How to Perform System Replication for SAP HANA. SAP Note 2386973 describes NZDT upgrades in 3-tier system replication scenarios.

      Best regards