Wednesday, January 9, 2019

Prerequisites and Must know Configure or integrate Online Database backup for SAP HANA Online Database

2:06 PM Posted by ChinniLax No Comments

SAP HANA Online Database Backup integration/Configuration

The Data Protector SAP HANA integration provides online backup of the SAP HANA database and the SAP HANA redo logs.

Full: This is backup of a complete SAP HANA database.
Trans: This is backup of SAP HANA redo logs.
Incremental: This backup stores the last modified data backup.
Differential: This backup store all the data changed since the last full data backup

Below details are captured as per Data Protector backup tool:

You can back up the following entities using the Data Protector SAP HANA integration:

Current implementation of the Data Protector SAP HANA integration does not include a conventional Data Protector application integration agent. In only enables you to use Data Protector to:

Define which data needs to be backed up, how it should be backed up, and where the backup images should be stored—by configuring SAP HANA backup specifications in the Data Protector GUI
Monitor progress of the Data Protector SAP HANA backup and restore sessions
List SAP HANA objects backed up by Data Protector and their corresponding sessions

Timing aspects of the backup and restore processes (for example, when the backup sessions are started and when and where the data is restored to) as well as the database recovery options are governed by the SAP HANA Appliance itself. You can only define and control them from the SAP HANA Appliance GUI (SAP HANA Studio), SAP HANA Cockpit, DBA Cockpit or CLI (the SAP HANA hdbsql command-line utility).
The Data Protector SAP HANA backint agent consists of the saphana_backint binary file that acts as an interface between Data Protector and the SAP HANA Appliance backup and restore functionality.
Both SAP HANA database and SAP HANA redo logs are backed up and restored as streams.
Previews of SAP HANA backup and restore sessions are not available.
Two backup specifications are required for data and logs files. Select different devices for data and log backup specifications. But select same files for data and log backup specifications.

Add SAP HANA OS user to Data Protector admin or operator user group.
Create a symbolic link to the Data Protector implementation of the backint agent:

Execute the commands:#ln -s /opt/omni/lbin/saphana_backint InstallationPath/InstanceID/global/hdb/opt/hdbbackint (create opt directory under InstallationPath/InstanceID/global/hdb if not already available)
You can verify that you properly linked the backint agent in SAP HANA Studio by inspecting the Backint Agent option in the Backup > Configuration > Backint Settings context.

SAP HANA Studio> Expand SAP HANA instance > Backup > Configuration > expand Backint settings > Under Log Backup Settings, select Backint for the Destination Type option. Make sure the option Enable Automatic Log Backup is selected
Switch to Administration Console view: double click any SAP HANA instance > configuration tab > expand the global.ini tree > expand the persistence subtree > makesure the value of “Log_mod” parameter is normal

Create two parameter files for data and log file backup specifications
Save the file to the folllwing directory: InstallationPath/InstanceID/global/hdb/opt/hdbconfig
Then Launch SAP HANA Studio > Expand SAP HANA instance > Select Backup > in main page select Configuration tab > expand Backint Settings > Under Backint settings > Data Backup “ Enter the full pathna,e of the parameter file in the Backint Parameter File text box
Under backing settings > Unselect the checkbox “Use same parameter of the parameter file for both data backup and log”
Under Backint settings > Log Backup, enter the fill pathname of the parameter file in the “Backint Parameter” file text box
From the File, select Save

The Data Protector SAP HANA integration provides restore of the SAP HANA database and the SAP HANA redo logs.
Database of the target SAP HANA instance must be offline.
SAP HANA Studio can automatically take the database offline when a restore session is initiated. In contrast, before using the hdbsql command-line utility for restoring or recovering an SAP HANA database, you need to take the database offline manually.