This document describes how to use IBM Spectrum Protect and IBM Spectrum Copy Data Management to protect SAP HANA.
This practical guide, written by Thomas Prause of IBM Germany Research & Development (version 1.0, February 13, 2020), describes how to protect SAP HANA databases by combining IBM Spectrum Copy Data Management with IBM Spectrum Protect for Enterprise Resource Planning: Data Protection for SAP HANA. It first introduces both products, then describes a real-life sample environment with screen captures and command outputs.
The guide walks through requirements and preparation, installation and configuration of both products, expiration and retention policies, daily operations, and recovery scenarios, including restoring a database to a specific point in time and variations of the recovery scenario such as a file system check during a restore and a test of a production restore operation.
| Database software | SAP HANA 2.0 SPS 04 Revision 40 |
|---|---|
| Operating system | Red Hat Enterprise Linux (RHEL) Server release 7.7 |
| Storage | IBM Spectrum Virtualize Version 7.8.0 |
| IBM Spectrum Protect for ERP | V8.1.9 |
| IBM Spectrum Copy Data Management | 2.2.10.0 (build 139) |
| Virtualization | VMware vSphere 6.0 |
| IBM Spectrum Protect server | V7.1 |
| Default redo log backup timeout | 15 minutes (900 seconds) |
| Sample network | 1 Gb Ethernet |
It is installed by deploying the *.ova file into a VMware vSphere environment, which requires an IP address that will be assigned to the instance.
It is configured by executing the setup script /opt/tivoli/tsm/tdp hana/setup.sh, which prompts for the HANA instance parameters and the IBM Spectrum Protect server, node, and management classes.
HANA backs up the redo logs once a log file becomes full or a specified length of time has elapsed; by default this value is 15 minutes.
The first policy creates a regular FlashCopy of the volumes and keeps the copies for 5 days; the second one creates an incremental FlashCopy, of which only one is retained in the sample environment.