Schedule automatic delta backups (differential and incremental) of SAP HANA 1.0 SPS 10 and later from the NetBackup Administration Console
Problem
You can add scripts to the backup selections list to set up a policy for automatic backups. You can use the example script attached in this article for an automatic backup schedule.Note: You must modify this script according to your environment.
Environment
- NetBackup 7.6.1.2 and later
- SAP HANA SPS 10 and later (single or multi-node appliance)
- Appliance operating system: SUSE SLES 11 SP3 and RHEL 6.5
Solution
Use the attached script as a template when configuring SAP HANA backup policies. Steps to schedule an automatic backup using the example script:- Verify that the SAP HANA master and hostname of the HANA node are same.
- Download the sample script attached in this article and copy the script in a shared location on the machine that has SAP HANA installed.
Note: You must change the extension of the script file to .sh - Verify if the script has modify and execute permissions.
- Modify the script to point to path of "hdbsql".
- Default path in the script is "/usr/sap/<SID>/HDB<ID>/exe/hdbsql"
- Modify the script to provide correct “hdbsql” command parameters as per your SAP HANA database instance
../hdbsql -i <instance_id> -n <database_host>
-u <database_user> -p <database_user_password> - Perform one of the following steps:
- To perform a complete data backup, in the NetBackup Administration Console, go to Policies > Schedules. In the new schedule window > Attributes tab, select Automatic Full Backup as the Type of backup.
- To perform a differential data backup, go to Policies > Schedules. In the new schedule window > Attributes tab, select Automatic Differential Incremental Backup as the Type of backup.
- To perform an incremental data backup, go to Policies > Schedules. In the new schedule window > Attributes tab, select Automatic Cumulative Incremental Backup as the Type of backup.
- To use the script, add a new backup selection in the Backup Selections tab. Click Browse and provide the path of the modified script as the backup selection.
For more details, see the Creating a backup policy for SAP HANA topic in the Veritas NetBackup™ for SAP Administrator's Guide.
Disclaimer!
Please note that any scripts attached to this Technote are provided as is and are sample scripts only. The scripts are not supported by Netbackup Technical support.
It is the responsibility of the customer to modify the scripts to take into account specific requirements and variables in his/her environment.
Attachments
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.