All Products
Search

This Product

    Cloud Backup:Restore an SAP HANA database

    Document Center

    Cloud Backup:Restore an SAP HANA database

    Last Updated:Dec 26, 2025

    After you back up an SAP HANA database to a Cloud Backup vault, you can restore the database. You can restore it to the source SAP HANA instance, another instance in the same vault, or an instance in another region.

    Prerequisites

    Precautions

    Cloud Backup automatically stops the SAP HANA database during a restore. The database is inaccessible during this time.

    Restore a database to the source instance in the same region

    To restore a database to the source SAP HANA instance in the same region, perform the following steps:

    1. Log on to the Cloud Backup console.

    2. In the navigation pane on the left, choose Backup > SAP HANA Backup.

    3. In the upper-left corner of the top menu bar, select a region.

    4. On the SAP HANA Backup page, click the SAP HANA Instances tab. Click Restore next to the target instance.

    5. On the Create Restore Job tab, select the source SAP HANA instance and click Next.

      image

    6. Confirm the source and destination SAP HANA instance information. Select the destination database and click Next.

      Important

      In cross-instance restore and enhanced restore modes, Cloud Backup automatically stops the running destination database instance. This ensures data consistency and that the restore job executes successfully.

      Note

      • If the source database was accidentally deleted and cannot be found, you must create a new database with the same name in SAP HANA before you can perform the restore operation.

      • When Use Backint For Catalog Backup is enabled in the backup parameters of the target SAP HANA database, you can enable Enhanced Recovery Mode. This mode lets you directly read the backup catalog through the Backint interface and perform a restore operation if the local SAP HANA instance fails.

      image

    7. Select a Recovery Method based on your needs, configure the parameters, and click Next.

      恢复规则

      The following describes the configuration items:

      Recovery mode

      Description

      Configuration

      Most Recent

      Restores the database to the most recent available state from the backup.

      • Use Differential Backup: If you want to use a differential backup or an incremental backup to restore the database, enable this option. If you disable this option, Cloud Backup uses a log backup to restore the database.

      • Initialize Log Area: Select this option if you do not want to restore the log entries in the log area. After the restore, the log entries are deleted from the log area.

      • Validate Differential And Log Backups: If you enable this option, Cloud Backup checks whether the required differential backup and log backup are available before the restore job starts. If the differential backup or log backup is unavailable, Cloud Backup does not start the restore job.

      Specific Point in Time

      Restores the database to a specific point in time.

      • Use Differential Backup: If you want to use a differential backup or an incremental backup to restore the database, enable this option. If you disable this option, Cloud Backup uses a log backup to restore the database.

      • Initialize Log Area: If you do not want to restore the log entries in the log area, select this option to delete them after the restore is complete.

      • Validate Differential And Log Backups: If you enable this option, Cloud Backup checks whether the required differential backup and log backup are available before the restore job starts. If the differential backup or log backup is unavailable, Cloud Backup does not start the restore job.

      • Time Point: Select a point in time to which you want to restore the database. Cloud Backup restores the database to the restore point that is closest to the specified point in time.

      Specific Data Backup

      Restores the database from a specific database backup.

      Use Catalog: Specifies whether to use the catalog to find backups.

      Note

      If you do not use the catalog, you must specify a backup prefix. Cloud Backup restores the database based on the prefix.

      Log Position

      Restores the database to a specific log position.

      • Use Differential Backup: If you want to use a differential backup or an incremental backup to restore the database, enable this option. If you disable this option, Cloud Backup uses a log backup to restore the database.

      • Initialize Log Area: Select this option to initialize the log area. This action deletes all log entries, and they cannot be recovered.

      • Validate Differential And Log Backups: If you enable this option, Cloud Backup checks whether the required differential backup and log backup are available before the restore job starts. If the differential backup or log backup is unavailable, Cloud Backup does not start the restore job.

      • Log Position: The point in the log to which you want to recover.

      • Volume ID: The volume that you want to restore.

    8. Select a backup version to restore and click Create.

    Restore a database to another instance in the same region

    The procedure to restore a database to another SAP HANA instance in the same region and repository is similar to a same-instance restore. The only differences are that you must select a different SAP HANA instance as the destination, and you must enable the Use Backint For Catalog Backup option for the destination SAP HANA database. For information about how to enable the Use Backint For Catalog Backup option, see Configure backup parameters.

    Important

    A cross-instance restore overwrites the backup catalog of the destination database. This prevents you from restoring the database to a previous backup point. We recommend that you perform a full backup immediately after the restore is complete to ensure the database is protected.

    image

    In addition, after you confirm that the source and destination instance information is correct, you must specify the Source Database Name parameter. This parameter specifies the name of the source database that you want to restore. Set the parameter to the Source database name@SID format.image

    Note

    For the remaining steps of a cross-instance restore, see Restore a database to the source instance in the same region.

    Restore an instance across backup vaults in the same region

    Assume that in the same region, HANA instance e1 is backed up to backup vault v1, and HANA instance e2 is backed up to backup vault v2. This section describes how to restore data from HANA instance e1 to HANA instance e2.

    image

    1. Log on to the Cloud Backup console.

    2. In the navigation pane on the left, choose Backup > SAP HANA Backup.

    3. In the upper-left corner of the top menu bar, select the region where the HANA instances reside.

    4. Delete the node of HANA instance e2.

      Click the instance ID of e2 to open the HANA Instance Information page. On the Node Information tab, delete the node.

      Important

      Deleting a node interrupts its backup jobs. Existing backup data is not lost, but new data on the node will no longer be backed up. This action poses a risk of data loss. Before you delete the node, confirm that the node data in instance e2 is no longer needed or has been backed up.

      image

      image

      After the node is deleted, the status of HANA instance e2 changes to Initialization Failed.

      image

    5. Register a temporary HANA instance (e3).

      1. On the SAP HANA Instances tab, click Register HANA Instance.

        image

      2. In the Register HANA Instance panel, select the v1 backup vault, enter the required parameters for instance e3, and complete the registration. Then, configure backup parameters. For more information about the parameters, see Register an SAP HANA instance.

        image

    6. Restore the data from HANA instance e1 to HANA instance e3. For more information, see Restore a database to another instance in the same region.

    7. Delete the node of HANA instance e3.

      Click the instance ID of e3 to open the HANA Instance Information page. On the Node Information tab, delete the node.

      image

    8. Add the node of HANA instance e3 to instance e2.

      Click the instance ID of e2 to open the HANA Instance Information page. Click Add HANA Node and select the node from instance e3 that you deleted in the previous step. Cloud Backup automatically deploys a backup client on the selected node. This completes the process of restoring data from HANA instance e1 to HANA instance e2.

      image

    Restore a database to an instance in another region

    A backup vault is a cloud-based storage repository in Cloud Backup that stores backup data. For disaster recovery purposes, you can use a replication destination backup vault to restore an SAP HANA database across regions.

    Before you use a replication destination backup vault to restore an SAP HANA database across regions, you must create a replication destination backup vault and configure cross-region backup.

    To restore a database to an SAP HANA instance in another region, perform the following steps:

    1. Log on to the Cloud Backup console.

    2. In the navigation pane on the left, choose Backup > SAP HANA Backup.

    3. Select the region where the replication destination backup vault is located.

    4. On the SAP HANA Instances tab, install a backup client on the destination SAP HANA instance.

      Note

      For the Backup Vault parameter, select the replication destination backup vault that you created. The name of a replication destination backup vault contains [COPY]. For more information about other parameters for installing a backup client, see Register an SAP HANA instance.

    5. Find the SAP HANA instance for the restore, and in the Actions column, click Restore.

      The remaining steps are similar to those for a cross-instance restore in the same region.

    Restore a database to another database in the same instance

    You can use SAP HANA Studio to restore a database to another database within the same SAP HANA instance.

    1. Open SAP HANA Studio and connect to the destination SAP HANA instance.

    2. Right-click the destination database instance and choose Backup and Recovery > Recover Tenant Database.

      Tenant

    3. Select TenantDB.

      choose

    4. In the Specify Recovery Type window, select Recover the database to a specific data backup.

    5. In the Specify Backup Location window, configure the following parameters.

      • Select Recover using the backup catalog.

      • Select Search for the backup catalog in Backint only.

      • Select Backint System Copy.

      • In the Source System field, enter DBNAME@SID.

        DBNAME is the name of the source database. SID is the ID of the current database instance.

    6. Follow the wizard to stop the database and select the backup to restore.

      Important

      If you do not find the required backup in the Backups list, Use Backint For Catalog Backup is not enabled. For information about how to enable Use Backint For Catalog Backup, see Configure backup parameters.

      backups

    7. Confirm the restore settings and click Finish.

    Restore an SAP HANA database using a prefix

    You can restore an SAP HANA instance using a prefix in the following scenarios:

    • If an SAP HANA database instance is stopped, Cloud Backup cannot retrieve historical backups from the catalog. As a result, you cannot restore the SAP HANA instance.

    • After you restore an SAP HANA database to another instance, Cloud Backup cannot restore the database from its previous backups because the catalog is overwritten.

    1. You can retrieve the historical backup prefix from the catalog.

      1. Log on to the SAP HANA instance using the Secure Shell (SSH) protocol.

      2. Run the following command to obtain the prefix of a historical backup.

        Replace {SID}, {InstanceNumber}, {hostname}, and {DBNAME} with the parameters of your SAP HANA instance.

        cat /usr/sap/{SID}/HDB{InstanceNumber}/{hostname}/trace/DB_{DBNAME}/backup.log  | grep COMPLETE_DATA_BACKUP

        For example, you can run the cat /usr/sap/HXE/HDB90/yzs-hana-daily/trace/DB_HXE/backup.log | grep COMPLETE_DATA_BACKUP command to obtain the prefix.

        2022-06-02T20:38:51+08:00  P0007269      181246cfc22 INFO    BACKUP   command: BACKUP DATA FOR HXE USING BACKINT ('/usr/sap/HXE/SYS/global/hdb/backint/DB_HXE/COMPLETE_DATA_BACKUP_2022_06_02_20_38') ASYNCHRONOUS
2022-06-02T20:38:51+08:00  P0007269      181246cfc22 INFO    BACKUP   to  backint: /usr/sap/HXE/SYS/global/hdb/backint/DB_HXE/COMPLETE_DATA_BACKUP_2022_06_02_20_38_databackup_0_1
2022-06-02T20:38:51+08:00  P0007269      181246cfc22 INFO    BACKUP   to  backint: /usr/sap/HXE/SYS/global/hdb/backint/DB_HXE/COMPLETE_DATA_BACKUP_2022_06_02_20_38_databackup_2_1
2022-06-02T21:38:51+08:00  P0007269      18124a3ea82 INFO    BACKUP   command: BACKUP DATA FOR HXE USING BACKINT ('/usr/sap/HXE/SYS/global/hdb/backint/DB_HXE/COMPLETE_DATA_BACKUP_2022_06_02_21_38') ASYNCHRONOUS
2022-06-02T21:38:51+08:00  P0007269      18124a3ea82 INFO    BACKUP   to  backint: /usr/sap/HXE/SYS/global/hdb/backint/DB_HXE/COMPLETE_DATA_BACKUP_2022_06_02_21_38_databackup_0_1
2022-06-02T21:38:51+08:00  P0007269      18124a3ea82 INFO    BACKUP   to  backint: /usr/sap/HXE/SYS/global/hdb/backint/DB_HXE/COMPLETE_DATA_BACKUP_2022_06_02_21_38_databackup_2_1

        The prefix is the COMPLETE_DATA_BACKUP_2022_06_02_20_38 part.

    2. In the Cloud Backup console, create a restore job using a prefix.

      1. Log on to the Cloud Backup console.

      2. In the navigation pane on the left, choose Backup > SAP HANA Backup.

      3. In the upper-left corner of the top menu bar, select a region.

      4. On the SAP HANA Backup page, click Restore next to the target instance.

      5. On the Create Restore Job tab, select the source SAP HANA instance and click Next.

        备份

      6. Confirm the source and destination SAP HANA instance information, select the database to restore, and click Next.

        选择数据库

      7. In the Restore Rule step, configure the following parameters and click Next.

        指定备份

        Recovery procedures

        Description

        Configuration

        Recovery Mode

        You can configure the recovery method.

        Select Specified Backup.

        Use Catalog

        Specifies whether to find the backup from the catalog.

        Turn off the Use Catalog switch.

        Backup Prefix

        The prefix of a backup. Cloud Backup finds the backup based on the specified prefix and restores the backup.

        Set this parameter to the prefix that you obtained in Step 1. Example: COMPLETE_DATA_BACKUP_2022_06_02_20_38.

    3. Select a backup version to restore and click Create.

    More Operations

    You can view the status of restore jobs or cancel jobs that are in progress.

    1. In the navigation pane on the left, choose Backup > SAP HANA Backup.

    2. On the SAP HANA Backup page, click the Restore Jobs tab.

    3. In the list of restore jobs, view the status of each job.

    4. To cancel a restore job that is in progress, find the job and click Cancel in the Actions column.