A SAP HANA database system is represented by an instance system identifier (SID). The database consists of one or more database nodes. Each database node has data information, log information and services such as Name Server, Index Server, Statistics Server and XS Engine.
You can perform a backup from the CommCell Console, or from the SAP HANA Studio.
The SAP HANA database is a combination of services that invoke backint. The SAP HANA software determines and controls the number of streams to use for the backup by looking at services that are on the SAP HANA database.
The following backup types are available for SAP HANA:
Note
The following functionality applies to Commvault SP 10 and later. When you perform your first backup, the Commvault software automatically performs the following configuration. For information on how to verify the changes, see How do I verify the automatic update of the global.ini file and SAP HANA parameter file?
-
Creates a symbolic link that points to a parameter file created by Commvault called param under the SAP /usr/sap/<SID>/SYS/global/hdb/opt/hdbconfig/ directory.
-
Creates a symbolic link that points to the Commvault backint binary with SAP HANA hdbbackint under the SAP /usr/sap/<SID>/SYS/global/hdb/opt directory.
-
Updates the global.ini file with the correct parameters based on your Multitenant Database Container configuration, for example SAP HANA 1.0 or 2.0.
-
For SAP HANA 2.0 configurations, updates the SAP HANA catalog_backup_parameter_file and catalog_backup_using_backint parameters in the global.ini file. For more information, see Configuring the SAP HANA 2.0 including the Express Edition global.ini File to Use the backint Interface.
Perform a SAP HANA Backup
Perform a backup by using the SAP HANA Studio and select backint as the Destination Type. For information on the SAP HANA Studio interface, see the SAP HANA documentation.
You can also use any of the following tools to perform the backup:
Note
When you perform the backup by using the hdbsql command, select Backint as the interface program.
If you want to run an incremental or differential backup, you must run SAP HANA SPS10 or later.
Tool |
Full |
Incremental |
Differential |
---|---|---|---|
DBA Cockpit |
√ |
√ |
√ |
SAP HANA Studio Interface |
√ |
√ |
√ |
SQL Console of SAP HANA Studio |
√ |
√ |
√ |
hdbsql command from the Command Line Interface |
√ |
√ |
√ |
hdbsql command from the Crontab file |
√ |
√ |
√ |
CommCell Console |
√ |
√ |
√ |
What Gets Backed Up
The SAP HANA agent backs up the following:
-
All the database files on each node
-
Log files on each node
-
Catalog files
What Does Not Get Backed Up
The SAP HANA agent does not back up the following:
-
HANA application files associated with the software installation
-
Configuration files
-
Parameter files