Scheduling SAP HANA backups from NetBackup

Problem

SAP HANA backups can be initiated from NetBackup using a regular NetBackup SAP backup policy to call a backup script on the SAP HANA node.

Solution

This article provides an example script that can be used with a NetBackup SAP policy. Use this script as template when configuring SAP HANA backup policies. The SAP HANA admin should modify it as per the SAP HANA environment.

Disclaimer: Please note that the script attached to this Technote is provided as is and is a sample script only. The script is not supported by NetBackup Technical support.

It is the responsibility of the customer to modify the script to take into account specific requirements and variables in his/her environment.

Steps to schedule automatic backup:

1. Verify if SAP HANA master and hostname of HANA node are same
2. Download the attached sample script and copy the  script under SAP HANA shared location
3. Verify if the script has modify and execute permission
4. Modify the script to point to path of "hdbsql". Default path used in script is "/usr/sap/<SID>/HDB01/exe/hdbsql"
5. Modify the script to provide correct “hdbsql” command parameters according to SAP HANA DB instance

         ../hdbsql -i <instance_id> -n <database_host>
                       -u <database_user> -p <database_user_password>

6. Create a "Automatic Full Backup" schedule in Policy->Schedule->Attributes tab
7. Provide the path to this modified script as the backup selection

Applies To

SAP HANA single or multi-node appliance.

Appliance Operating System:
SUSE SLES 11 SP2