PowerProtect Data Manager 19.9 SAP HANA Agent 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.

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.