Backup & Recovery In SAP Hana
Backup & Recovery
After Every initial load it is recommended to take backup of ‘data area’, ‘log area’, and ‘configuration files’.
i) Backup of data area:This is done from persistent stage to external backup location
ii) Backup of log area: This is automatic activity by the system scheduler where we have to define level of logs to be captured.
iii) Backup of configuration files: Here we have all landscape settings, DB settings, privileges settings etc., in .INI file which is to be backuped manually.
1v) To take backup the user should have two privileges
a) Backup – ADMIN
b) CATALOG – READ, Backup – Admin
v) Process for taking BACKUP
Log on to HANA Studio.
Right click on DB System
Select backup option
Provide base path where you take back up
(Which is already defined in global .INI file)
Interested in mastering SAP HANA Certification? Enroll now for FREE demo on SAP HANA Training Online.
Recovery
To recover the system from failure it will ask you to shut down after the recovery point.
Go to HANA Studio 
Administrator Recovery Select system restart
Option select recovery point.
1) Recovery to a specified point of time
2) Recovery to a specified log position
3) Recovery of a specific data backup
Recovery path
/usr/sap/HAN/HDB 52/backup/data
/usr/sap/HAN/HDB52/backup/log
In the Admin console:
When you open HANA Studio you have to connect the HANA DB further
We have to night click on the mode & click an add system
Host Name ____________
Instance Number __________
Description ____________
Locale __________
Add to folder __________
To export the development landscape to testing & production
First we have to create landscape to testing and production frost we have to create landscape.
XML file exporting later we can find import the same on quality & production
We can ‘stop & Restart’ the DB system from HANA studio
In HANA studio ‘load / unload’ option will allow you to commit the data Ram into main memory.
For an Indepth knowledge on SAP HANA, click on below