Skip to Content
Author's profile photo Denys van Kempen

SAP HANA SPS 12 What’s New: High Availability and Disaster Recovery – by the SAP HANA Academy


In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 12.

The topic of this blog is high availability and disaster recovery.

For the complete list of blogs see: What’s New with SAP HANA SPS 12 – by the SAP HANA Academy

For the SPS 11 version, see SAP HANA SPS 11 What’s New: HA/DR – by the SAP HANA Academy

Tutorial Video

SAP HANA Academy – SAP HANA SPS 12: What’s New? – High Availability and Disaster Recovery – YouTube

What’s New?

Monitoring System Replication with the SAP HANA cockpit

The System Replication tile in the SAP HANA cockpit now displays the operation mode, together with replication mode, tiers and status.


The overview page of the System Replication app displays (configurable) information for both primary and secondary sites, a performance graph with network statistics and a tile for Alerts, that links back to the Alerts app in the SAP HANA cockpit. From the status bar, the Log File Viewer can be opened.


The System Replication Details view displays information on the operation mode, the replayed log position, as well as the replayed log position time.


In a system replication scenario, the SAP HANA Cockpit for Offline Administration can be used to perform a takeover from the primary side by the secondary site.


System Replication Alerts

A new alert (#94 – Log replay backlog for system replication secondary) is raised when the system replication log replay backlog is increased. Thresholds and schedule are configurable.


Monitoring System Parameter Changes

The configuration parameter checker reports on any differences between primary, secondary, and – new for SPS 12 – tier-3 secondary systems. Also new with SPS 12 is that you can now replicate the system (or .ini file) parameters based on alerts. The parameter replication can be enabled to all sites.


enable = true

replicate = true


Initializing the Secondary

Apart from using a full data backup, it is now possible to initialize the secondary system using a binary storage copy, that is, either a snapshot or a full offline database copy.

Alerting of Secondary Systems

The Alerts app of the SAP HANA cockpit now also displays alerts issued by secondary system hosts.

Supported Replication Modes Between Sites

In a multitier system replication scenario, support for ASYNC replication has been extended with both SYNCMEM and SYNC. In other words, all replication modes are supported for all sites.


For more information see:

SAP Help Portal

SAP Notes

SCN Blogs

Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at

Follow us on Twitter @saphanaacademy.

Connect with us on


Thank you for watching

The SAP HANA Academy provides free online video tutorials for the developers, consultants, partners and customers of SAP HANA.

Topics range from practical how-to instructions on administration, data loading and modeling, and integration with other SAP solutions, to more conceptual projects to help build out new solutions using mobile applications or predictive analysis.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy.

For the full list of blogs, see Blog Posts – by the SAP HANA Academy.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Derbal Billel
      Derbal Billel

      Hi Denys

      Thank you for sharing the information about what's new in HA&DR for SAP Hana SPS12.

      It would be very Helpfull/interesting to have a more information "Video, Tutorial...etc" on how to initialize the secondary site using the a snapshot "the new feature of system replication in SPS12"

      Best Regards.

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author


      Thanks for the suggestion. I will put it on the list.

      Author's profile photo Khadar Mohideen
      Khadar Mohideen

      Hi Denys,

      Good Day!

      Is this possible to replicate the HANA DB from SPS 12 to SPS10 vice-versa SPS 10 to SPS 12?



      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Khadar,

      Replication between different patch (or SPS) level is supported as this is used for near-zero downtime (NZDT) upgrades. See, note 1999880 - FAQ: SAP HANA System Replication:

      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.

      So this would concern SPS 10 (primary) -> SPS 12 (secondary) and address a particular business need (NZDT).

      Vice-versa would not work.

      To replicate data between two systems of different releases both ways, you could consider the regular replication technologies (SLT, Data Services, etc.).


      Denys / SAP HANA Academy

      Subscribe to our YouTube Channel
      Join us on LinkedIn
      Follow us on Twitter
      Github code samples


      Author's profile photo Former Member
      Former Member

      Hi denys van kempen,





      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Mukunthan,

      Having troubles with Caps Lock?  ?

      Host automatic-failover enables you, on a distributed system, to automatically startup the standby instance when one of the active instances fails.

      Using system replication, you can automate automatic takeover on the secondary site in case the primary site fails.

      These are two different concepts. If you are new to the topic of system replication, you might find the overview video of interest:

      It was recorded for SPS 09 but the concepts have not changed.