2242471 - HANA Studio bug making registration of former primary site as new secondary site impossible.

Symptom

You are using the HANA system replication to enable disaster recovery for your system landscape. In case the secondary site needs to takeover, the former primary site needs to be registered as the new secondary site after the takeover so that data on both data centers are in sync again. In the HANA Studio, there is a bug so that a registration of the former primary as new secondary site is not possible as the option is not selectable in the window.

Environment

You are using system replication as part of your HANA DB landscape and you are also using HANA Studio for database administration and operations.

Reproducing the Issue

1. Stop the primary site.
2. Perform the takeover on the secondary site.
3. Right click on the primary system in the system overview of HANA Studio and select 'Configuration & Monitoring' -> 'Configure System Replication'.
4. You will see that the option 'Register secondary system' is not selectable although the primary system is already stopped.

Cause

The issue is most probably related to a HANA Studio bug.

Resolution

You need to use the hdbnsutil tool on command line in order to register the former primary site as the new secondary site.
1. Connect to the OS of your primary system as <sid>adm user.
2. Enter following command: hdbnsutil -sr_register --remoteHost=<hostname of current primary site> --remoteInstance=<instance number of current primary site> --mode=<replication mode> --name=<name of the local system> (you can give any name for this option).
3. The former primary site is now registered as the new secondary site and data replication will start.
The underlying bug is fixed as of SAP HANA SPS 11.

Keywords

HANA system replication, primary data center, secondary data center, hdbnsutil, HANA Studio

Header Data

Released On	12.11.2015 08:24:29
Release Status	Released to Customer
Component	HAN-DB-HA SAP HANA High Availability
Priority	Normal
Category	Problem