SAP HANA is a relational database designed to reside in memory. By using an in-memory data platform, SAP HANA can achieve better overall performance than running on disk.
As with disk-based databases, SAP HANA backup is a necessary measure to prevent data loss.
Although HANA is an in-memory database, it uses persistent storage just like any other database. Otherwise, HANA will be affected by power failures. Therefore, the first best practice is to decide what needs to be backed up.
HANA divides persistent storage into two areas—the data area and the log area. The data area contains all the data volumes, one for each service, and each data volume contains data and redo log entries for the relevant service.
The log area contains all log volumes and one log volume per service. Each log volume contains multiple log fragments that store all the redo logs in turn. Once the log fragment is backed up, it can be overwritten.
File system, Backint and SAP HANA snapshot backup
There are three options for SAP HANA backups - file system, Backint, and snapshots. You can also mix these backup methods. These backup methods can be used to create full, incremental or differential backups.
Every SAP HANA backup method has its own advantages and disadvantages, so it's important to determine which method is best for your needs.
Only the current data is protected by the file system backup method, instead of the entire data area, and only block-level consistency checks can be performed. However, the backup of the file system increases the load on the network and it is necessary to monitor the filling of the file system.
The Backint method is an api-based method that typically uses third-party tool calls for SAP HANA backups. As with file system backups, this method also performs block-level consistency checks and backs up only the current data, rather than backing up the entire data area. Because the method supports integration with third-party backup software programs, it is well-suited to the organization's existing backup infrastructure and supports features such as backup encryption and data reduction.
The third method is to create a snapshot. Snapshots can be created or applied very quickly, and snapshots do not add network loading like file systems and Backint backups. However, snapshots do not perform block-level consistency checks and do not allow you to use third-party backup tools.
laser cutting
Henan Yongrong Power Technology Co., Ltd , https://www.hnyongrongglobal.com