SAP HANA system replication with 1 primary and 2 secondary.

[former_member72943]

Hello Experts,

I have a query here I want to setup a DR where I have 2 DR site NEAR DR and FAR DR.NEAR DR is not HA site. Can I setup DR here with one PR which will have 2 secondary DR one is Near DR and another one is Far DR. If it is possible how can I setup this.

I have seen multi tier DR setup in which Site A is PR site B is secondary to site A and site C which is secondary to site B and site B will be primary to site C. In this scenario if site B goes down (due to hardware failure) then my DR setup is broken and i am at risk with only PR running as site C is of no use as my site B is down and data sync between site B and site C is not there.

For this reason I want to know can I setup DR with 1 Primary and 2 secondary connected to single primary?

Regards

Akif

[dvankempen]

Got the answer to your question? To improve the knowledge base and make the right answers easier to find, please mark the best answer and close the question. Thanks!

Don’t know how? See https://answers.sap.com/questions/13162472/how-to-mark-an-answer-and-how-to-close-a-question.html

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

[dvankempen · Accepted solution]

Hi Akif,

> can I setup DR with 1 Primary and 2 secondary connected to single primary?

Yes, this is called multi-target replication.

Multi-tier replication is illustrated: concerns a chain of HANA System Replication (HSR) sites.

Multi-target means replication to multiple sites simultanously, e.g. Site A (Tier 1) to Site B1 and B2 (Tier 2); or Site A1 (Tier 1) to Site A2 (Tier 1) and B (Tier 2).

As documented

• Disaster Recovery Scenarios for Multitarget System Replication
• SAP HANA Multitier System Replication

See also

• 1999880 - FAQ: SAP HANA System Replication

[former_member644293]

Sakhalkar,

Multi-target System Replication is possible & supported. Refer below link for more details.

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.03/en-US/ba457510958241889a459e606b...

Regards,

[former_member72943]

Thanks a lot Arun kumar