Skip to Content
BW (SAP Business Warehouse)

High Availability (HA) and Disaster Tolerance (DT)

Tags:

What are the SAP BW on HANA capabilities for High Availability (HA) and Disaster Tolerance (DT)?

BW on HANA offers all High Availability with failover and Disaster Tolerance capabilities that the HANA DB offers. High availability is offered with failover from active to passive nodes. However, especially capabilities for Disaster Tolerance can differ by HW vendors. Please contact your HW vendor for details.

Gartner published a detailed article explaining SAP HANA's strong HA/DR capabilities.

http://www.gartner.com/technology/reprints.do?id=1-2OW5H99&ct=151005&st=sb

Please also see these SAP HANA whitepapers for details of capabilities delivered with HANA.

http://scn.sap.com/docs/DOC-60341

http://scn.sap.com/docs/DOC-60334

High Availability FAQ:

http://scn.sap.com/docs/DOC-66702

The link to the video below shows a live demo of a failover of a master and slave node.

https://www.youtube.com/watch?v=xCHoYoveXFY

There are also blogs that describes more details about this.

https://blogs.saphana.com/2013/03/04/why-is-a-fault-tolerant-architecture-important-how-do-i-build-it-in-hana/

https://blogs.saphana.com/2013/06/27/the-truth-about-sap-hana-and-hadr/

There is also a page about this topic in the SoH FAQ where additional information might be found.

https://scn.sap.com/docs/DOC-59918

During a power failure, will the BW information which is stored in the memory be lost?

Every HANA system, hence a BW on HANA environment, has a persistent storage to back-up all information on a constant base, from which the data of a BW on HANA system can be restored into memory. In the video link below you can review the end-to-end process.

http://scn.sap.com/docs/DOC-60341

https://www.youtube.com/watch?v=xCHoYoveXFY

Where can I find more technical and implementation information about HANA's High Availability (HA) and Disaster Tolerance (DT)?

The HANA Administrator Guide contains a lot of detailed information about this topic including step by step instructions.

http://help.sap.com/hana_platform#section4

http://scn.sap.com/docs/DOC-60368

HP Technical Whitepaper for SAP HANA Disaster Tolerant Solution
http://h20195.www2.hp.com/V2/GetDocument.aspx?docname=4AA1-4846ENW&cc=us&lc=en