[Incident] Backup Prerequisite
Solution : 1. open the hana studio .
2.check the backup admin user . if not , launch the sql as below :
create role BACKUP_ADMIN_ROLE ;
grant BACKUP ADMIN to BACKUP_ADMIN_ROLE ;
grant CATALOG READ to BACKUP_ADMIN_ROLE ;
create user BACKUP_ADMIN password <Password> ;
grant BACKUP_ADMIN_ROLE to BACKUP_ADMIN ;
alter user BACKUP_ADMIN disable password lifetime ;
3.active the user , enable the odbc/jdbc connection .
4.check the hdbuserstore : input the command with <SID>adm in server : hdbuserstore LIST
5.if not , run the command :
hdbuserstore SET BACKUP <hostname>:3<Instance_Number>15 BACKUP_ADMIN <Password>
6.test : input : hdbsql -u BACKUP ----> \s ----> check the information .
7.check the target server : ls
/tmp/backup.sh && ls
/tmp/backup_config-<SID>.cfg
8.if not , copy from /SRC_SAP/Backup_HANA/* , and change configfile with below :
SID=<SID>
INSTANCE=<Instance_Number>
HOSTNAME=<hostname>
INSTANCE=<Instance_Number>
HOSTNAME=<hostname>
[Incident ] Error 91005: Secure store call failed: No encrypted record in the secure storage could be successfully converted to the new key because none was readable with the current key, the default key or an externally provided key; no update was executed <-- Record "HDB/BACKUP/DB_PASSWORD" was inserted with an encryption key that was different from the current one; when you still know the old one, you can try the "migrate" operation of the "rsecssfx" utility.
.rm /
home/s17adm/.hdb/szxdh1han06/
SSFS_HDB.DAT
hdbuserstore
SET BACKUP szxdh1han06:30115 BACKUP_ADMIN S17Backup1
[Incident ] backup error : Allocation failed ; $size$=16777216; $name$=Page; $type$=pool; $inuse_count$=2693; $allocated_size$=45181042688
change the parameter : global.ini ---->backup ------> data_backup_buffer_size default 512----> system 256 . problem solved .
[Incident ]backup error : backup could not be completed , error calling io_setup , rc=11 ;Resource temporally unavailable .
vi /etc/sysctl.conf
double the figure fs.aio-max-nr