cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Refresh from distributed to single host

former_member221632
Participant
0 Kudos

We are planning to do a HANA refresh from multi node (production) to single host (test system). I'm going through the guides & notes for the same and need some clarifications.

Production has 7 active nodes & 1 standby node whereas test system has only one node. We have enough disk space & memory on the test system to accomodate production data.

HANA database version is SPS8 (Revision 81) and hence the note 1749467 is not applicable here. As per the HANA SPS8 admin guide,

1) The target system configuration must be the same as the source system with the same number and types of services

Currently prod has 8 sapstartsrv, 8 compileserver, 8 indexserver (1 is standby), 8 preprocessor, 1 statisticsserver, 8 xsengine (1 is standy), 8 nameserver, 8 daemon services. Test system has only 1 service of each. Do we need to add all the remaining services in the same single host?

2) If the target system has fewer hosts than the source system, you must reconfigure the target system so that multiple indexserver services run on one host. If multiple services of other types exist, you must ensure that each service is running on a separate host.

You can configure the type and number of services on the target system using the SQL statement ALTER SYSTEM ALTER CONFIGURATION.

To add additional index server services to a single-host target system, use the following SQL statement:

ALTER SYSTEM ALTER CONFIGURATION('daemon.ini','system') SET('indexserver.c','instanceids')='<n>[,<n>+2]' WITH RECONFIGURE

Where n starts with a value of 40 and is incremented by 2 for every additional service.

In the guide, it's just mentioned about adding the indexserver, whether other services need to be added? If so, how to add them?

3) After the database copy is completed, you should return to the normal configuration, with only one single index server on a host.

How to return to the normal configuration by removing the additional servers?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member221632
Participant
0 Kudos

Can someone answer my questions please? If the system copy is not possible, is it possible to take the export of the complete database, similar to exporting the indvidual schemas from HANA studio and then import that database export in the target HANA?