Skip to Content
avatar image
Former Member

HANA Multitier system replication in remote database


We are planning to configure the HANA Database Multitier system replication setup for HA & DR.

Primary and secondary database in one data center and remote database in another data center.

We want Primary and secondary database should be in sync up to date.
But the remote database sync should be delayed by 4 hrs. It means we want to ship the logs from secondary to remote database but apply logs after 4 hrs.

So that in case if any data deleted in primary database mistakenly then we can break the replication in remote database and apply the logs in remote database before the data deletion time then connect with applications.After that recreate the primary and secondary databases.

Currently we are using this kind of setup in oracle database with dataguard.

We are not able to find any SAP Note or documentation for this kind of setup in HANA remote database side.

Is it possible to achieve this scenario in HANA system replication method?

Thanks and Regards,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 02, 2017 at 03:03 PM


    I found a document, which might help you. Please check out point 5.3:

    Regards, Mynyna
    Add comment
    10|10000 characters needed characters exceeded

  • Jun 03, 2017 at 12:45 PM

    Hello Anand,

    In addition to the document Mynyna mentioned you can check below links for SAP HANA 1.0 SP12 Replication

    Set Up Multitier System Replication and Supported Replication Modes between Sites.

    I am not sure whether you could select different operation modes betweeen tier 1 to tier 2 and tier 2 to tier 3 since "In Multitier System Replication the operation mode must be the same for all sites." is given on page 18 of "How To Perform System Replication for SAP HANA" document.

    This means your scenario does not work for SAP HANA.


    Yuksel AKCINAR

    Add comment
    10|10000 characters needed characters exceeded