Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.14 SAP HANA User Guide

Performing recovery by using the SAP HANA CLI

To perform a recovery of an SAP HANA backup, you can use an SQL command.

NOTE:The SAP HANA Studio GUI is the recommended method to perform a restore and recovery.

To run the recovery SQL command, you must be logged in to the SAP HANA system as the OS user <SID>adm. In a scale-out multinode environment, you must run the command from the primary node.

The recovery command must first include the HDBSettings.sh and recoverSys.py scripts in that order. The HDBSettings.sh script sets the environment for recovery. The recoverSys.py script processes the recovery SQL command and performs the database recovery.

The following example command performs a recovery of an SAP HANA backup:

./HDBSettings.sh recoverSys.py --command="recover database until
timestamp '2014-02-28 00:00:00' using data path
('/usr/sap/AAA/SYS/global/hdb/backint/') using log path
('/usr/sap/AAA/SYS/global/hdb/backint/') using BACKUP_ID 1593520382350" --wait

You must include the --wait option for proper completion of the recoverSys.py script.

The SAP HANA Administration Guide provides details about the SQL command syntax of the recovery command.


Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\