SAP Knowledge Base Article - Preview

3357978 - How to configure SAP Hana Multitarget System Replication using SAP Hana Cockpit 2.0


This is an example configuration which is showing step by step how to configure SAP Hana Multitarget System Replication using SAP Hana Cockpit 2.0 as mentioned in our SAP HANA System Replication guide:

In a multitarget system replication, primary and secondary systems can replicate data changes to more than one system.

Multitarget system replication brings advantages for several use cases:
  • Update scenarios

  • Rearrangements of system replication multitier chains

  • Reaching higher availability (before stopping existing structures, new structures can be built and established)

The graphic shows a possible setup for multitarget system replication.

Primary system A in data center 1 replicates data changes to secondary system B in the same data center. Primary system A also replicates data changes to secondary system C in data center 2. Secondary system C is a source system for a further secondary system D located in the same data center with system C.

To understand how to handle different disaster recovery scenarios, see Disaster Recovery Scenarios for Multitarget System Replication. In a multitarget system replication, the secondary systems can be configured to automatically re-register to a new source system when the original source system unavailable.

For multitarget system replication either the logreplay or logreplay_readaccess mode is required.

In a multitarget system replication setup, you can configure multiple secondaries as Active/Active (read enabled). Only one of these secondaries can be accessed via hint-based statement routing; the others must be accessed via direct connection. For more information on Active/Active (read enabled), see Active/Active (Read Enabled).



in this scenario there are 4 Hana nodes all preconfigured running as stand alone system with the same System ID. More details for General Prerequisites for Configuring SAP HANA System Replication can be read here

At the time when this how to is created I'm using current available releases for SAP Hana DB and SAP Hana Cockpit 2.0.

SAP Hana Studio with all Hana DB host running without System Replication enabled. 


KBA , HAN-CPT-CPT2-ADM , SAP HANA Cockpit 2 (Administration Core) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.