HANA Backup IMPORTANT points to remember
Being as a BASIS Administrator we have often work with many databases. And it is important to understand the nitty-gritty of internals and important points of HANA Backup
What needs to be Backed up in HANA?
Typically most important parts of HANA Persistence consist of below: 1. HANA Data Volume HANA Data volume can be backed up by native HANA Backup utility either using HDBSQL, HANA Cockpit or HANA Studio. 2. HANA Log Volume HANA Log Volume can be backed by native HANA utility either by using HDBSQL, HANA Cockpit or … Read more
HANA Database DATA Backup
You can trigger HANA Data Backup from 1. Hana Cockpit 2. From OS via HDBSQL 2.1 Trigger Backup from SYSTEMDB HDBSQL To trigger tenant db backup you can either login to SYSTEMDB or TENANT DB. You can use the below command to trigger the backup from HDBSQL. HDBSQL prompt will not end until your backup … Read more
Estimate HANA DB Backup Size
Before starting a backup, If you want to estimate how much size will the Data Backup consume in HANA you can follow the below procedure. SELECT SUM(ALLOCATED_PAGE_SIZE/1024/1024/1024)||’ GB’ ||” as “APPROX BACKUP SIZE” FROM M_CONVERTER_STATISTICS; Also you can use the below query SELECT SUM(ESTIMATED_SIZE/1024/1024/1024) FROM M_BACKUP_SIZE_ESTIMATIONS;
Deactivate SYSTEM user in HANA
Often due to companies security policy you have to deactivate the SYSTEM user in the HANA database. Follow the below procedure to lock the system user. Login to tenant db using hdbsql hdbsql -i instance nr -n dbhost:sqlport -u username -p mypassword Login with user having the privilege USER ADMIN and execute the below command … Read more