Backing up SAP HANA data
You can define backup jobs to protect your SAP HANA data. To regularly back up your data, define a backup job that includes a service level agreement (SLA) policy.
Before you begin
During the initial backup operation, IBM Spectrum® Protect Plus creates a vSnap volume and Network Files System (NFS) share. During incremental backups, the previously created volume is reused. The IBM Spectrum Protect Plus SAP HANA agent mounts the share on the SAP HANA server where the backup is completed.
Review the following prerequisites before you create a backup job definition:- Add the application servers that you want to back up. For the procedure, see Adding an SAP HANA application server.
- Configure an SLA Policy. For the procedure, see Defining a Service Level Agreement backup job.
- Before an IBM Spectrum Protect Plus user can set up backup and restore operations, roles and resource groups must be assigned to the user. Grant users access to resources, and backup and restore operations, in the Accounts pane. For more information, see Managing user access.
- Make sure that you have the required privileges to protect the resources. Run the following
command in SAP HANA
hdbsql utility to grant the required
privileges:
create user sppadmin password MyPassw0rd no force_first_password_change grant backup admin, catalog read, inifile admin, database recovery operator to sppadmin
where sppadmin specifies the username, MyPassw0rd specifies the password, and backup admin, catalog read, inifile admin, database recovery operator are the required privileges.
- Point in time recovery is not supported when one or more tenant databases or SAP HANA services are added to the database instance in the period between the chosen point in time and the time that the preceding backup job ran.
Restriction: Do not run inventory jobs at the same time when backup jobs are
scheduled.
Procedure
What to do next
Important: If the backup operation fails with an error, follow the procedure described
in Troubleshooting failed backup operations for large Db2, MongoDB, and SAP HANA databases.