SAP HANA Multitenant Database Container Backups

You can back up the SYSTEMDB database, and the tenant databases.

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 Backup

You can use any of the following tools to perform the backup:

If you want to run an incremental or differential backup, you must run SAP HANA SPS10 or later.

Tool

Full

Incremental

Differential

CommCell Console

DBA Cockpit

SAP HANA Studio Interface

Select Backint as the Destination Type. For information on the SAP HANA Studio interface, see the SAP HANA documentation.

SQL Console of SAP HANA Studio

hdbsql command from the Command Line Interface

Note: Select Backint as the interface program.

hdbsql command from the Crontab file

Note: Select Backint as the interface program.

d

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

Loading...