SAP HANA Migration from Multi-Node to Single-Node

Environment
SAP HANA Database SPS 08 and higher

Install a New HANA Database as Single-Host System

An SAP HANA database cannot be recovered to an SAP HANA database with a lower software version. The SAP HANA software version used for the recovery must always be the same version or higher than the SAP HANA database used to create the data backup or storage snapshot.

To recover the database, at least one full backup of multi host system is required. The data backup can be file-based or it can be created using a third-party backup tool.

Pre-requisite

To copy a database using backup and recovery, there can be any number of hosts in the target system, provided that the number and type of services is identical in both the source and the target system.

Example:

Source System is running on clustered environment with three Node, 1Master, I Slave and 1 Standby with following services:

Recovery :

Made accessible all the data and log backups to be used in the file system or available through a third-party backup tool. If you are recovering the database from a storage snapshot, the storage snapshot must be replicated in the data area.

Step 1:

Added the script server as describe in SAP Note 1650957 - SAP HANA Database: Starting the Script Server

as it no script server was available in the fresh installation

In an SAP HANA single database container, to add additional index server services, use the following SQL statement:

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

The instance ID (n) is incremented by 2 for every additional service.

Got the following error :

RECOVER DATA finished with error:

recovery could not be completed,

Recovery failed in nameserver startup: check services against topology failed: mismatch: 2 indexservers configured in source topology, 3 in destination system, mismatch: 2 scriptservers configured in source topology, 3 in destination system

Could not start master name server

Step 2: Then Deleted one services each of indexserver and scriptserver from the HANA Studio

But Still Got the error:

RECOVER DATA finished with error:

recovery could not be completed,

Recovery failed in nameserver startup: check services against topology failed: mismatch: 2 indexservers configured in source topology, 3 in destination system, mismatch: 2 scriptservers configured in source topology, 3 in destination system

Could not start master name server

Step 3: Manually made the changes to the file, removed one one instance

Database was restored on Single Node successfully.

Source: scn.sap.com