Running SAP HANA Backup Job

This chapter provides a comprehensive guide on how to perform backups for SAP HANA applications using the Catalogic DPX plugin. The Catalogic DPX plugin is easily installed and configured on the SAP HANA system using a script named dpxhdbinst. This script is available in the /opt/DPX/misc/ directory after the Catalogic DPX Client is installed on the SAP HANA system.

Prerequisites

Before running the installation and configuration script, ensure that you have the following information available from your environment:

• The hostname or IP of the DPX Master Server.

• The username of the DPX administrator account (default: dpxadmin).

• The password of the DPX administrator account (default: dpxadmin).

• The fully qualified path to the DPX root directory.

• The logical hostname of the SAP HANA node.

• The name of the DPX media pool that will be used.

• The name of the DPX device cluster that will be used as a backup target.

• The name of the DPX device that will be used as a backup target.

• The System ID (SID) of the SAP HANA database being installed and configured.

Installing and Configuring the DPX Plugin

To install and configure the DPX plugin, follow these steps:

1. Using the secure shell protocol (SSH), log in to the SAP HANA node host.

2. At the command line, navigate to the misc directory, using:

cd /opt/DPX/misc

1. Run the installation and configuration script to install the DPX plugin, using:

./dpxhdbinst

1. When prompted, enter the following information:

• The hostname or IP address of the DPX Master Server.

• The DPX administrator account username.

• The DPX administrator account password.

• The DPX root directory (default: /opt/DPX/).

1. Enter the System ID (SID) of the SAP HANA database. This will set the HDBbackint directory to /usr/sap/<xxx>/SYS/global/hdb/opt/, where <xxx> represents the SID of the SAP HANA database to be protected.

2. Proceed with installation of the DPX plugin, press 1. Installation will create a link and change permissions of three files and one directory as indicated on the screen.

3. To continue with configuration, press 2.

4. Enter the configuration information. When prompted, enter the following:

   • The logical name of the SAP HANA node.

   • The DPX tape pool to use with the SAP HANA database.

   • The DPX device pool to use with the SAP HANA database.

   • The DPX device to use with the SAP HANA database. During configuration, a template file is edited and copied to /opt/DPX/bin/dpxhdb.utl, a link is created, and the file /usr/sap/<SID>/SYS/global/hdb/custom/config/global.ini is updated, where <SID> is the System ID.

5. Press 3 to exit the script.

Configuring the SAP HANA System for Backup

To configure the SAP HANA system for backup, follow these steps:

1. Install the SAP HANA plugin for Eclipse IDE.
2. In Eclipse IDE, click Open Perspective > SAP HANA Administration Console.

3. Right-click on Systems tab and select Add system.

4. Add your SAP Hana database to Eclipse IDE, using the following settings:

   1. Host Name: Hostname of your SAP HANA machine

   2. Instance Number: SAP HANA instance number

   3. Mode: Multiple containers > System database

1. Click Next.

2. Select options:

   1. Authentication by database user and log in using username SYSTEM

   2. Enable SAP start service connection

1. Click Finish.

2. Log in to the database.

1. Double-click on Backup button.

2. Go to Configuration tab.

3. Expand section Backint Settings and change the following settings:

   • Backint Agent: /opt/DPX/bin/ssdpxhdb

   • Backint Parameter File: /usr/sap/<xxx>/SYS/global/hdb/opt/hdbconfig/dpxhdb.utl, where <xxx> represents the SID of the SAP HANA database

Running SAP HANA Backup

To perform backups, follow these steps:

1. Open Eclipse IDE and log in to the system database.

2. Right-click on the system database and select Backup and Recovery > Backup System Database.

1. Select Backint as the destination type.

2. Click Finish to start the backup.

Note. The backup log is located in the /opt/DPX/bin/dpxhdb.utl file. Make sure the backup log is the same as the one specified in the dpxhdb.utl file.

Monitoring SAP HANA Backup Jobs in DPX

Once you created and ran SAP HANA Backup Job, you can monitor jobs using DPX:

1. In the main web interface view, go to Job Monitor in the sidebar.

2. You should see a new job with status Running, type Application Backup and Name containing the IP address of the SAP HANA node.