SAP HANA Online Database Backup integration/Configuration
Backup Types:
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:
Considerations:
- You can back up the following
entities using the Data Protector SAP HANA integration:
- SAP HANA database
- SAP HANA redo logs
- 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.
Prerequisites:
- 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.
- Adjusting SAP HANA backup
settings for redo logs:
- 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
- Creating Data Protector parameter
files for SAP HANA:
- Start a plain text editor with
following parameters:
- OB2BARLIST='BackupSpecificationName';
- OB2BARHOSTNAME='SystemName';
- 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
Restore:
- 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.
0 Comment to "Prerequisites and Must know Configure or integrate Online Database backup for SAP HANA Online Database"
Post a Comment