NetWorker: Recover SAP HANA database using the prefix option

Summary: This article describes a method of recovering of SAP HANA database using the prefix. This article can also be used if older SID is to be recovered on the host.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

Symptoms

It is not possible to recover the database using catalog.
HANA catalog does not list the backup that you want to recover. 
Host2 was originally running the SID XYZ database.
The backup administrator or DBA had done earlier a directed recovery of the database of the SID ABC on host1 to a SID XYZ on the host2 (over written XYZ). 
The backup administrator or DBA wants to recover SID XYZ (original SID) back on the host2 machine.
Recovery is pulling catalog information of SID ABC (a recent backed up catalog) and not the XYZ that the DBA wants.

Cause

Database restores using current catalog of ABC on host2. Must be able to recover the database not listed in the HANA catalog. 

Resolution

It is highly recommended the use of a prefix to uniquely identify HANA database backup. See NMSAP Administration Guide for more information.

To specify the dynamic generation of a timestamp for the backup prefix:

  • For a wizard configuration, select Append the timestamp to the backup file prefix on the Specify the SAP HANA Information page in the NMSAP wizard.
  • For a client-side configuration, set the parameter HANA_DYNAMIC_PREFIX in the nsrsapsv.cfg configuration file.

Recovery of HANA database using hdbstudio
1. To restore only the specified data backup, select "Recover the database to a specific data backup" in hdbstudio.
2. Recover without the catalog.
3. Destination: Backint
4. Backup prefix: <Provide prefix> 

Recovery of HANA database using command line to recover the SID.
su - sidadm
./HDBSettings.sh recoverSys.py --command="RECOVER DATA USING BACKINT ('/usr/sap/AAA/SYS/global/hdb/backint/foooo') CLEAR LOG"

Affected Products

NetWorker Module for SAP

Products

NetWorker Module for SAP
Article Properties
Article Number: 000173781
Article Type: Solution
Last Modified: 31 Mar 2026
Version:  7
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.