Restoring a Data Protection for SAP HANA backup on an alternative system

You can use the backint interface for system copies to an alternative server from SPS09 and later releases of SAP HANA. During restore/recovery, you can specify the source system from which you want to restore.

Before you begin

To restore data on an alternative system with Data Protection for SAP HANA, the profiles for both the source and target SID (system identifier) must exist on the alternative system. SAP HANA restores the data by using the source SID profile and on completion of the restore, starts log backups by using the new SID profile. You must adjust the SAP HANA configuration to use the correct profile. The SAP HANA® Administrator's Guide describes the requirements and advises the use of the $(SAPSYSTEMNAME) within the SAP HANA configuration.

Important: In the dsm.sys configuration file, use Passwordaccess prompt rather than passwordaccess generate. Passwordaccess prompt ensures that the restore runs with root authority and accesses the backup data, regardless of the user that is performing the restore.

For example, in the following screen capture $(SAPSYSTEMNAME) replaces the SID with the location of the IBM Spectrum Protect™ for Enterprise Resource Planning profile, which allows the processing to dynamically pick up the correct .utl file. The integrity of the backups is ensured.

1. Start the SAP HANA Studio.
2. In the SAP HANA Studio Navigator tab, right-click to select the instance. Select Recovery.
   If the database instance is still running, a message might be displayed. The message states that the system must be shut down. When you confirm the message, SAP HANA Studio automatically shuts down the instance.
3. In the Specify Recovery Type window, choose the type of recovery that you want to run.
4. In the Locate Log Backups pane, the default location can be used.
5. Choose Specify backup without catalog in the Specify Backup Location pane. If the backup prefix is not specified, a list of backups is generated from the SAP HANA recovery catalog, otherwise the backup prefix that is specified is that backup that is restored.
   Important:

   You must specify the SID of the source database in the Source System field. For more information, see the SAP HANA Administrator’s Guide.

   
6. Advance through the panes, and select the options that you require.