SAP HANA on IBM Power Systems Backup and Recovery Solutions

SAP HANA on IBM Power Systems Backup and Recovery Solutions

by Dino Quintero, Rosane Goldstein, Adriana Melges Quintanilha Weingart, Pia Nymann, Andrei Socoliuc
Released May 2021
Publisher(s): IBM Redbooks
ISBN: 9780738459691

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

This IBM® Redpaper Redbooks publication provides guidance about a backup and recovery solution for SAP High-performance Analytic Appliance (HANA) running on IBM Power Systems. This publication provides case studies and how-to procedures that show backup and recovery scenarios.

This publication provides information about how to protect data in an SAP HANA environment by using IBM Spectrum® Protect and IBM Spectrum Copy Data Manager. This publication focuses on the data protection solution, which is described through several scenarios.

The information in this publication is distributed on an as-is basis without any warranty that is either expressed or implied. Support assistance for the use of this material is limited to situations where IBM Spectrum Scale or IBM Spectrum Protect are supported and entitled, and where the issues are specific to a blueprint implementation.

The goal of the publication is to describe the best aspects and options for backup, snapshots, and restore of SAP HANA Multitenant Database Container (MDC) single and multi-tenant installations on IBM Power Systems by using theoretical knowledge, hands-on exercises, and documenting the findings through sample scenarios.

This document provides resources about the following processes:

Describing how to determine the best option, including SAP Landscape aspects to back up, snapshot, and restore of SAP HANA MDC single and multi-tenant installations based on IBM Spectrum Computing Suite, Red Hat Linux Relax and Recover (ReAR), and other products.

Documenting key aspects, such as recovery time objective (RTO) and recovery point objective (RPO), backup impact (load, duration, scheduling), quantitative savings (for example, data deduplication), integration and catalog currency, and tips and tricks that are not covered in the product documentation.

Using IBM Cloud® Object Storage and documenting how to use IBM Spectrum Protect to back up to the cloud. SAP HANA 2.0 SPS 05 has this feature that is built in natively. IBM Spectrum Protect for Enterprise Resource Planning (ERP) has this feature too.

Documenting Linux ReaR to cover operating system (OS) backup because ReAR is used by most backup products, such as IBM Spectrum Protect and Symantec Endpoint Protection (SEP) to back up OSs.

This publication targets technical readers including IT specialists, systems architects, brand specialists, sales teams, and anyone looking for a guide about how to implement the best options for SAP HANA backup and recovery on IBM Power Systems. Moreover, this publication provides documentation to transfer the how-to-skills to the technical teams and solution guidance to the sales team. This publication complements the documentation that is available at IBM Knowledge Center, and it aligns with the educational materials that are provided by IBM Garage™ for Systems Technical Education and Training.

Table of contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  4. Chapter 1. Introduction
    1. 1.1 Executive summary
    2. 1.2 Backup and restore scenarios
    3. 1.3 Abbreviations and terminology
  5. Chapter 2. Architecture decision aspects
    1. 2.1 SAP HANA architecture
      1. 2.1.1 Multitenant Database Container
      2. 2.1.2 In-memory persistence and savepoints
      3. 2.1.3 SAP HANA System Replication
      4. 2.1.4 SAP HSR and SAP backup
    2. 2.2 Requirements for a data protection solution for SAP HANA
    3. 2.3 IBM Spectrum Protect architecture
      1. 2.3.1 Overview of SAP HANA integration with IBM Spectrum Protect
      2. 2.3.2 The Backint interface
      3. 2.3.3 IBM Spectrum Protect server
      4. 2.3.4 IBM Spectrum Protect for Enterprise Resource Planning
    4. 2.4 Protecting an SAP HANA database with IBM Spectrum Copy Data Management
      1. 2.4.1 Overview on SAP HANA data snapshot
      2. 2.4.2 IBM Spectrum Copy Data Management
      3. 2.4.3 SAP HANA backup and recovery with IBM Spectrum Copy Data Management
    5. 2.5 Retention policies and placement of backup copies
      1. 2.5.1 Backup service levels
      2. 2.5.2 SAP HANA backup retention policies
    6. 2.6 Cyber resiliency aspects of an SAP HANA solution
      1. 2.6.1 Encryption for data at rest and data in flight
      2. 2.6.2 Immutable backup storage
      3. 2.6.3 System hardening
      4. 2.6.4 Backup data verification
      5. 2.6.5 More considerations
    7. 2.7 Other tools to use for backup and recovery of SAP HANA
      1. 2.7.1 Scale-out environment
  6. Chapter 3. Planning and sizing
    1. 3.1 Planning
      1. 3.1.1 Selecting the backup method for the SAP HANA databases
      2. 3.1.2 Online SAP HANA database backup by using Backint
      3. 3.1.3 Online SAP HANA database snapshot
      4. 3.1.4 Protecting other SAP HANA environment components
      5. 3.1.5 Backup and recovery objectives
      6. 3.1.6 Infrastructure considerations
      7. 3.1.7 Backing up to an IBM Spectrum Protect container pool with inline deduplication and compression
      8. 3.1.8 Planning for restore
    2. 3.2 Sizing for backup and restore with Backint
      1. 3.2.1 IBM Spectrum Protect blueprint
      2. 3.2.2 SAP HANA landscape solution
      3. 3.2.3 General sizing metrics
      4. 3.2.4 SAP HANA DB sizing metrics
      5. 3.2.5 File-level sizing metrics
      6. 3.2.6 Sizing results
      7. 3.2.7 Sizing for restore from Backint
    3. 3.3 Sizing for snapshot
    4. 3.4 Sizing for growth
  7. Chapter 4. Installation and deployment
    1. 4.1 Prerequisites
    2. 4.2 IBM Spectrum Protect server configuration
    3. 4.3 Installing and configuring the IBM Spectrum Protect Backup-Archive client application programming interface
      1. 4.3.1 Installing the IBM Spectrum Protect Backup-Archive client
      2. 4.3.2 Configuring the IBM Spectrum Protect Backup-Archive client
      3. 4.3.3 Environment variables
    4. 4.4 Installing and configuring Data Protection for SAP HANA
      1. 4.4.1 Installing Data Protection for SAP HANA agent
      2. 4.4.2 Configuring Data Protection for SAP HANA
    5. 4.5 More considerations
      1. 4.5.1 BUFFSIZE
      2. 4.5.2 MAX_SESSIONS
  8. Chapter 5. Backup, restore, and recovery scenarios for SAP HANA
    1. 5.1 The backup environment
    2. 5.2 SAP HANA backup
      1. 5.2.1 Backing up an SAP HANA database with IBM Spectrum Protect
      2. 5.2.2 Performing a database snapshot backup by using IBM Spectrum Copy Data Management
      3. 5.2.3 Backing up SAP HANA by using IBM Spectrum Protect and IBM Spectrum Copy Data Management
    3. 5.3 Restoring and recovering an SAP HANA database
      1. 5.3.1 Verifying an SAP HANA database backup
      2. 5.3.2 Recovering the SAP HANA database by using IBM Spectrum Protect
      3. 5.3.3 Recovering an SAP HANA database from IBM Spectrum Protect without a backup catalog
      4. 5.3.4 Copying an SAP HANA database by using backup and restore with IBM Spectrum Protect
      5. 5.3.5 Restoring SAP HANA database snapshot backups by using IBM Spectrum Copy Data Management
      6. 5.3.6 Snapshot backup recovery by using IBM Spectrum Copy Data Management with log recovery from IBM Spectrum Protect
  9. Appendix A. Scheduling an SAP HANA backup by using IBM Spectrum Protect
    1. Sample script for a full backup of an SAP HANA database
    2. Configuring the IBM Spectrum Protect scheduler
    3. Configuring the scheduler on IBM Spectrum Protect server
    4. Configuring the client scheduler service
  10. Appendix B. Configuring IBM Spectrum Protect with IBM Cloud Object Storage
    1. IBM Cloud Object Storage
    2. Provisioning IBM Cloud Object Storage
    3. Defining the cloud container pool for SAP HANA backup
  11. Appendix C. Additional material
    1. Locating the web material
    2. Using the web material
  12. Related publications
    1. IBM Redbooks
    2. Online resources
    3. Help from IBM
  13. Back cover

Product information

  • Title: SAP HANA on IBM Power Systems Backup and Recovery Solutions
  • Author(s): Dino Quintero, Rosane Goldstein, Adriana Melges Quintanilha Weingart, Pia Nymann, Andrei Socoliuc
  • Release date: May 2021
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738459691