Performing SAP HANA Restores

A database restore might be necessary when the data area or the log area is damaged, to recover from a logical error or to copy the database. You can achieve this by using the data and the log backups that you previously performed.

The SAP HANA software brings the database down before the restore and brings it back up after the restore completes.

If you want to recover only the data, then you must perform the restore by using a full backup.

Before You Begin

1. Perform a backup.

2. Verify that the restore environment has the same set of nodes and the instance SID name as the backup environment. If you modified the backup environment, then you must make the same modifications on the restore environment.

3. Verify that the SAP HANA software version on the destination is the same version or higher than the software version.

Procedure

1. You can perform a restore on the instances or job details page.

   • Instances: From the navigation pane, click Solutions > DB Instances, in the column for the instance, click Restore.

   • Database Details: From the navigation pane, click Solutions > DB Instances > instance, in the upper right, click Restore.

     The Restore Options page appears.

2. From the Destination Client list, select the destination host to use for the restore.

3. From the Destination instance list, select the destination instance to use for the restore.

4. Choose the database recover option.

   • To recover the database, select Recover Database.

     • To recover to the latest backup job completion time, select Current time.

     • To recover to a point-in-time, select Point in Time, and type the date and time.

   • To recover only the data, select Recover data only.

     To use this option, you must perform the restore by using a full backup.

     If you restore by specifying the internal backup job ID, then you must have the catalog backup available with backint. SAP HANA creates the internal backup ID .

     If you restore by specifying the backup prefix, then you do not have to have the catalog backup available with backint. The Commvault software creates the backup prefix by pre-pending the job ID to the backup prefix. For example, 4815976_COMPLETE_DATA_BACKUP.

     1. Select the backup to use for the restore:

     2. To restore by specifying the backup prefix, in the Backup prefix box, type the backup prefix for the backup that you want to restore.

     3. To restore by specifying the internal backup job ID, in the Internal Backup ID box, type the internal backup job ID that you want to restore.

5. To verify that all the backups required for the recovery operation are available, select the Check Access check box.

6. To initialize the log area after the restore, select the Initialize log area check box.

7. Click Submit.

What to Do Next

You can control or view the job. For more information, see Jobs.