Backup and Recovery of HANA Database
For the need of optimal performance, the SAP HANA database holds the data in memory.
During normal database operation, data is automatically saved from memory to disk at regular SAVEPOINTS. Additionally, all data changes are recorded in the redo log. The redo log is saved from memory to disk with each committed database transaction. After a improper shutdown, the database can be restarted like any disk-based database, and it returns to its last consistent state by replaying the redo log since the last SAVEPOINT.
This SAVEPOINT consists of 3 Stages:
• All modified pages are determined that are not yet written to disk. The
SAVE POINT coordinator triggers writing of these pages.
• The write operations for phase 3 are prepared.
• A consistent change lock is acquired → no write operations are allowed.
• All pages are determined that were modified during phase 1 and written
to a temporary buffer.
• List of open transactions is retrieved.
• Row store information for uncommitted changes made during phase 1 is
written to disk.
• Current log position is determined (log position from which logs must be
read during restart).
• Change lock is released.
• All data is written to disk. Changes are allowed again during this phase.
• Temporary buffers created in phase 2.
• List of open transactions
• Row store check point is invoke
• Log queue is flushed up to the SAVEPOINT log position
• Restart record is written (containing e.g. the SAVEPOINT log position)
While SAVEPOINTs and log writing protect your data against power failures,
SAVEPOINTs do not help if the persistent storage itself is damaged.
Database backup can be done manually and also can be scheduled to run automatically
Manual backups are done through
SAP HANA Studio
Scheduling can be done
Using DBA Calendar in DBA COCKPIT
Using script (though SQL Interface)
You can specify whether data and log backups are written to the file system or
using third-party backup tools. The Backint for SAP HANA interface performs
all the actions needed to write the backup data to external storage. The backup
tools communicate directly with the SAP HANA database through the Backint for
SAP HANA interface.
Backint can be configured both for data backups and for log backups.
Data and logs can only be backed up when the SAP HANA database is
Backup and recovery always applies to the whole database. It is not possible
to backup and recover individual database objects.
At the beginning of a recovery, all the data and log backups to be recovered
must be available.
The SAP HANA database software version used during the recovery must
always be the same or higher than the version of the software used to create
When the data area is backed up, all the payload data from all the servers is backed
- This happens in both single-host and multihost environments.
Log backups are done at regular intervals to allow the reuse of log segments.
Log segment is backed up during these situations:
• The log segment is full
• The log segment is closed after exceeding the configured time threshold
• The database is started
Enabling and Disabling of Automatic log backup can be done by changing the value of the parameter enable_auto_log_backup.
Default: enable_auto_log_backup = yes
Maintain Parameter - log_mode
log_mode = overwrite
Log segments are freed by savepoints and no log backup is performed. For
example, this can be useful for test installations that do not need to be backed
up or recovered.
log_mode = legacy In legacy mode, no log backup is performed. Log segments
are retained until a full data backup is performed. This is to allow recovery from
the most recent full backup and the log in the log area. This was the default setting
for SAP HANA SPS 02.
FAQS are attached...