Understanding backup and recovery
In the SAP HANA database, during normal operation, data is automatically saved to the disk at regular savepoints. Furthermore, the log captures all the data changes. After each committed database transaction, the log is saved from the memory to the disk. When there is a power failure, the database can be restarted like any disk-based database, and it returns to its last consistent state by replaying the log since the last savepoint.
The backups are required for the following reasons:
- To protect against disk failures
- To make it possible to reset the database to an earlier point in time
Backups are carried out while the database is running and users can continue to work normally. The impact on system performance is negligible.
SAP HANA is an in-memory database or a database that stores its database tables in the main memory RAM. RAM is the fastest possible data storage media available as of today; however, it is volatile. During power loss, the data bits on the...
