PowerProtect Data Manager 19.9 SAP HANA Agent User Guide

Performing restore and recovery by using SAP HANA Studio

1. Start SAP HANA Studio.

2. In the recovery GUI, go to the Specify Recovery Type page.

   

   1. Select one of the following types of recovery for the required SID:
      • Recover the database to its most recent state—Recovers the database as close as possible to the current time.
      • Recover the database to the following point in time—Recovers the database to a specific point-in-time.
      • Recover the database to a specific data backup—Restores only the specified data backup.
   2. In an exceptional case when a previous recovery has failed, click Advanced >>, and then select Recover the database to the following log position.
   3. Click Next >.

3. On the Locate Log Backups page, specify the locations of the log backup files to use to perform recovery.

   The backup locations for the single database containers and the multitenant database containers are as follows:

   • Single database container—/usr/sap/<SID>/SYS/global/hdb/backint/
   • Multitenant database container (System DB)—/usr/sap/<SID>/SYS/global/hdb/backint/SYSTEMDB
   • Multitenant database container (Tenant DB)—/usr/sap/<SID>/SYS/global/hdb/backint/DB_<tenantDB>

   

4. On the Select Data Backup page, select the database backup for either restore or recovery.

   

   To check the availability of a backup, select the backup in the table, and then click Check Availability. The Available column in the table displays either a green icon if the backup is available or a red icon if the backup is not available.

5. On the Other Settings page, select the required options, and then click Next >.
6. On the Review Recovery Settings page, review the information, and then click Finish.

   The recovery progress appears for each service that includes the name server, the index server, and the statistics server. A confirmation message appears when the recovery completes.