Skip to Content

Database Recovery With HANA Dynamic Tiering

Recover databases with Dynamic Tiering.
You will learn
  • How to choose which type of recovery to perform
  • How to select backup location and prefixes
joannaluSAPjoannaluSAPJanuary 18, 2021
Created by
June 2, 2017


  • Tutorials Creating Database Backups
  • Credentials: Have access to the SYSTEM user of SystemDB and “<SID>adm” for a SSH session on the HANA hosts.
  • Step 1

    Database recovery can be done either from a command line or from HANA Studio. The preferred way is via HANA Studio.

    From the SAP HANA Administrative Console perspective, right click on the System Database in the Systems panel with the SYSTEM user, hover over “Backup and Recovery” in the pop up menu and select “Recover Tenant Database…” Similar to backing up Tenant Databases, recovering Tenant Databases must also be done through the System Database.

    Note: You can similarly select “Recover System Database…” to recover your System Database instead.

    Open Backup Console

    If this is your first time performing a database recovery, HANA Studio will prompt you for the user credentials of the <sid>adm Linux user. After, the HANA System will prompt you to confirm stopping the database.

    Shut Down System

    Once you click OK, HANA will start to prepare the recovery wizard.

    When the Recovery Wizard is ready, you will be prompted to specify your Tenant system. Check the one you wish to recover and click Next

    Specify Tenant System

    Next, you will be prompted to choose the type of recovery. For the purpose of this lesson, we will be choosing to recover the database to a desired point in time. Select “Recover the database to the following point in time.” and then click “Next

    Recover Point in Time

    Ensure that the backup directory you will be recovering from is correct. After, click “Next

    Note: The default is shown directory is shown, which you can leave unmodified. This directory also needs to match the location chosen when creating the backup.

    Correct Backup Directory

    The backups created before the chosen time on the previous screen will appear in the recovery wizard and you can select what backup you want to recover your database to. Click the “Check Availability” button on the bottom right to ensure that backup is active.

    Check Backup Availability

    Select the desired backup and click “Next”.

    Ensure that the log backup directory is correct and click “Next” as below.

    Note: The default is shown directory is shown, which you can leave unmodified.

    Check Log Backup

    The follow settings below will now appear. You can leave the default settings and click “Next”.

    Other settings

    It will then present the “Review Recovery Settings” window. If the information matches what you’ve specified in the previous steps, then you can click “Finish” to run the recovery.

    Review Recovery Settings

    You can now view the recovery being performed for both Dynamic Tiering and the core HANA host.

    Note: To perform recovery, you should have the same or higher version of SAP HANA installed as the version used to create the BACKUP

    Data Recovery Performance

    Once the recovery process completes, the Recovery Execution Summary screen will be displayed.

    Data Recovery Summary
  • Step 2

    To perform recovery, your installed version of SAP HANA should be:

Back to top