目录
一、数据库安装
1、数据库版本：
HDB_SERVER_LINUX_X86_64_1_00_82.tar
2、解压到/sapmnt/soft下
BWDT:/sapmnt/soft # tar xvf HDB_SERVER_LINUX_X86_64_1_00_82.tar
3、安装数据库；
BWDT:/sapmnt/soft/HDB_SERVER_LINUX_X86_64 # ./hdbinst SAP HANA Database installation kit detected. SAP HANA Lifecycle Management - Database Installation 1.00.82.00.394270 *********************************************************************** ##下述创建使用/sapmnt/shared Enter Installation Path [/hana/shared]: /sapmnt/shared Enter SAP HANA System ID: BWD Enter Instance Number [00]: 03 Options: Index | System Usage | Description ------------------------------------------------------------------------------- 1 | production | System is used in a production environment 2 | test | System is used for testing, not production 3 | development | System is used for development, not production 4 | custom | System usage is neither production, test nor development Select System Usage / Enter Index [4]: 1 Enter System Administrator (bwdadm) Password: #系统用户密码：YczbBwd0Hana123 Confirm System Administrator (bwdadm) Password: #系统用户密码：YczbBwd0Hana123 Enter System Administrator Home Directory [/usr/sap/BWD/home]: Enter System Administrator User ID [1001]: Enter System Administrator Login Shell [/bin/sh]: Enter ID of User Group (sapsys) [79]: Enter Location of Data Volumes [/sapmnt/shared/BWD/global/hdb/data]: Enter Location of Log Volumes [/sapmnt/shared/BWD/global/hdb/log]: Restrict maximum memory allocation? [n]: Enter Database User (SYSTEM) Password: #数据库用户密码：YczbBwd0Hana123 Confirm Database User (SYSTEM) Password: #数据库用户密码：YczbBwd0Hana123 Restart instance after machine reboot? [n]:
Checking installation... Preparing package 'Saphostagent Setup'... Preparing package 'Python Support'... Preparing package 'Python Runtime'... Preparing package 'Product Manifest'... Preparing package 'Binaries'... Preparing package 'Installer'... Preparing package 'Ini Files'... Preparing package 'Emergency Support Package'... Preparing package 'Documentation'... Preparing package 'Delivery Units'... Preparing package 'DAT Languages'... Preparing package 'DAT Configfiles'... Creating System... Extracting software... Installing package 'Saphostagent Setup'... Installing package 'Python Support'... Installing package 'Python Runtime'... Installing package 'Product Manifest'... Installing package 'Binaries'... Installing package 'Installer'... Installing package 'Ini Files'... Installing package 'Emergency Support Package'... Installing package 'Documentation'... Installing package 'Delivery Units'... Installing package 'DAT Languages'... Installing package 'DAT Configfiles'... Creating System... Starting SAP HANA Database system... Importing delivery units... Importing delivery unit HANA_DT_BASE Importing delivery unit HANA_IDE_CORE Importing delivery unit HANA_TA_CONFIG Importing delivery unit HANA_UI_INTEGRATION_CONTENT Importing delivery unit HANA_UI_INTEGRATION_SVC Importing delivery unit HANA_XS_BASE Importing delivery unit HANA_XS_EDITOR Importing delivery unit HANA_XS_IDE Importing delivery unit HANA_XS_LM Importing delivery unit HANA_XS_SQLCC Importing delivery unit SAPUI5_1 Importing delivery unit HANA_ADMIN Installation done Log file written to '/var/tmp/hdb_BWD_install_2021-03-20_13.51.20/hdbinst.log'.
二、hanastudio登录
1、安装hanastudio 版本：
HDB_STUDIO_WINDOWS_X86_64.rar
2、登录新装BWD
三、数据库还原
1、把老的BWD的backup数据拷贝到/sapmnt/backup中，并给予777权限
chmod 777 /sapmnt/backup
2、还原数据
（1）调出恢复菜单，点击后，提示要关闭数据库
（2）选择指定备份
（3）选择备份目录
（4）恢复过程
（5）恢复完成
（6）还原系统为老系统，密码不一致，点击提示错误，需要修改登录密码
SAP DBTech JDBC: [1033]: error while parsing protocol: invalid connection id (zero) (com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [1033]: error while parsing protocol: invalid connection id (zero))
（7）使用老bwd的密码登录查看：
（1）系统用户bwdadm密码：YczbBwd0Hana （2）数据库用户bwdadm密码：YczbBwd0Hana 如果输入后，还出现这个错： SAP DBTech JDBC: [1033]: error while parsing protocol: invalid connection id (zero) (com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [1033]: error while parsing protocol: invalid connection id (zero)) 则把当前hana客户端登录BWD的连接删除，重新建立即可。
查看新的数据，可以正常显示。
