on 10-07-2014 11:11 AM
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?
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.