0%

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
    2. 2.1.1 Multitenant Database Container
    3. 2.1.2 In-memory persistence and savepoints
    4. 2.1.3 SAP HANA System Replication
    5. 2.1.4 SAP HSR and SAP backup
    6. 2.2 Requirements for a data protection solution for SAP HANA
    7. 2.3 IBM Spectrum Protect architecture
    8. 2.3.1 Overview of SAP HANA integration with IBM Spectrum Protect
    9. 2.3.2 The Backint interface
    10. 2.3.3 IBM Spectrum Protect server
    11. 2.3.4 IBM Spectrum Protect for Enterprise Resource Planning
    12. 2.4 Protecting an SAP HANA database with IBM Spectrum Copy Data Management
    13. 2.4.1 Overview on SAP HANA data snapshot
    14. 2.4.2 IBM Spectrum Copy Data Management
    15. 2.4.3 SAP HANA backup and recovery with IBM Spectrum Copy Data Management
    16. 2.5 Retention policies and placement of backup copies
    17. 2.5.1 Backup service levels
    18. 2.5.2 SAP HANA backup retention policies
    19. 2.6 Cyber resiliency aspects of an SAP HANA solution
    20. 2.6.1 Encryption for data at rest and data in flight
    21. 2.6.2 Immutable backup storage
    22. 2.6.3 System hardening
    23. 2.6.4 Backup data verification
    24. 2.6.5 More considerations
    25. 2.7 Other tools to use for backup and recovery of SAP HANA
    26. 2.7.1 Scale-out environment
  6. Chapter 3. Planning and sizing
    1. 3.1 Planning
    2. 3.1.1 Selecting the backup method for the SAP HANA databases
    3. 3.1.2 Online SAP HANA database backup by using Backint
    4. 3.1.3 Online SAP HANA database snapshot
    5. 3.1.4 Protecting other SAP HANA environment components
    6. 3.1.5 Backup and recovery objectives
    7. 3.1.6 Infrastructure considerations
    8. 3.1.7 Backing up to an IBM Spectrum Protect container pool with inline deduplication and compression
    9. 3.1.8 Planning for restore
    10. 3.2 Sizing for backup and restore with Backint
    11. 3.2.1 IBM Spectrum Protect blueprint
    12. 3.2.2 SAP HANA landscape solution
    13. 3.2.3 General sizing metrics
    14. 3.2.4 SAP HANA DB sizing metrics
    15. 3.2.5 File-level sizing metrics
    16. 3.2.6 Sizing results
    17. 3.2.7 Sizing for restore from Backint
    18. 3.3 Sizing for snapshot
    19. 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
    4. 4.3.1 Installing the IBM Spectrum Protect Backup-Archive client
    5. 4.3.2 Configuring the IBM Spectrum Protect Backup-Archive client
    6. 4.3.3 Environment variables
    7. 4.4 Installing and configuring Data Protection for SAP HANA
    8. 4.4.1 Installing Data Protection for SAP HANA agent
    9. 4.4.2 Configuring Data Protection for SAP HANA
    10. 4.5 More considerations
    11. 4.5.1 BUFFSIZE
    12. 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
    3. 5.2.1 Backing up an SAP HANA database with IBM Spectrum Protect
    4. 5.2.2 Performing a database snapshot backup by using IBM Spectrum Copy Data Management
    5. 5.2.3 Backing up SAP HANA by using IBM Spectrum Protect and IBM Spectrum Copy Data Management
    6. 5.3 Restoring and recovering an SAP HANA database
    7. 5.3.1 Verifying an SAP HANA database backup
    8. 5.3.2 Recovering the SAP HANA database by using IBM Spectrum Protect
    9. 5.3.3 Recovering an SAP HANA database from IBM Spectrum Protect without a backup catalog
    10. 5.3.4 Copying an SAP HANA database by using backup and restore with IBM Spectrum Protect
    11. 5.3.5 Restoring SAP HANA database snapshot backups by using IBM Spectrum Copy Data Management
    12. 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
3.145.2.184