sap hana backup issue

[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>

[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 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值