LLI Wiki — My Digital Knowledge Base

HANA: backup paths and Backint fallback

Change HANA backup paths and enable log_backup_backint_fallback.

How to move the HANA backup directories to a dedicated path and enable the fallback to file backup when the Backint agent is unavailable for log backups.

Check the current Backint setting

SELECT * FROM M_INIFILE_CONTENTS WHERE KEY='log_backup_using_backint';

Create the new backup directories

user_hana=$(cat /etc/passwd | grep HANA | cut -d":" -f 1)
echo $user_hana
mkdir -p /hana/h_backup/data
mkdir -p /hana/h_backup/log
chown -R $user_hana:sapsys /hana/h_backup/

Change the backup paths

Original values, for reference:

basepath_databackup = /hana/backup/data
basepath_logbackup = /usr/sap/<SID>/HDB<nr>/backup/log
basepath_catalogbackup = /hana/backup/log

New values:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'basepath_databackup') = '/hana/h_backup/data' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'basepath_logbackup') = '/hana/h_backup/log' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'basepath_catalogbackup') = '/hana/h_backup/log' WITH RECONFIGURE;

Enable the Backint fallback

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'log_backup_backint_fallback') = 'true' WITH RECONFIGURE;

The same parameter can be set for one host only, using the HOST layer:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'HOST') SET ('backup', 'log_backup_backint_fallback') = 'true' FOR '<host>:00' WITH RECONFIGURE;

Resulting global.ini

[backup]
log_backup_using_backint = true
catalog_backup_using_backint = true
log_backup_backint_fallback = true
parallel_data_backup_backint_channels = 10

[multidb]
mode = multidb
database_isolation = low

[persistence]
basepath_datavolumes = /hana/data/<SID>
basepath_logvolumes = /hana/log/<SID>
log_backup_timeout_s = 900
enable_auto_log_backup = yes
basepath_databackup = /hana/h_backup/data
basepath_logbackup = /hana/h_backup/log
basepath_catalogbackup = /hana/h_backup/log
log_mode = normal

Other parameter changes seen in the same context

Set a memory allocation limit (in MB) for a tenant database:

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'DATABASE', '<tenant>') SET ('memorymanager', 'allocationlimit') = '500000' WITH RECONFIGURE;

Enable or disable helper threads for the persistence flush:

hdbsql -u <USER> -p '<password>' "ALTER SYSTEM ALTER CONFIGURATION ('global.ini','SYSTEM') SET('persistence','use_helper_threads_for_flush')='true' WITH RECONFIGURE"
hdbsql -u <USER> -p '<password>' "ALTER SYSTEM ALTER CONFIGURATION ('global.ini','SYSTEM') SET('persistence','use_helper_threads_for_flush')='false' WITH RECONFIGURE"

Notes

Mastodon LLIMastodon SocialFosstodon