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

Prerequisites

SAP HANA databases are backed up. For more information, see Back up an SAP HANA database.

Background

When SAP HANA databases are being restored, HBR automatically stops these databases. As a result, you cannot access these databases during restoration.

Restore an SAP HANA database to the original SAP HANA instance

To restore an SAP HANA database to the original SAP HANA instance, follow these steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > ECS Application Backup. On the ECS Application Backup page, select SAP HANA.
  3. On the page that appears, click the SAP HANA Instance tab.
  4. On the SAP HANA Instance tab, find the SAP HANA instance to be restored and click Restore in the Actions column.
  5. In the New Restore Task pane that appears, select the SAP HANA instance to be restored as the source SAP HANA instance and click Next.
    HANA instance
  6. Confirm the information about the source and destination SAP HANA instances, select the destination database, and then click Next.
    DB
  7. Set Restore Policy and other parameters as required. Then, click Next.

    The following table describes the parameters.

    Restore policy Description Parameter
    Most Recent Restores the database to the latest available status.
    • Use Differential: Turn on this switch if you want to use differential backup or incremental backup to restore the database. If you turn off this switch, HBR uses log backup to restore the database.
    • Use Log Area: Turn on this switch if you do not want to restore log entries in the log area. After the database is restored, the original log entries are deleted from the log area.
    • Validate Differential and Log: If you turn on this switch, HBR checks the availability of the required differential backup and log backup when the restore job starts. If the differential backup or the log backup is unavailable, HBR stops the restore job until the backup data is available.
    Time Point Restores the database to the status at a specified time point.
    • Use Differential: Turn on this switch if you want to use differential backup or incremental backup to restore the database. If you turn off this switch, HBR uses log backup to restore the database.
    • Use Log Area: Turn on this switch if you do not want to restore log entries in the log area. After the database is restored, the original log entries are deleted from the log area.
    • Validate Differential and Log: If you turn on this switch, HBR checks the availability of the required differential backup and log backup when the restore job starts. If the differential backup or the log backup is unavailable, HBR stops the restore job until the backup data is available.
    • Restore to Time: Select a time point that you want to restore the database to. HBR restores the database to the status closest to the specified time point.
    From Snapshot Restores the database to a specified backup. Use Catalog: Turn on this switch if you want to restore the database from catalog backup.
    Note If you turn off Use Catalog, you must specify the prefix of a backup version. This allows HBR to find the backup version to restore the database.
    Log Position Restores the database to the status when a specified log was generated.
    • Use Differential: Turn on this switch if you want to use differential backup or incremental backup to restore the database. If you turn off this switch, HBR uses log backup to restore the database.
    • Use Log Area: Turn on this switch if you do not want to restore log entries in the log area. After the database is restored, the original log entries are deleted from the log area.
    • Validate Differential and Log: If you turn on this switch, HBR checks the availability of the required differential backup and log backup when the restore job starts. If the differential backup or the log backup is unavailable, HBR stops the restore job until the backup data is available.
    • Log Position: Specify the log generated in the status that you want to restore the database to.
    • Volume ID: Specify the ID of the volume to be restored.
  8. Select a backup version to be restored and click Create.

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

The procedure for restoring an SAP HANA database to another SAP HANA instance in the same region that uses the same backup vault is similar to that for restoring an SAP HANA database to the original SAP HANA instance. The only difference is that you must select another SAP HANA instance as the source SAP HANA instance.instance2
In addition, after confirming the information about the source and destination SAP HANA instances, you must set Source System Name. The Source System Name parameter specifies the name of the source database. Enter the name in the Source database name@SID format.systemname
Note For more information about how to restore the SAP HANA database to another SAP HANA instance, see Restore an SAP HANA database to the original SAP HANA instance.

Restore an SAP HANA database to an SAP HANA instance in another region

A backup vault is a repository used by HBR to store backup data in the cloud. You can restore an SAP HANA database from a remote mirror vault to an SAP HANA instance in another region based on disaster recovery requirements.

Before you can use a remote mirror vault to restore an SAP HANA database to an SAP HANA instance in another region, you must create a remote mirror vault. For more information about how to create a mirror vault, 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, follow these steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > ECS Application Backup. On the ECS Application Backup page, select SAP HANA.
  3. Select the region where a mirror vault resides.
  4. On the SAP HANA Instance tab, install a backup client on each node of the source SAP HANA instance.
    Note You must select the existing mirror vault whose name starts with [COPY] as the backup vault for the source SAP HANA instance. For more information about other parameters for installing the backup client, see Register an SAP HANA instance.
  5. On the SAP HANA Instance tab, find the SAP HANA instance to be restored and click Restore in the Actions column.

What to do next

In the HBR console, you can view the status of restore jobs and cancel ongoing restore jobs. Follow these steps:

  1. In the left-side navigation pane, choose BackupECS Application Backup. On the ECS Application Backup page, select SAP HANA.
  2. On the page that appears, click the Restore Jobs tab.
  3. View the status of restore jobs in the Status column.
  4. To cancel an ongoing restore job, find the target job and click Cancel in the Actions column.