Solution : https://service.sap.com/sap/support/notes/1749467 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidelines for replicating a SAP HANA database from a multi-host to a single-host environment, primarily for purposes such as testing. It details the prerequisites such as having at least Revision 40 of SAP HANA, which allows recovery from multi-host to single-host configurations. Key steps include creating data backups, checking system resources (disk space and memory), configuring additional index servers, and managing backup files. Recovery processes involve copying backup files to the target system, configuring system settings, and conducting system recovery to ensure the single-host system mirrors the source environment’s data structure.
Key words :
/sys/global/hdb/metadata/ backupcatalog, /sys/global/hdb/metadata/ backupcatalog_recover, sap hana supports database copies, multiple-host sap hana database, hdb tenant index server, option initialize log area, alter system alter configuration, sap hana database running, additional index server processes, triple host source system
Related Notes :
| 1786963 | |
| 1774253 | SAP HANA appliance: Revision 40 of SAP HANA database |
| 1763333 | Homogeneous system copy on SAP HANA |
| 1705945 | Determining required restoration files |
| 1703435 | Creating a copy of a running instance using snapshots |
| 1697613 | Removing SAP HANA XS from topology |
| 1649519 | |
| 1642148 | FAQ: SAP HANA Database Backup & Recovery |
| 1514966 | SAP HANA 1.0: Sizing SAP In-Memory Database |