Restoring and recovering SAP HANA databases

Download PDF of this page

You use SAP HANA Studio and Snap Creator to restore and recover SAP HANA databases.

  1. Within SAP HANA Studio:

    1. Select Recover for the SAP HANA system.

    2. SAP HANA system is shut down.

    3. Select the recovery type.

    4. Provide log backup locations.

    5. List of data backups is shown

    6. Select backup to see the external backup ID.

  2. For a storage system running clustered Data ONTAP only:

    1. Only required if any other backup than the latest has been used for the restore.

    2. Only required for “Volume SnapRestore” from primary storage.

    3. Deactivate SnapVault relationships

  3. Within Snap Creator:

    1. Select “Restore” for the SAP HANA system.

    2. Select restore from primary or secondary storage, depending on the availability of the backup at the primary storage.

    3. Select storage controller, volume name, and Snapshot copy name. Snapshot copy name correlates with the backup ID earlier.

    4. For multinode SAP HANA systems, multiple volumes need to be restored:

      1. Choose Add more restore items.

      2. Select storage controller, volume name, and Snapshot copy name.

      3. Repeat this process for all required volumes.

    5. For multitenant database containers (MDC) single tenant database systems, both the SYSTEM and TENANT databases are restored.

    6. Restore process is started

    7. Restore finished for all volumes.

  4. At the database nodes, unmount and mount all data volumes to clean "Stale NFS Handles."

  5. Within SAP HANA Studio:

    1. Select Refresh on backup list.

    2. Select available backup for recovery (green item).

    3. Start recovery process.

    4. For multitenant database containers (MDC) single tenant database systems, start the recovery process first for the SYSTEM database, and then for the TENANT database.

    5. The SAP HANA system is started.

  6. (Optional) Resume SnapVault relationships for all restored volumes.

    At the storage systems, this step is only required if a backup other than the latest one has been used for the restore.