Skip to content

Latest commit

 

History

History
146 lines (85 loc) · 8.29 KB

sap-hana-database-instances-restore.md

File metadata and controls

146 lines (85 loc) · 8.29 KB
Raw
title description ms.topic ms.date ms.service author ms.author
Restore SAP HANA database instances on Azure VMs
In this article, you'll learn how to restore SAP HANA database instances on Azure virtual machines.
conceptual
11/02/2023
backup
AbhishekMallick-MS
v-abhmallick

Restore SAP HANA database instance snapshots on Azure VMs

This article describes how to restore a backed-up SAP HANA database instance to another target virtual machine (VM) via snapshots.

Note

If you want to do an in-place restore (that is, overwrite the backed-up VM by detaching the existing disks and attaching new disks), detach the existing disks and see the following sections.

You can restore the HANA snapshot and storage snapshot as disks by selecting Attach and then mount them to the target machine. However, Azure Backup won't automatically restore the HANA system to the required point.

Here are the two workflows:

Note

SAP HANA recommends that you recover the entire system during the snapshot restore. This means that you would also restore the system database. If the system database is restored, the users/access information is also overwritten or updated, and subsequent attempts at recovery of tenant databases might fail after the system database recovery. The two options to resolve this issue are:

  • Both the backed-up VM and the target VM have the same backup key (including username and password). This means that the HANA backup service can connect with the same credentials and continue to recover tenant databases.
  • If the backed-up VM and the target VM have different keys, the preregistration script must be run after the system database recovery. This action updates the credentials on the target VM, and then the tenant databases can be recovered.

Prerequisites

Permissions required for the snapshot restore

During the restore, Azure Backup uses the target VM’s managed identity to read disk snapshots from a user-specified resource group, create disks in a target resource group, and attach them to the target VM.

The resource, permissions, and scope are listed in the following table:

Entity Built-in role Scope of permission Description
Target VM Virtual Machine Contributor The backup admin who configures and runs the HANA snapshot restore and the target VM’s managed service identity. Restores from disk snapshots to create new managed disks and attach or mount to the target VM or operating system.
Source snapshot resource group Disk Snapshot Contributor The target. Restores from disk snapshots.
The target disk resource group (where all existing disks of target VM are present, for revert).

The target disk resource group (where all new disks will be created during restore).		 Disk Restore Operator The target VM’s managed service identity. Restores from disk snapshots to create new managed disks and attach or mount to the target VM or operating system.

After the restore is completed, you can revoke these permissions.

Note

  • The credentials that are used should have permissions to grant roles to other resources. The roles should be Owner or User Access Administrator, as mentioned in Steps to assign an Azure role.
  • You can use the Azure portal to assign all the preceding permissions during the restore.

Learn about the SAP HANA instance snapshot restore architecture.

Establish network connectivity

Learn about the network configurations required for HANA instance snapshot.

Restore the entire system to a snapshot restore point

[!INCLUDE How to restore the entire SAP HANA system to a snapshot restore point]

Restore the database to a different logpoint-in-time over a snapshot

To restore the database to a different logpoint-in-time, do the following.

Select and mount the nearest snapshot

First, identify the snapshot that's nearest to the required logpoint-in-time. Then attach and mount that snapshot to the target VM.

Restore system database

To select and restore the required point in time for the system database, follow these steps:

  1. In the Recovery Services vault, on the left pane, select Backup items.

  2. Select Primary Region, and then select SAP HANA in Azure VM.

  3. On the Backup Items pane, select the View details link for the system database instance.

    :::image type="content" source="./media/sap-hana-database-instances-restore/system-database-view-details.png" alt-text="Screenshot that shows where to view details of the system database instance.":::

  4. On the systemdb items pane, select Restore.

    :::image type="content" source="./media/sap-hana-database-instances-restore/open-system-database-restore-blade.png" alt-text="Screenshot that shows how to open the 'Restore' page of the system database instance.":::

  5. On the Restore pane, select Restore logs over snapshot.

  6. Select the required VM and resource group.

  7. Below the Restore Point box, select the Select link.

    :::image type="content" source="./media/sap-hana-database-instances-restore/restore-over-snapshot.png" alt-text="Screenshot that shows how to select the log restore points of the system database instance for restore.":::

  8. On the Select restore point pane, select the restore point, and then select OK.

    [!Note] The logs appear after the snapshot point that you previously restored.

  9. Select OK.

Restore the tenant database

To restore the tenant database, do the following:

  1. In the Azure portal, go to the Recovery Services vault.

  2. On the left pane, select Backup items.

  3. Select Primary Region, and then select SAP HANA in Azure VM.

    :::image type="content" source="./media/sap-hana-database-instances-restore/select-vm-in-primary-region.png" alt-text="Screenshot that shows where to select the primary region option to back up the tenant database.":::

  4. On the Backup Items pane, select the View details link for the SAP HANA tenant database.

    :::image type="content" source="./media/sap-hana-database-instances-restore/select-view-details-of-tenant-database.png" alt-text="Screenshot that shows the 'View details' link for the HANA tenant database.":::

  5. Select Restore.

    :::image type="content" source="./media/sap-hana-database-instances-restore/restore-hana-snapshot.png" alt-text="Screenshot that shows where to select the 'Restore' option for the HANA tenant database.":::

  6. On the Restore pane, select the target VM to which the disks should be attached, the required HANA instance, and the resource group.

    :::image type="content" source="./media/sap-hana-database-instances-restore/restore-over-snapshot.png" alt-text="Screenshot that shows where to select the restore point of the log over snapshots for the tenant database.":::

    Ensure that the target VM and target disk resource group have relevant permissions by using the PowerShell or CLI script.

  7. In Restore Point, choose Select.

  8. On the Select restore point pane, select the restore point, and then select OK.

    [!Note] The logs appear after the snapshot point that you previously restored.

  9. Select OK.

Note

Ensure that you've restored all the tenant databases according to SAP HANA guidelines.

Cross region restore

The managed disk snapshots don't get transferred to the Recovery Services vault. So, cross-region restore is the only possible option via Backint stream backups.

Next steps