Restoring and recovering databases from primary storage

Contributors Download PDF of this page

You can restore and recover the database from the primary storage.

Note You cannot restore file-based backup copies from Snap Creator.
  1. Within SAP HANA Studio, select Recover for the SAP HANA system.

    This image is explained by the surrounding text.

    The SAP HANA system shuts down.

  2. Select the recovery type and click Next.

    This image is explained by the surrounding text.
  3. Provide the log backup locations and click Next.

    This image is explained by the surrounding text.

    The list of available backups you see is based on the content of the backup catalog.

  4. Select the required backup and record the external backup ID.

    This image is explained by the surrounding text.
  5. Deactivate the SnapVault relationship.

    Note This step is only required with clustered Data ONTAP.

    If you need to restore a Snapshot copy that is older than the Snapshot copy currently used as the base Snapshot copy for SnapVault, you must first deactivate the SnapVault relationship in clustered Data ONTAP. To do that, execute the following commands on the backup cluster console:

    hana::> snapmirror quiesce -destination-path hana2b:backup_hana_data
    Operation succeeded: snapmirror quiesce for destination hana2b:backup_hana_data.
    
    hana::> snapmirror delete -destination-path hana2b:backup_hana_data
    Operation succeeded: snapmirror delete the relationship with destination hana2b:backup_hana_data.
    
    hana::> snapmirror release -destination-path hana2b:backup_hana_data
    [Job 6551] Job succeeded: SnapMirror Release Succeeded
  6. In the Snap Creator GUI, select the SAP HANA system, then select Actions > Restore.

    This image is explained by the surrounding text.

    The Welcome to the Snap Creator Framework Restore Wizard screen appears.

  7. Click Next.

    This image is explained by the surrounding text.
  8. Select Primary and click Next.

    This image is explained by the surrounding text.
  9. Select restore from primary storage.

  10. Select the storage controller, the volume name, and the Snapshot name.

    The Snapshot name correlates with the backup ID that has been selected within SAP HANA Studio.

    This image is explained by the surrounding text.
  11. Click Finish.

    This image is explained by the surrounding text.
  12. Click Yes to add more restore items.

    This image is explained by the surrounding text.
  13. Select the storage controller, the additional volume name, and the Snapshot name.

    The Snapshot name correlates with the backup ID that has been selected within SAP HANA Studio.

    This image is explained by the surrounding text.
  14. Repeat steps 10 through 13 until all required volumes are added; in our example, data_00001, data_00002, and data_00003 need to be selected for the restore process.

  15. When all volumes are selected, click OK to start the restore process.

    This image is explained by the surrounding text.

    The restore process is started.

    This image is explained by the surrounding text.

    Wait until the restore process is finished.

  16. On each database node, remount all data volumes to clean Stale NFS Handles.

    In the example, all three volumes need to be remounted at each database node.

    mount -o remount /hana/data/ANA/mnt00001
    mount -o remount /hana/data/ANA/mnt00002
    mount -o remount /hana/data/ANA/mnt00003
  17. Go to SAP HANA Studio and click Refresh to update the list of available backups.

    This image is explained by the surrounding text.

    The backup that has been restored with Snap Creator is shown with a green icon in the list of backups.

  18. Select the backup and click Next.

    This image is explained by the surrounding text.
  19. Select other settings as required and click Next.

    This image is explained by the surrounding text.
  20. Click Finish.

    This image is explained by the surrounding text.

    The recovery process begins.

    This image is explained by the surrounding text.
  21. After recovery is finished, resume the SnapVault relationships, if required.

    This image is explained by the surrounding text.