Backup & Recovery
Every initial load it is recommended to take a backup of ‘data area’, ‘log area’, and ‘configuration files’.
Backup of data area: This is done from the persistent stage to the external backup location
Backup of log area: This is the automatic activity by the system scheduler where we have to define the level of logs to be captured.
Backup of configuration files: Here we have all landscape settings, DB settings, privileges settings, etc., in .INI file which is to be backuped manually.
To take backup the user should have two privileges
- Backup – ADMIN
- CATALOG – READ, Backup – Admin
Process for taking BACKUP
Log on to HANA Studio.
Right-click on DB System
Select the backup option
Provide the base path where you take back up
(Which is already defined in global .INI file)
Inclined to build a profession as SAP HANA Developer? Then here is the blog post on, explore SAP HANA Training
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 right-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 a landscape for testing and production frost we have to create a 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 in-depth knowledge on SAP HANA, click on below
- Performance Tuning in SAP HANA
- Security in SAP HANA
- Analytical Privileges in SAP HANA
- SAP HANA Views
- Organizing system Landscapes in SAP Hana