Restore and recovery

10/05/2023 Contributors

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:

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.
Unmount the HANA data volumes.
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.
Mount the HANA data volumes.
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.
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:

To start the recovery of the system database, in SAP HANA Studio, go to Backup and Recovery Recover System Database option.
Select the recovery type and click Next.
Provide the location of the backup catalog and click Next.
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.
Unmount all data volumes.
```
umount /hana/data/PR1/mnt00001
```
For an SAP HANA multiple host system, you must unmount all the data volumes on each host.
From the SnapCenter Service UI, select View Backups in the context menu of the SAP HANA Systems view.
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.
To confirm the restore operation, click Yes, Restore.

The SnapCenter Service job log shows the progress of the restore operation.
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
```
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.
Provide the location of the log backups. Click Next.
Select other settings as required. Make sure Use Delta Backups is not selected. Click Next.
Review the recovery settings and click Finish.

The recovery process starts. Wait until the recovery of the system database completes.
In SAP HANA Studio, select the entry for the system database and go to Backup and Recovery Recover Tenant Database.
Select the tenant to recover and click Next.
Specify the recovery type and click Next.
Confirm the backup catalog location and click Next.
Confirm that the tenant database is offline. Click OK to continue.

Because the restore of the data volume has occurred before the recovery of the system database, the tenant backup is immediately available.
Select the backup highlighted in green and click Next.
Confirm the log backup location and click Next.
Select other settings as required. Make sure Use Delta Backups is not selected. Click Next.
Review the recovery settings and start the recovery process of the tenant database by clicking Finish.
Wait until the recovery has finished and the tenant database is started.

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.

Restore and recovery

Creating your file...