Recovery from a Data Snapshot typically uses either SAP HANA Studio or SAP HANA Cockpit. In the event that access to these administration tools is not possible, recovery can be performed by following this guide. This process can also be used in scenarios where there is no access to the SAP HANA Backup Catalog or any backups of it.
Requirements for this process are as below:
- Access to a bash terminal or SSH connection for any of the SAP HANA systems required during the recovery (both root and <sid>adm users credentials are required).
- SSH or GUI access to the FlashArray.
Before getting started, if the instance is not shut down - shut it down using the sapcontrol command utility:
Scale Up
/usr/sap/hostctrl/exe/sapcontrol -nr <instance number> -function Stop
Scale Out
/usr/sap/hostctrl/exe/sapcontrol -nr <instance number>-function StopSystem HDB In a Scale Out environment, the sapcontrol stop command needs to be run on each node in the landscape.
Wait until the instance is fully stopped by checking the status with the sapcontrol command utility:
Scale Up
/usr/sap/hostctrl/exe/sapcontrol -nr <instance number> -function GetProcessList
When the instance is fully shut down it should display the output:
07.07.2020 04:24:07
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, GRAY, Stopped, , , 20982Scale Out
/usr/sap/hostctrl/exe/sapcontrol -nr <instance_number> -function GetSystemInstanceList​​
When the instance is fully shut down it should display the output:
08.07.2020 06:30:48
GetSystemInstanceList
OK
hostname, instanceNr, httpPort, httpsPort, startPriority, features, dispstatus
shn1, 0, 50013, 50014, 0.3, HDB|HDB_WORKER, GRAY
shn2, 0, 50013, 50014, 0.3, HDB|HDB_STANDBY, GRAY
shn3, 0, 50013, 50014, 0.3, HDB|HDB_WORKER, GRAY
shn4, 0, 50013, 50014, 0.3, HDB|HDB_WORKER, GRAY