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

Precautions

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.
    selectsource
  7. Verify the source and destination SAP HANA instances, select the source database, and then click Next.
    Select Database
  8. Set the parameters, including the Restore To parameter, and click Next.
    Restore Policy

    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 a SAP HANA instance in the same region from 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. In addition, you must turn on Use Backint for Catalog Backup for the database of the destination SAP HANA instance. For information about how to turn on Use Backint for Catalog Backup, see Set backup parameters. restore2
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. systemname
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 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. Image repository names contain [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.

Restore a database to another database in the source SAP HANA instance

You must use SAP HANA Studio to restore a database to another database in the source SAP HANA instance.

  1. Open SAP HANA Studio and connect to the SAP HANA instance.
  2. Right-click the database instance to be restored and choose Backup and Recovery > Recover Tenant Database.
    restore3
  3. Select a tenant database.
    restore3-2
  4. In the Specify Recovery Type window, click Recover the database to a specific data backup.
  5. In the Specify Backup Location window, configure the following parameters.
    • Click Recover using the backup catalog.
    • Click Search for the backup catalog in Backint only.
    • Select Backint System Copy.
    • Enter DBNAME@SID in the Source System field.

      DBNAME is the name of the backup database to be restored. SID is the ID of the current database instance.

  6. Follow the wizard instructions to stop the database and select the backup that you want to restore to the database.
    Important If you cannot find the required backup in the Backups list, check whether you have turned on Use Backint for Catalog Backup. For information about how to turn on Use Backint for Catalog Backup, see Set backup parameters.
    backups
  7. Confirm the recovery settings and click Finish.

What to do next

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

  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.