Restoring and recovering databases from secondary storage

Contributors Download PDF of this page

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

  1. Within SAP HANA Studio, select Recover for the SAP HANA system.

    This image is explained by the surrounding text.

    The SAP HANA system will be shut down.

  2. Select the recovery type and click Next.

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

    This image is explained by the surrounding text.

    The list of available backups appear based on the content of the backup catalog.

  4. Select the required backup and write down external backup ID.

    This image is explained by the surrounding text.
  5. Go to the Snap Creator GUI.

  6. Select the SAP HANA system, and then click Actions > Restore.

    This image is explained by the surrounding text.

    The Welcome screen appears.

    This image is explained by the surrounding text.
  7. Click Next.

  8. Select Secondary and click Next.

    This image is explained by the surrounding text.
  9. Enter the required information. The Snapshot name correlates with the backup ID that has been selected in SAP HANA Studio.

    This image is explained by the surrounding text.
  10. Select Finish.

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

    This image is explained by the surrounding text.
  12. Provide the required information for all volumes that need to be restored. In the setup data_00001, data_00002, and data_00003 need to be selected for the restore process.

    This image is explained by the surrounding text.
  13. When all volumes are selected, select OK to start the restore process.

    Wait until the restore process is finished.

  14. 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
  15. Go to SAP HANA Studio and click Refresh to update the backup list.

    This image is explained by the surrounding text.
  16. The backup that has been restored with Snap Creator is shown with a green icon in the list of backups. Select the backup and click Next.

  17. Select other settings as required and click Next.

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

    This image is explained by the surrounding text.

    The recovery process begins.

    This image is explained by the surrounding text.
  19. After the recovery process is finished, resume the SnapVault Relationships, if required.

    This image is explained by the surrounding text.