SAP HANA Database Backup and Recovery (New and Changed)

SAP HANA Database Backup and Recovery (New and Changed)

A number of enhancements and new features have been added to SAP HANA backup and recovery as of SAP HANA 2.0 Platform SPS 00.

Enhancements for Log Backups

  • Using SAP HANA, all the log segments of a service, which are ready to be backed up at the same time, can be written to a single log backup to improve performance. For each log backup, you can specify a maximum file size.

    As well as file-based log backups, third-party tools also support this option for log backups.

    Details: Writing Multiple Log Segments to a Single Log Backup.

    Log backups can be triggered by events in SAP HANA 2.0.

    By default, a log backup is created as soon as a log segment fills up, or when the service-specific timeout for a log segment has been reached for that segment.

  • A log backup can also be specified to be created only if a service-specific timeout has been reached, if you prefer that option.


    As well as file-based log backups, third-party tools also support this option for log backups.


    There is more information on the website: Related Information allows you to set the Interval Mode for Log Backups

Encryption and Backup and Recovery

Data encryption is supported in SAP HANA 2.0's persistence layer.

When it comes to encryption root keys, the database administrator must make sure they've been copied and stored somewhere safe. It's important for a database administrator to import the root keys before performing a recovery.

There is more information on the website: Notables: SAP HANA Backups and Encryption, Root Key Backup, and Import Backed-up Root Keys in Related Information.

Location of the Backups of the Backup Catalog

Unlike the backup catalogue, the location of log backups is configured separately.

To recover SAP HANA, you must specify the path to the backup catalogue before you can proceed.

More information: Backup Catalog Backup Destination Information

SAP HANA Multitenant Database Containers

Using a data backup of a SAP HANA single-container system, it is now possible to restore a tenant database from a SAP HANA backup.

There is more information on the website: When copying a database with Backup and Recovery, Please take note of the following: SAP HANA Multitenant Database Containers & Backup, SAP HANA Multitenant Database Containers and Recovery in Related Information are important to note.

Extension Node for Business Warehouse

With SAP HANA 2.0, the extension node for Business Warehouse can be used to recover the database.

Details: SAP HANA Recovery and Data Temperature: Business Warehouse Extension Node in Related Information

SAP HANA on IBM Power Systems: Release Compatibility

Only IBM Power Little Endian (LE) systems are supported by SAP HANA 2.0.

SAP HANA 2.0 backups are compatible with both supported hardware platforms (Intel and IBM Power). It is possible to restore SAP HANA 2.0 from backups created with SAP HANA 2.0 on either an Intel-based or an IBM Power-based platform.

You can restore SAP HANA 2.0 to both Intel-based and IBM Power-based systems using backups created with SAP HANA 1.0 SPS 10 or later running on an Intel-based system. IBM Power-based backups created with SAP HANA 1.0 cannot be used to restore SAP HANA 2.0.

Important Notes about SAP HANA on IBM Power Systems

SAP HANA Cockpit (Changed)

It's now possible to use a new and improved SAP HANA cockpit.

With the change to the SAP HANA recovery and backup procedures using SAP HANA cockpit, the guide has been updated.

Additionally, you can find more information in Related Information about the following topics: SAP HANA System Administration (New and Changed) and Schedule Data Backups (SAP HANA Cockpit).

SAP HANA Performance Monitoring and Analysis (New and Changed)

SAP HANA Performance Monitoring and Analysis (New and Changed)


SAP HANA Performance Monitoring and Analysis now has new and modified functionality as in SAP HANA Platform 2.0 SPS 00.

The following tools provide new and enhanced functionalities starting with SAP HANA 2.0:

Capture and Replay (Changed)

The SAP HANA cockpit's capture and playback tool now has new functionality with SAP HANA 2.0:
When establishing new captures, you can specify the circumstances in which the capture will be overridden depending on two criteria:
The length of time the capture lasted
The capture uses a lot of storage space.
See Capture a Workload in the Related Links section for further information
It is possible to compare replays based on the same capture when replaying the workload.
Compare Replayed Workloads in the Related Links section for more details.
After replaying the workloads, the Replay Report may be used to compare query results. In addition, the Load tab depicts the system load during the replay process.
See the SAP HANA Administration Guide's Replay a Preprocessed Workload for more information.

Workload Analyzer (Changed)

The workload analyzer tool in the SAP HANA cockpit has two versions with SAP HANA 2.0. "Workload analyzer based on thread samples" is the new name for the workload analyzer from SAP HANA 1.0. "Workload analyzer based on engine instrumentation" is the name of the new workload analyzer version. The workload analyzer tool now has the following changes and additional features:
Using thread samples as input, a workload analyzer is created (changed)
The graphic depicting system resource utilisation shows both a current and historical analysis.
A timeline view mapped to the load graph can be used to visualise the system load.
Engine instrumentation-based workload analyser (new)
This is a capability for assessing workloads that have been captured. It features load graph visualisation, as well as a timeline view with application and statement hierarchy, similar to the sampling-based workload analyzer.

See the SAP HANA Administration Guide's Analyzing Workloads for further details.

SQL Analyzer (New)

The SQL Analyzer is accessible in the SAP HANA cockpit and the SAP HANA Database Explorer with SAP HANA 2.0 SPS 00.

It is possible to analyse and comprehend query execution and performance features of the SAP HANA database using this tool. It can be used to see extensive information about each query and to identify any bottlenecks in these queries. The tool is similar to the SAP HANA studio's Plan Visualizer tool.

The SQL Analyzer comes with the following features:

  • Overview

  • Operator list

  • Tables used

  • Statement statistics

In the SAP HANA Administration Guide, see Analyzing Statement Performance for more information.

Other Performance Management Tools (Changed)

The following SAP HANA cockpit performance management tools have been improved:
  • Performance Monitor

    In the SAP HANA Administration Guide, see Monitor and Analyze Past Performance and Collecting Performance Monitor Data for SAP Support for further information.

  • Monitor Statements

    In the SAP HANA Administration Guide, see Monitor and Analyze Critical Statements for additional details.

  • Threads

    In the SAP HANA Administration Guide, see Monitor and Analyze Threads for more information.

  • Sessions

    In the SAP HANA Administration Guide, see Monitor and Analyze Sessions for more information.

  • Expensive Statements

    In the SAP HANA Administration Guide, see Monitoring and Analyzing Expensive Statements for more information.

  • SQL Plan Cache

    In the SAP HANA Administration Guide, see Monitoring and Analyzing Statements using SQL Plan Cache for additional information.

SAP HANA System Copy- Homogeneous Backup/Recovery Method

SAP HANA System Copy- Homogeneous Backup/Recovery Method

I found this article and digest it thoroughly as i also on and off engage myself in SAP Hana System Copy for the NW or ECC system residing on it. The steps are almost profound and similar as other methods available in SWPM. Therefore summarized the important reference SAP notes and also some screen shots related to this activity.


Refrence Note:

1844468 – Homogeneous system copy on SAP HANA

1709838 – BW 7.3 on HANA: System copy using backup and recovery


 SAP HANA system copy Procedure-  Below is the HANA System copy (SWPM) using Backup/Recovery method from PRD to QAS.

— SID of HANA production is PRD- > So, schema will be SAPPRD

— SID of HANA Quality is QAS- > So, Schema will be SAPQAS

1. Take the backup of HANA Prd system

2. Copy/Move the the backup form PRD Host to QAS Host

3. Ensure that QAS is having enough space for Backup.

4. Download SWPM latest

5. Download Kernel.

6. Download SAP HANA License of QAS

Start SWPM and select Database refresh or DB Move

Profile Directory Of App server

Provide default Master Password for all users

Provide passwords for SIDADM & SAPServiceSID

Provide path of kernel Directory

Select Homogeneous System Copy method

Provide your DBSID as QAS , DatabaseHost will be QAS Host name & Instance number of QAS

SWPM will take the below schemas

Here Schema name should be SAPPRD

Provide SIDADM Password

Provide the location of the backup path as per Point 2 . Backup name should be the prefix name of the complete data backup. I have used the default backup name (COMPLETE_DATA_BACKUP).

Provide the location of SAP HANA QAS License as per Point 6.

Provide DDIC password

Select Local Client directory as HANA Client software Patch. Perhaps you can select “central directory also” Depends on the requirement.

After clicking “Next” You will be asked to check the final list of parameters and after confirming your actual HANA Refresh will start

Post Successful Completion, You need to update the hdbuserstore on SAP Application server. -> This will connect the SAP Application and HANA DB.

Run Report RS_BW_POST_MIGRATION to adjust SAP HANA Calculation views.