Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Laszlo_Thoma
Product and Topic Expert
Product and Topic Expert
5,527

banner.png

last updated: 2024-02-01

Introduction
There is huge knowledge available about SAP HANA High Availability and Disaster Recovery topic, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). The aim of this article is simplify and make content consumption easier with a centralized page. There is no reason to duplicate the already well prepared content, so the goal is to collect the available knowledge and put it in a well structured format. The logic of the page follows the earlier published articles in the same series.

banner2.png

What is SAP HANA?

Table of Content (The internal links had been removed cause the new blogging platform only supports basic html, and the use of anchor links not supported.) 

  1. Definitions
  2. Where to find documentations in SAP Help Portal?
  3. Which other official documentations are important regarding SAP HANA HA and DR?
  4. Which are the master SAP Knowledge Base Articles of the SAP HANA HA and DR?
  5. White Paper
  6. Concept of the SAP HANA High Availability and Disaster Recovery features
  7. Which measures needs to be understand?
  8. Which license is required for SAP HANA System Replication?
  9. What is the general way to check the status of SAP HANA System Replication?
  10. What are the available tools for monitoring the SAP HANA System Replication?
  11. Which SAP HANA Alert IDs belongs to the topic?
  12. Which other documentations are important regarding SAP HANA HA and DR?
  13. What information is necessary to get support?
  14. What are the known issues?
  15. Disaster Recovery and High Availability for different SAP platforms
  16. SAP HANA Academy
  17. What blog posts can be helpful?
  18. Other articles in this series
  19. Other articles in connected series
  20. Useful bookmark

Definitions
To put the topic in context we need to understand general terms and meanings correctly.

  • Availability: is an industry term for the time during the IT system is available, online and operational.
  • Downtime: is an industry term for the time during the IT system is unavailable, offline or not operational. The downtime can be planned (e.g., maintenance events, such as OS or hardware upgrade, software patches, etc.) or unplanned (e.g., hardware failures, human errors, power outages, and cyberattacks, ending with bad design and/or configuration, disaster, etc.).
  • High Availability (HA): a highly available system aims to be online as often as possible. While downtime can still occur, but the duration of the downtime had minimized as possible.
  • Fault/Failure Tolerance: a fault tolerant system can operate through a fault without any downtime. The goal of fault tolerance is to eliminate downtime completely (as much as possible) within one data center.
  • Fault/Failure Recovery (FR): is the process of recovery and resuming system operations of a failed system after an outage/fault in a way that either eliminates or minimizes the amount of incorrect system results.
  • Disaster Tolerance: extended failover capabilities across datacenters (different geographical location).
  • Disaster Recovery (DR): is an ability to restore access and functionality to IT infrastructure after a disaster event, whether natural or caused by human action (or error). In general in case of IT system it means if one site fails the other site can continue the operation (the sites are in different locations).

IMPORTANT !
=================================================================

Where to find documentations in SAP Help Portal?

Which other official documentations are important regarding SAP HANA HA and DR?

Which are the master SAP Knowledge Base Articles of the SAP HANA HA and DR?

  • 2057595 - FAQ: SAP HANA High Availability
  • 1999880 - FAQ: SAP HANA System Replication
  • 1642148 - FAQ: SAP HANA Database Backup & Recovery
  • 2165547 - FAQ: SAP HANA Database Backup & Recovery in an SAP HANA System Replication Landscape

White Paper

  • 2407186 - How-To Guides & Whitepapers For SAP HANA High Availability

=================================================================

Concept of the SAP HANA High Availability and Disaster Recovery features
The below image shows the current SAP HANA capabilities from data center readiness perspective.

Image source: High Availability and Disaster Recovery with the SAP HANA Platform on openSAP

Reference: High Availability and Disaster Recovery with the SAP HANA Platform on openSAP

Which measures needs to be understand?
SAP HANA platform supports the following measures. The links redirect you to the official SAP documentation site, where detailed information can be found from each solution. 

🎯High Availability (HA) support features🎯Fault Recovery (FR) support features🎯Disaster Recovery (DR) support features
Host auto-failoverService auto-restartStorage replication
Storage replicationHost auto-failoverSystem replication
System replicationSystem replicationBackup & Recovery
Backup & Recovery  
  • 1755396 - Released disaster tolerance solutions for SAP HANA with disk replication

Also 👦 alper.somuncu already prepared nice articles about each solution. Listed in What blog posts can be helpful? section.

Which license is required for SAP HANA System Replication?

  • 2685661 - Licensing Required for HANA System Replication

What is the general way to check the status of SAP HANA System Replication?

  • 2518979 - HANA : how to check system replication status
  • 2517805 - How-to check if SAP HANA System Replication is in Sync or not

What are the available tools for monitoring the SAP HANA System Replication?
The general way to do the monitoring is to use SQL commands.

  • 1969700 – SQL Statement Collection for SAP HANA

The actual information can be reviewed with the following SQL Statements: “HANA_Replication_SystemReplication_”.

The action can be done in a graphical way also.

Which SAP HANA Alert IDs belongs to the topic?

  • 1999880 - FAQ: SAP HANA System Replication ➡️ 3. Which indications exist for problems with the SAP HANA system replication?

Which other documentations are important regarding SAP HANA HA and DR?

  • 2942617 - How to know the where SAP HANA is replayed to?
  • 2276567 - High Availability Troubleshooting Tree - Multi Node Failover
  • 2063657 - SAP HANA System Replication Takeover Decision Guideline
  • 2555775 - SAP HANA System Replication on different database version
  • 2473002 - Using HANA System Replication to migrate scale out system
  • 3339610 - How to setup service(s) in SAP HANA System Replication environment
  • 2500677 - How to switch operation mode in HANA system replication environment
  • 2973685 - Different configuration of 'statement_memory_limit' on secondary system
  • 2526877 - SAP HANA System Replication Parameter logshipping_max_retention_size
  • 2817438 - How to check memory usage on secondary site in HANA system replication scenario
  • 2763388 - Using different operating systems or operating system versions with HANA System Replication.
  • 3235388 - What is the maximum distance between data centers/sites for SAP HANA System Replication?
  • 2952826 - Perform table partitioning on HANA primary site requires additional steps on secondary site?
  • 3338229 - How to enable or disable parameter "enable_full_sync" in a HANA System Replication environment

What information is necessary to get support?

  • 2934640 - HANA and Replication - Collecting Support Data for Replication / Network related Tickets

What are the known issues?
The following list contains the most common issues belongs to the topic.

Data Volume

  • 3272698 - Data volume reclaim in High Availability setup
  • 2332284 - Data volume reclaim failed because of snapshot pages
  • 2562939 - HANA Data Volume Used Size is Doubled or Much Larger than Before
  • 2348397 - Shrink the Data Volume on Secondary Site with SAP HANA System Replication
  • 2539644 - Reclaim datavolume effected by data backup and System Replication SAP HANA

Log Volume

  • 3241617 - Missing logsegments unavailable on primary
  • 2821539 - Volume /hana/log is full with log segments in status RetainedFree
  • 2409471 - SAP HANA Log Volume Full on Secondary or Tertiary Site with System Replication

Network

  • 3000978 - Replication stops due to network issues

Backup and Recovery

  • 2939499 - Cannot run recovery on system replication secondary system
  • 2779139 - Replication status - Connection refused: primary needs initial data backup for system replication
  • 2575326 - SAP HANA System Replication sr_enable returns error Backup not executed or in Studio gives "You need to perform a backup"

Takeover

  • 2534122 - System Replication takeover takes longer than expected SAP HANA
  • 2963542 - Some specific tables data missing after takeover from primary site to secondary site

Other

  • 2278535 - Secondary Hana Database not starting after enabling Replication
  • 2650994 - SAP HANA System Replication does not work with DB isolation set to HIGH
  • 3201386 - HANA Replication status is different in transaction DBACOCKPIT and HANA Studio
  • 2661340 - hdbnsutil -sr_register only system replication chains are allowed with an additional async secondary site

Disaster Recovery and High Availability for different SAP platforms

  • 3081375 - Information about SAP BTP Disaster Recovery
  • 2683480 - Disaster Recovery and High Availability for SAP Cloud Integration

SAP HANA Academy
Check the related SAP HANA Academy content and Blog Post created by 👦 denys.kempen.

What blog posts can be helpful?
Blog Posts created by 👦 alper.somuncu

Blog Posts created by other authors

Other articles in this series
✍️ Collected information about memory in context of SAP HANA
✍️ Collected information regarding partitioning in SAP HANA (with examples)
✍️ Collected information about reclaim / shrink / defragmentation topic in context of SAP HANA persiste...

Other articles in connected series
✍️ Where can I find knowledge and information belongs to SAP HANA?
✍️ Where can I find information about the available tools for SAP HANA (all types of use)?

Useful bookmark
🔖 2872774 – Bookmark of Frequently Asked Questions for SAP HANA
🔖 3311408 – Bookmark of SQL Statement Collection reports for SAP HANA
🔖 2658020 – List of SAP HANA SQL Error Codes

Do you have further questions?
Q&A link for SAP HANA: https://answers.sap.com/tags/73554900100700000996

Contribution
If you find any missing information belongs to the topic, please let me know. I am happy to add the new content. My intention is to maintain the content continuously to keep the info up-to-date.

Release Information

Release DateDescription
2023.04.14First/initial Release of the SAP Blog Post documentation (Technical Article).
2024.02.01SAP Community 2024 optimized content.