Use the below procedure to trigger the Delta Backup in HANA DB Take Delta Backup(Incremental/Differential) from HDBSQL BACKUP DATA INCREMENTAL FOR USING FILE (‘/backup/hana’, ‘prefix_description’); BACKUP DATA DIFFERENTIAL FOR USING FILE (‘/backup/hana’, ‘prefix_description’); Take Delta Backup(Incremental/Differential) from HANA Cockpit Navigate to “Database Management” Select the tenant db which needs to be backed up and select … Read more
Delta Backups are the ones which contains only data that has been changed since last complete data backup or the last delta backup Data recovery using delta backups is more faster than log backup. There are two types of Delta Backups in HANA DB. 1. Differential Backup 2. Incremental Backup a. Differential Backup Differential backup … Read more
Sometimes it happens your HANA DB backup might fail. Below is the procedure to troubleshoot the failed backup. 1. Failed System DB backup troubleshooting For any failed backup you have to check the backup.log file available in the trace folder. To navigate into trace directory execute “cdtrace“ from os level /usr/sap/<SID>/HDB<instance_number>/<hostname>/trace Look for backup.log in … Read more
SAP recommends to create one custom user and assign the below privileges for BACKUP and Recovery in HANA DB. 1. To create, view, cancel BACKUP below system privileges is required: To Perform activity on SYSTEM DB from user in SYSTEM DB: To Perform activity on Tenant DB from user in Tenant DB: To Perform activity … Read more
In HANA DB lower than HANA 2.0 SPS6, we don’t have the option to backup the customer specific configuration/Parameters changed by customer. So there are two options here select ‘ALTER SYSTEM ALTER CONFIGURATION (”’|| file_name ||”’, ”’|| case layer_name when ‘SYSTEM’ then layer_name when ‘DATABASE’ then layer_name ||”’, ”’|| database_name when ‘HOST’ then layer_name ||”’, … Read more