After you use Hybrid Backup Recovery (HBR) to back up SAP HANA databases to a backup vault, you can restore the databases to the source SAP HANA instance, another SAP HANA instance that uses the same backup vault, or an SAP HANA instance that resides in another region.

Prerequisites

Databases of an SAP HANA instance are backed up. For more information, see Back up an SAP HANA instance.

Background information

If an SAP HANA database is being restored, HBR automatically stops the database. When the database is being restored, you cannot access the database.

Restore a database to the source SAP HANA instance

To restore a database to the source SAP HANA instance, perform the following steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > SAP HANA Backup.
  3. In the top navigation bar, select the region where the SAP HANA instance to which you want to restore a database resides.
  4. Click the SAP HANA Instances tab.
  5. On the SAP HANA Instances tab, click Restore next to the SAP HANA instance.
  6. In the Create Restore Job panel, select the source SAP HANA instance as the instance to which you want to restore a database and click Next.
    restore1
  7. Verify the source and destination SAP HANA instances, select the source database, and then click Next.
    restore2
  8. Set the parameters, including the Restore To parameter, and click Next.
    restore3

    The following table describes the valid values of the Restore To parameter.

    Value of the Restore To parameter Description Parameter
    Latest Restore Point Restores the database to the latest restore point.
    • Use Differential Backup: If you want to use a differential backup or an incremental backup to restore the database, turn on this switch. If you turn off Use Differential Backup, HBR uses a log backup to restore the database.
    • Initialize Log Area: If you want to delete all log entries from the log area after the log entries are restored, turn on this switch.
    • Validate Differential and Log Backups: If you turn on this switch, HBR checks whether the required differential backup and log backup are available before the restore job starts. If the differential backup or log backup is unavailable, HBR does not start the restore job.
    Specified Time Point Restores the database to the restore point that is closest to a specified point in time.
    • Use Differential Backup: If you want to use a differential backup or an incremental backup to restore the database, turn on this switch. If you turn off Use Differential Backup, HBR uses a log backup to restore the database.
    • Initialize Log Area: If you want to delete all log entries from the log area after the log entries are restored, turn on this switch.
    • Validate Differential and Log Backups: If you turn on this switch, HBR checks whether the required differential backup and log backup are available before the restore job starts. If the differential backup or log backup is unavailable, HBR does not start the restore job.
    • Time Point: Select a point in time to which you want to restore the database. HBR restores the database to the restore point that is closest to a specified point in time.
    Specified Backup Restores the database to a specified backup. Use Catalog: If you want to use a catalog backup to restore the database, turn on this switch.
    Note If you turn off this switch, you must specify the prefix of a backup file. Then, HBR finds the backup file based on the specified prefix and restore the backup file.
    Specified Log Entry Restores the database to the point in time when a specified log entry is generated.
    • Use Differential Backup: If you want to use a differential backup or an incremental backup to restore the database, turn on this switch. If you turn off Use Differential Backup, HBR uses a log backup to restore the database.
    • Initialize Log Area: If you want to delete all log entries from the log area after the log entries are restored, turn on this switch.
    • Validate Differential and Log Backups: If you turn on this switch, HBR checks whether the required differential backup and log backup are available before the restore job starts. If the differential backup or log backup is unavailable, HBR does not start the restore job.
    • Log Entry: Specify a log entry. HBR restores the database to the point in time when the log entry is generated.
    • Volume ID: Specify the ID of the volume that you want to restore.
  9. Select a backup version that you want to restore and click Create.

Restore a database to another SAP HANA instance in the same region

If you want to restore an SAP HANA database to the source SAP HANA instance in the same region that uses the same backup vault, you can perform the preceding steps. The only difference is that you must select a different SAP HANA instance from the source SAP HANA instance.

After you verify the source and destination SAP HANA instances, you must set the Source Database Name parameter. The Source Database Name parameter specifies the name of the source database that you want to restore. You must set the parameter in the <Source database name>@<SID> format.
Note For more information about how to restore an SAP HANA database to another SAP HANA instance, see Restore a database to the source SAP HANA instance.

Restore a database to an SAP HANA instance in another region

A backup vault is a repository in which HBR stores backup data in the cloud. To implement disaster recovery, you can use an image repository to restore an SAP HANA database across regions.

Before you can restore an SAP HANA database to an SAP HANA instance in another region, you must create an image repository for the backup vault of the SAP HANA database. For information about how to create an image repository, see Use a mirror vault to back up data across regions.

To restore an SAP HANA database to an SAP HANA instance in another region, perform the following steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > SAP HANA Backup.
  3. Select the region where the image repository resides.
  4. On the SAP HANA Instances tab, install a backup client on each node of the SAP HANA instance.
    Note You must select an existing image repository vault. Image repository names include [COPY]. For more information about how to set other parameters when you install a backup client, see Register an SAP HANA instance.
  5. On the SAP HANA Instances tab, find the source SAP HANA instance, and click Restore in the Actions column.

What to do next

You can view the status of restore jobs or cancel running restore jobs. Procedure:

  1. In the left-side navigation pane, choose Backup > SAP HANA Backup.
  2. On the SAP HANA Backup page, click Restore Job.
  3. View the status of each restore job in the Status column.
  4. If you want to cancel a running restore job, find the job and click Cancel in the Actions column.