Recovering from Data Snapshots with SAP HANA Studio
The recovery process for a storage snapshot will restore the SAP HANA instance and all of the data to the point in time at which the storage snapshot was taken.
The recovery of a system using storage snapshots with multiple database containers (MDC) is only supported from SAP HANA 2.0 SPS04. A system with a single container can be recovered from a data snapshot in previous versions.
SAP HANA Scale Up/Single Node deployment
Step 1. Prepare to Recover the System Database (MDC Systems Only)
Navigate to the Systems inventory and right client on the SystemDB connection for the relevant database and navigate to the Backup and Recovery sub-menu then select “Recover System Database…”. A prompt to shut down the relevant system will be shown as recovery can only be done when it is offline.
| Navigate to the systems inventory, right click the SystemDB and navigate to Backup and Recovery > Recover System Database... |
 |
| Enter the relevant values for the <sid>adm user created during initial SAP HANA installation. |
 |
| SAP HANA studio will display a prompt to shut down the system. |
 |
| The graphical process offers the user various options of choosing a recovery type. |
 |
| The location of the backup catalog is normally populated, only change the under specialized circumstances where the recovery catalog is in a different location. |
 |
| All records in the catalog will be shown with the relevant information, take note of the Backup ID for the required recovery point. |
 |
Step 1a. Recover block storage volume
Recover the relevant storage volume using the FlashArray web user interface. This operation can also be completed using the command line interface or ReST API.
| SSH command to unmount the volume at the specified location. |
 |
| Navigate to the FlashArray web user interface and select “Storage” from the sidebar and then navigate to the “Volumes” section. |
 |
| Navigate to the block volume on which the relevant hosts HANA data volume is located. |
 |
The snapshot which matches the “Backup ID” in the catalog is appended with the exact same value, this is the volume which should be restored. Note that the addition of this value is done during storage snapshot creation by the user.
| Select the 3 vertical dots to bring up the context menu and select Restore… |
 |
| Check the snapshot to be restored matches the requirements for this recovery scenario and then confirm the operation by selecting “Restore”. |
 |
| Return to the SSH connection and remount the volume to the HANA data location. This assumes that the correct values in /etc/fstab are present. |
 |
Step 1b. Recover the System Database
| Select “Refresh” from the Recovery window in SAP HANA studio and the relevant recovery point should be shown as available, then select “Next “to proceed. |
 |
| Review the relevant settings for “Initialize Log Area”, “Use Delta Backups” and “Install New License Key”. In some scenarios, these selections will be grayed out depending on the recovery type. |
 |
| Review all of the recovery settings and proceed by selecting “finish”. |
 |
Step 2 Recover Tenant Database(s)
During the recovery of the System database all tenant databases are invalidated and need to be individually recovered by repeating the below steps.
Follow from here if using single container SAP HANA 1.0 system. Notable differences are the absence of “System” and “Tenant” terminology.
In SAP HANA 2.0 SPS04 and onwards repeat these steps for each additional tenant database.
Ensure that Step 1a is completed, while the database is offline, for SAP HANA 1.0 Single tenant systems before proceeding with the below.
| Review all of the recovery settings and proceed by selecting “finish”.Navigate to the main database view in SAP HANA Studio, right click on the relevant database connection, navigate to “Backup and Recovery” and then select “Recover Tenant Database…”. When using a single container SAP HANA 1.0 system this will state “Recover database…” |
 |
| (MDC Only) Select the tenant database to restore. In SAP HANA 2.0 SPS03 and previous releases only a single tenant system can be restored.(MDC Only). Select the tenant database to restore. In SAP HANA 2.0 SPS03 and previous releases only a single tenant system can be restored. |
 |
| The location of the backup catalog is normally populated, only change this under specialized circumstances where the recovery catalog is in a different location. |
 |
| Accept the prompt to shut down the database. |
 |
| The relevant recovery point should be shown as available, then select “Next “to proceed. |
 |
| The log backup location is typically populated with the system default values, only change these values in specialized circumstances. |
 |
| Review the relevant settings for “Check the availability of delta and log backups”, “Initialize Log Area”, “Use Delta Backups” and “Install New License Key”. In some scenarios, these selections will be grayed out depending on the recovery type. |
 |
| Review all of the recovery settings and proceed by selecting “finish”. |
 |
| When recovery is completed the status will be shown. |
 |
SAP HANA Scale Out/Multi-Node Deployment
Step 1. Prepare to Recover System Database (MDC Systems Only)
Navigate to the Systems inventory and right client on the SystemDB connection for the relevant database and navigate to the Backup and Recovery sub menu then select “Recover System Database…”. A prompt to shut down the relevant system will be shown as recovery can only be done when it is offline.
| Navigate to the systems inventory, right click the SystemDB and navigate to Backup and Recovery > Recover System Database… |
 |
| Enter the relevant values for the <sid>adm user created during the initial SAP HANA installation. |
 |
| SAP HANA studio will display a prompt to shut down the system. |
 |
| The graphical process gives the user an option of choosing a recovery type. |
 |
| The location of the backup catalog is normally populated, only change this under specialized circumstances where the recovery catalog is in a different location. |
 |
| All records in the catalog will be shown with the relevant information, take note of the Backup ID for the required recovery point. |
 |
Step 1a. Recover Block Storage Data Volumes
Recover the relevant storage volume using the FlashArray web user interface. This operation can also be completed using the command line interface or ReST API.
| In the FlashArray web user interface navigate to “Storage” and select the “Volumes” section. |
 |
The snapshot which matches the “Backup ID” in the catalog is appended with the exact same value, this is the volume which should be restored. Note that the addition of this value is done during storage snapshot creation by the user.
| Identify the snapshots relevant to the Backup_ID of the recovery point. |
 |
| Unmount each persistence data volume from the mount point on each host |
|
|
| Select the 3 dots on the right-hand side of the relevant snapshot” and select “Restore” for each required block device. A prompt will appear for each snapshot, check the information, and then confirm the restore operation. Using the Copy option will copy the snapshot to a new volume. If copying the snapshot(s) to a new volume then the old data volumes must be disconnected and the new volumes connected to the hosts. |
 |
| Verify that the volumes have restored correctly. |
 |
| Navigate to each volume and check the details match what is required of the SAP HANA scale out system. |
 |
| Check the details for each volume required to attach to any host in the distributed host setup. |
 |
| Check the details for each volume required to attach to any host in the distributed host setup. |
 |
| Check the details for each volume required to attach to any host in the distributed host setup. |
 |
Updating global.ini with New Volume WWID's if Snapshots are Copied to New Volumes
If the recovery scenario is to copy the volume snapshots to a new volume and export that to the SAP HANA hosts then the worldwide ID's in the global.ini configuration file must be first updated.
As the root user, get the new worldwide identifiers for the volumes by executing "multipath -ll". The WWID is the alphanumeric string in the red box. Collect this value for all of the new data volumes copied from snapshots.
As the root user edit the following file: /hana/shared/<SID>/global/hdb/custom/config/global.ini.
Look for the [storage section] and update the wwid values where the string is "partition_n_data_wwid".
Step 1b. Recover the System Database
| Select “Refresh” once all of the steps in Step 1a are completed and wait for the user interface to refresh. Once the required recovery point is shown to be available select “Next”. |
 |
| Review the relevant settings for “Initialize Log Area”, “Use Delta Backups” and “Install New License Key”. In some scenarios, these selections will be grayed out depending on the recovery type. |
 |
| Review all of the recovery settings and proceed by selecting “finish”. |
 |
| Monitor the recovery process. |
 |
| Verify the system was restored successfully. |
 |
Step 2. Recover Tenant Database(s)
During the recovery of the System database, all tenant databases are invalidated and need to be individually recovered by repeating the below steps.
Follow from here if using single container SAP HANA 1.0 system. Notable differences are the absence of “System” and “Tenant” terminology.
In SAP HANA 2.0 SPS04 and onwards repeat these steps for each additional tenant database.
Ensure that Step 1a is completed, while the database is offline, for SAP HANA 1.0 Single tenant systems before proceeding with the below.
| Navigate to the main database view in SAP HANA Studio, right click on the relevant database connection, navigate to “Backup and Recovery” and then select “Recover Tenant Database…”. When using a single container SAP HANA 1.0 system this will simply state “Recover database…” |
 |
| (MDC Only) Select the tenant database to restore. In SAP HANA 2.0 SPS03 and previous releases, only a single tenant system can be restored. |
 |
| Specify the Recovery Type. |
 |
| The location of the backup catalog is normally populated, only change this under specialized circumstances where the recovery catalog is in a different location. |
 |
| Accept the prompt to shut down the database. |
 |
| The relevant recovery point should be shown as available, then select “Next “to proceed. |
 |
| Review the relevant settings for “Initialize Log Area”, “Use Delta Backups” and “Install New License Key”. In some scenarios, these selections will be grayed out depending on the recovery type. |
 |
| Monitor the data recovery operation. |
 |