Restore and recovery

Contributors Download PDF of this page

The following section describes the restore and recovery workflows for a HANA MDC single-host, single tenant system. The differences for a multiple host system are described.

The examples show SAP HANA Studio as a tool to execute manual recovery. You can also use SAP HANA Cockpit or HANA SQL statements for the recovery operations.

To restore and recover an SAP HANA MDC single-tenant system using SAP HANA Studio and SnapCenter Service, complete the following steps:

  1. Prepare the restore and recovery process with SAP HANA Studio:

    1. Select Recover System Database and confirm the shutdown of the SAP HANA system.

    2. Select the recovery type and the log backup location.

      The list of data backups displays.

    3. Select the relevant backup to see the external backup ID.

  2. Unmount the HANA data volumes.

  3. Perform the restore process with SnapCenter Service:

    1. In the Backup view, select the backup that matches the external backup ID or comment field from SAP HANA Studio.

    2. To start the restore operation, select Restore in the context menu.

  4. Mount the HANA data volumes.

  5. Run the recovery process for the system database with SAP HANA Studio:

    1. Click Refresh from the backup list and select the available backup for recovery (indicated with a green icon).

    2. Start the recovery operation.

      After the recovery operation is finished, the system database is started.

  6. Run the recovery process for the tenant database with SAP HANA Studio:

    1. Select Recover Tenant Database and select the tenant to be recovered.

    2. Select the recovery type and the log backup location.

      A list of data backups displays. Because the data volume has already been restored, the tenant backup indicates as available (in green).

    3. Select the backup and start the recovery process. After the recovery process is finished, the tenant database is started automatically.

The following steps describe the restore and recovery operations of HANA system PR1:

  1. To start the recovery of the system database, in SAP HANA Studio, go to Backup and Recovery Recover System Database option.

    Error: Missing Graphic Image

  2. Select the recovery type and click Next.

    Error: Missing Graphic Image

  3. Provide the location of the backup catalog and click Next.

    Error: Missing Graphic Image

  4. A list of available backups is displayed based on the content of the HANA backup catalog. Choose the required backup and note the external backup ID, for example, as shown in the following screenshot, the most recent backup.

    Error: Missing Graphic Image

  5. Unmount all data volumes.

    umount /hana/data/PR1/mnt00001
    Note For an SAP HANA multiple host system, you must unmount all the data volumes on each host.
  6. From the SnapCenter Service UI, select View Backups in the context menu of the SAP HANA Systems view.

  7. To start the restore operation, in the Backup view, select the most recent backup, which also shows in HANA Studio, and select Restore in the context menu.

    Error: Missing Graphic Image

  8. To confirm the restore operation, click Yes, Restore.

    Error: Missing Graphic Image

    The SnapCenter Service job log shows the progress of the restore operation.

    Error: Missing Graphic Image

  9. Wait until the restore process completes. On each database host, mount all the data volumes. In the following example, you must remount only one volume on the database host:

    mount /hana/data/SP1/mnt00001
  10. To update the list of available backups, go to SAP HANA Studio and click Refresh. The backup that was restored with SnapCenter Service is shown with a green icon in the list of backups. Select the backup and click Next.

    Error: Missing Graphic Image

  11. Provide the location of the log backups. Click Next.

    Error: Missing Graphic Image

  12. Select other settings as required. Make sure Use Delta Backups is not selected. Click Next.

    Error: Missing Graphic Image

  13. Review the recovery settings and click Finish.

    Error: Missing Graphic Image

    The recovery process starts. Wait until the recovery of the system database completes.

    Error: Missing Graphic Image

  14. In SAP HANA Studio, select the entry for the system database and go to Backup and Recovery Recover Tenant Database.

    Error: Missing Graphic Image

  15. Select the tenant to recover and click Next.

    Error: Missing Graphic Image

  16. Specify the recovery type and click Next.

    Error: Missing Graphic Image

  17. Confirm the backup catalog location and click Next.

    Error: Missing Graphic Image

  18. Confirm that the tenant database is offline. Click OK to continue.

    Error: Missing Graphic Image

    Because the restore of the data volume has occurred before the recovery of the system database, the tenant backup is immediately available.

  19. Select the backup highlighted in green and click Next.

    Error: Missing Graphic Image

  20. Confirm the log backup location and click Next.

    Error: Missing Graphic Image

  21. Select other settings as required. Make sure Use Delta Backups is not selected. Click Next.

    Error: Missing Graphic Image

  22. Review the recovery settings and start the recovery process of the tenant database by clicking Finish.

    Error: Missing Graphic Image

  23. Wait until the recovery has finished and the tenant database is started.

    Error: Missing Graphic Image

    The SAP HANA system is up and running.

For an SAP HANA MDC system with multiple tenants, you must repeat steps 15 to 24 for each tenant.