Skip to Content
0

HANA Multitier system replication in remote database

May 04, 2017 at 02:40 PM

315

avatar image
Former Member

Hello,

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,

Anand

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mynyna Chau
Jun 02, 2017 at 03:03 PM
1

Hi,

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

https://assets.cdn.sap.com/sapcom/docs/2013/10/26c02b58-5a7c-0010-82c7-eda71af511fa.pdf

Regards, Mynyna
Share
10 |10000 characters needed characters left characters exceeded
Yuksel AKCINAR Jun 03, 2017 at 12:45 PM
0

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.

Regards,

Yuksel AKCINAR

Share
10 |10000 characters needed characters left characters exceeded