Dell EMC Data Domain systems work seamlessly with a range of backup, archive, and enterprise applications. The new generation of midsize and large enterprise Data Domain systems are powered with flash solid-state drives (SSDs). For more information, see the Dell EMC Data Domain Deduplication Storage Systems specification sheet. By consolidating backup and archive data on a Data Domain system, you can reduce storage requirements by 10 to 55 times, making disks cost-effective for onsite retention and highly efficient for network-based replication to DR sites.
Data Domain Boost connection to SAP HANA backup interface
The SAP HANA database provides a backup interface called Backint for SAP HANA. This backup interface enables third-party backup tools such as Data Domain Boost for Enterprise Applications (DDBEA) to connect to the backup and recovery capabilities of the SAP HANA database. Because Backint for SAP HANA is fully integrated into the SAP HANA database, you can individually configure data and log backups to be created and recovered using DDBEA.
A DDBEA backup to a Data Domain system uses the DD Boost feature as follows:
- The DD Boost library API enables the backup software to communicate with the Data Domain system.
- The DD Boost distributed segment processing (DSP) component reviews the data that is already stored on the Data Domain system and sends only unique data for storage. The DSP component enables the backup data to be deduplicated on the database or application host to reduce the amount of data that is transferred over the network. During the restore of a backup to the client, the Data Domain system converts the stored data to its original non-deduplicated state before sending the data over the network.
Configuring Data Domain for SAP HANA
To configure Data Domain for SAP HANA:
- Install the DDBEA software on the operating system of the database host.
- Manually create the following subdirectory if it does not already exist:
- Copy the /opt/ddbda/bin/hdbbackint file to the subdirectory that you specified in step 2. Alternatively, as shown in the following figure, create a symbolic link that points to the executable file from the following directory:
Figure 7. Create symbolic link command
- Modify the parameter settings of the SAP HANA template configuration file /opt/ddbda/config/sap_hana_ddbda.utl, as shown in the following figure.
Figure 8. Modifying the configuration file parameter settings
- Configure the DDBDA lockbox by using ddbmadmin –P –Z <configuration_file>, where <configuration_file> is the file that you used in step 4.
Note: This example of configuring SAP HANA for backup and recovery uses X22 as the SAP HANA <SID>. If you are configuring the multinode cluster, repeat steps 2–5 for all nodes.
- In the SAP HANA Studio UI, specify the location of the DDBEA configuration file for data and log backup, as shown in the following figure.
Figure 9. Specifying the DDBEA configuration file location
For more information, see the Dell EMC Data Domain Boost for Enterprise Applications and ProtectPoint Database Application Agent Installation and Administration Guide.
Backing up the database from SAP HANA Studio
To back up the SAP HANA database:
- Log in to SAP HANA Studio, and then select Backup and Recovery, as shown in the following figure.
Figure 10. SAP HANA Studio Backup and Recovery screen
- Select the tenant database, as shown in the following figure. Note that the LOAD database is for illustration purposes only.
Figure 11. Specifying the tenant database
- Select Backint as the destination type, as shown in the following figure.
Figure 12. Specifying the backup destination
- Review the backup settings, as shown in the following figure.
Figure 13. Review Backup Settings
- Click Finish to start the backup.
Recovering the database with SAP HANA Studio
Restore the SAP HANA database to the point when you backed it up:
- Log in to the SAP HANA Studio, and then select Backup and Recovery.
- Select the tenant database.
- Select Recover the database to the most recent state, as shown in the following figure.
Figure 14. Specifying the recovery type
- Specify a location for the log backups, as shown in the following figure.
Figure 15. Specifying the log backup location
- Select the point in time to which you want to restore the database, as shown in the following figure.
Figure 16. Specifying a recovery point in time
- Select Third-Party Backup Tool (Backint) as the backup tool.
- Review the recovery settings, and then click Finish.