sap hana backup issue

来源:互联网 发布:js让多个功能延迟执行 编辑:程序博客网 时间:2024/05/20 22:01

[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 

0 0
原创粉丝点击