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>
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
- sap hana backup issue
- SAP HANA BACKUP系统备份
- SAP HANA 备份与恢复(SAP HANA Backup and Recovery)
- Linux下定时备份SAP HANA数据库(SAP HANA Data Backup Using Cron)
- SAP HANA
- SAP HANA
- sap hana
- 【SAP HANA】SAP HANA开篇
- 【SAP HANA】SAP HANA开篇
- 【SAP HANA】SAP HANA开篇
- 【SAP HANA】SAP HANA开篇
- 【SAP HANA】SAP HANA开篇
- 【SAP HANA】SAP HANA开篇
- HANA backup and recovery
- SAP HANA 培训大纲(SAP HANA Training)
- 安装SAP HANA (SAP HANA Installation)
- SAP HANA配置文件(SAP HANA configuration files)
- SAP HANA ROWID (SAP HANA "$rowid$")
- Hexo 百度提交链接
- HTTP学习计划(web的基础)--HTTP概述(1/2)
- 创建DataFrame遇到的问题
- RecyclerView专家
- hdu 1698 Just a Hook
- sap hana backup issue
- ubuntu 14.04 挂载 nfs
- 大风歌
- #424 – 使ListBox 中每一项保持一致大小(Getting Data-Bound Items in a ListBox to Be a Consistent Size)
- java ArrayList与LinkedList的普通for循环遍历
- JSON 字符串 与 java 对象的转换
- 异常笔记
- c#--获取数据库指定表的所有列名
- 使用json-lib进行Java和JSON之间的转换