介绍hana2.0没有单容器模式了。基础命令服务启动服务rtsadmhana64:/usr/sap/RTS/HDB00HDB start StartService Impromptu CCC initialization byrscpCInit.See SAP note1266393. OK OK Starting instance using: /usr/sap/RTS/SYS/exe/hdb/sapcontrol-protNI_HTTP-nr00-functionStartWait2700224.08.202618:06:08 Start OK24.08.202618:07:46 StartWait OK查看进程信息rtsadmhana64:/usr/sap/RTS/HDB00HDB infoUSERPIDPPID%CPU VSZ RSS COMMAND rtsadm456345620.0180967604-shrtsadm575345630.0141923784\_ /bin/sh /usr/sap/RTS/HDB00/HDB info rtsadm578657530.0369483680\_psfx-Urtsadm-ouser:8,pid:8,ppid:8,pcpu:5,vsz:10,rss:10,args rtsadm552410.071581252036hdbrsutil--start--port30040--volume2--volumesuffixmnt00001/hdb00002.00004--identifier1787566041rtsadm549910.071581251992hdbrsutil--start--port30003--volume3--volumesuffixmnt00001/hdb00003.00003--identifier1787566040rtsadm498610.071576052388hdbrsutil--start--port30001--volume1--volumesuffixmnt00001/hdb00001--identifier1787566022rtsadm480110.0232043188sapstartpf/usr/sap/RTS/SYS/profile/RTS_HDB00_hana64 rtsadm480848010.246090872160\_ /usr/sap/RTS/HDB00/hana64/trace/hdb.sapRTS_HDB00-d-nw-f/usr/sap/RTS/HDB00/hana64/daemon.inipf/usr/sap/RTS/SYS/profile/RTS_HDB00_hana64 rtsadm4828480823.558536923165864\_ hdbnameserver rtsadm503848080.5962724136728\_ hdbcompileserver rtsadm504148080.61207072166692\_ hdbpreprocessor rtsadm5088480852.163594203817676\_ hdbindexserver-port30003rtsadm5091480845.861636483476472\_ hdbindexserver-port30040rtsadm509448086.241142961212564\_ hdbxsengine-port30007rtsadm567548082.92834172439320\_ hdbwebdispatcher rtsadm271510.050282433804/usr/sap/RTS/HDB00/exe/sapstartsrvpf/usr/sap/RTS/SYS/profile/RTS_HDB00_hana64-D-urtsadm rtsadm249810.0740927664/usr/lib/systemd/systemd--userrtsadm250124980.01190682680\_(sd-pam)查看版本rtsadmhana64:/usr/sap/RTS/HDB00HDB version HDB version info: version:2.00.057.00.1629894416 branch: fa/hana2sp05 machine config: linuxx86_64githash: 8093aace35062f89bf120231debdad4a9d5835acgitmerge time:2021-08-2514:26:56 weekstone: 0000.00.0 cloud edition: 0000.00.00 compile date:2021-08-2514:39:57 compile host: ld4554 compile type: rel数据库连接系统数据库SYSTEMDBrtsadmhana64:/usr/sap/RTS/HDB00hdbsql-usystem-p******-i00-dSYSTEMDB Welcome to the SAP HANA Database interactive terminal. Type:\hforhelpwith commands\q to quit hdbsqlSYSTEMDB创建数据库testcreatedatabasetest systemuserpassword******查询所有数据库SELECT*FROMM_DATABASES;停止数据库ALTERSYSTEM STOPDATABASEdatabase_name;启动数据库ALTERSYSTEMSTARTDATABASEdatabase_name;删除数据库dropdatabasedatabase_name;模式创建模式CREATESCHEMAschema_name;查询所有模式SELECTSCHEMA_NAMEFROMSYS.SCHEMASORDERBYSCHEMA_NAME;表查询所有表SELECT*FROMTABLES;查询特定模式下的表SELECT*FROMTABLESWHERESCHEMA_NAME模式名;指定模式下创建表-- 切换到目标模式setschematestschema001;createtablet1(c1int,c2int);配置查看数据库的日志归档模式SELECTDATABASE_NAME,KEY,VALUEfromSYS_DATABASES.M_CONFIGURATION_PARAMETER_VALUESWHEREFILE_NAMEglobal.iniANDKEYlog_mode;查询数据库的volumn信息SELECT*FROMM_DISKS;备份发起备份BACKUPDATAFORHDBUSINGFILE(/opt/data,prefix)COMMENTthis is a backup;查询正在运行的备份SELECTDATABASE_NAME,ENTRY_ID,ENTRY_TYPE_NAME,BACKUP_ID,STATE_NAME,COMMENTFROMsys_databases.m_backup_catalogWHERE(ENTRY_TYPE_NAMEcomplete data backupORENTRY_TYPE_NAMEincremental data backupORENTRY_TYPE_NAMEdifferential data backup)ANDCOMMENTthis is a backupANDDATABASE_NAMEin(HDB,HDB01)ANDSTATE_NAMErunning取消备份要求1只能在SYSTEM数据库上执行。2系统数据库和租户数据库必须是online状态。后面紧跟backup_idbackupcancelforHDB1715408459695如果备份失败可以查看日志${DIR_INSTANCE}/{主机名}/trace/DB_{DB_NAME}/backup.log恢复发起恢复RECOVERDATABASEFORHDB UNTILTIMESTAMP2024-05-11 15:46:53CLEAR LOGUSINGCATALOG PATH(/opt/log/DB_HDB)USINGLOG PATH(/opt/log/DB_HDB)USINGDATAPATH(/opt/data);参考资料备份恢复: http://www.voleg.info/hana2-backup-restore.html快照: http://www.voleg.info/hana2-backup-snapshot.htmlSAP HANA命令行方式恢复: https://blog.csdn.net/u011592350/article/details/82956456RECOVER DATABASE Statement (Backup and Recovery)https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/c4205f73bb571014ba46d209981bc1f5.htmlSAP HANA 2.0新功能及升级https://assets.dm.ux.sap.com/webinars/apj-sc-chinese-resource-center/pdfs/upgrading_sap_hana_1_to_sap_hana2_key_steps_and_recommendations.pdf取消备份https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/3827b99e4c004ed9a91b989ee6f5a114.htmlSAP HANA 管理 – 快速指南https://www.gingerdoc.com/sap_hana_administration/sap_hana_administration_quick_guide 【hana】hana2.0多容器常用命令
介绍hana2.0没有单容器模式了。基础命令服务启动服务rtsadmhana64:/usr/sap/RTS/HDB00HDB start StartService Impromptu CCC initialization byrscpCInit.See SAP note1266393. OK OK Starting instance using: /usr/sap/RTS/SYS/exe/hdb/sapcontrol-protNI_HTTP-nr00-functionStartWait2700224.08.202618:06:08 Start OK24.08.202618:07:46 StartWait OK查看进程信息rtsadmhana64:/usr/sap/RTS/HDB00HDB infoUSERPIDPPID%CPU VSZ RSS COMMAND rtsadm456345620.0180967604-shrtsadm575345630.0141923784\_ /bin/sh /usr/sap/RTS/HDB00/HDB info rtsadm578657530.0369483680\_psfx-Urtsadm-ouser:8,pid:8,ppid:8,pcpu:5,vsz:10,rss:10,args rtsadm552410.071581252036hdbrsutil--start--port30040--volume2--volumesuffixmnt00001/hdb00002.00004--identifier1787566041rtsadm549910.071581251992hdbrsutil--start--port30003--volume3--volumesuffixmnt00001/hdb00003.00003--identifier1787566040rtsadm498610.071576052388hdbrsutil--start--port30001--volume1--volumesuffixmnt00001/hdb00001--identifier1787566022rtsadm480110.0232043188sapstartpf/usr/sap/RTS/SYS/profile/RTS_HDB00_hana64 rtsadm480848010.246090872160\_ /usr/sap/RTS/HDB00/hana64/trace/hdb.sapRTS_HDB00-d-nw-f/usr/sap/RTS/HDB00/hana64/daemon.inipf/usr/sap/RTS/SYS/profile/RTS_HDB00_hana64 rtsadm4828480823.558536923165864\_ hdbnameserver rtsadm503848080.5962724136728\_ hdbcompileserver rtsadm504148080.61207072166692\_ hdbpreprocessor rtsadm5088480852.163594203817676\_ hdbindexserver-port30003rtsadm5091480845.861636483476472\_ hdbindexserver-port30040rtsadm509448086.241142961212564\_ hdbxsengine-port30007rtsadm567548082.92834172439320\_ hdbwebdispatcher rtsadm271510.050282433804/usr/sap/RTS/HDB00/exe/sapstartsrvpf/usr/sap/RTS/SYS/profile/RTS_HDB00_hana64-D-urtsadm rtsadm249810.0740927664/usr/lib/systemd/systemd--userrtsadm250124980.01190682680\_(sd-pam)查看版本rtsadmhana64:/usr/sap/RTS/HDB00HDB version HDB version info: version:2.00.057.00.1629894416 branch: fa/hana2sp05 machine config: linuxx86_64githash: 8093aace35062f89bf120231debdad4a9d5835acgitmerge time:2021-08-2514:26:56 weekstone: 0000.00.0 cloud edition: 0000.00.00 compile date:2021-08-2514:39:57 compile host: ld4554 compile type: rel数据库连接系统数据库SYSTEMDBrtsadmhana64:/usr/sap/RTS/HDB00hdbsql-usystem-p******-i00-dSYSTEMDB Welcome to the SAP HANA Database interactive terminal. Type:\hforhelpwith commands\q to quit hdbsqlSYSTEMDB创建数据库testcreatedatabasetest systemuserpassword******查询所有数据库SELECT*FROMM_DATABASES;停止数据库ALTERSYSTEM STOPDATABASEdatabase_name;启动数据库ALTERSYSTEMSTARTDATABASEdatabase_name;删除数据库dropdatabasedatabase_name;模式创建模式CREATESCHEMAschema_name;查询所有模式SELECTSCHEMA_NAMEFROMSYS.SCHEMASORDERBYSCHEMA_NAME;表查询所有表SELECT*FROMTABLES;查询特定模式下的表SELECT*FROMTABLESWHERESCHEMA_NAME模式名;指定模式下创建表-- 切换到目标模式setschematestschema001;createtablet1(c1int,c2int);配置查看数据库的日志归档模式SELECTDATABASE_NAME,KEY,VALUEfromSYS_DATABASES.M_CONFIGURATION_PARAMETER_VALUESWHEREFILE_NAMEglobal.iniANDKEYlog_mode;查询数据库的volumn信息SELECT*FROMM_DISKS;备份发起备份BACKUPDATAFORHDBUSINGFILE(/opt/data,prefix)COMMENTthis is a backup;查询正在运行的备份SELECTDATABASE_NAME,ENTRY_ID,ENTRY_TYPE_NAME,BACKUP_ID,STATE_NAME,COMMENTFROMsys_databases.m_backup_catalogWHERE(ENTRY_TYPE_NAMEcomplete data backupORENTRY_TYPE_NAMEincremental data backupORENTRY_TYPE_NAMEdifferential data backup)ANDCOMMENTthis is a backupANDDATABASE_NAMEin(HDB,HDB01)ANDSTATE_NAMErunning取消备份要求1只能在SYSTEM数据库上执行。2系统数据库和租户数据库必须是online状态。后面紧跟backup_idbackupcancelforHDB1715408459695如果备份失败可以查看日志${DIR_INSTANCE}/{主机名}/trace/DB_{DB_NAME}/backup.log恢复发起恢复RECOVERDATABASEFORHDB UNTILTIMESTAMP2024-05-11 15:46:53CLEAR LOGUSINGCATALOG PATH(/opt/log/DB_HDB)USINGLOG PATH(/opt/log/DB_HDB)USINGDATAPATH(/opt/data);参考资料备份恢复: http://www.voleg.info/hana2-backup-restore.html快照: http://www.voleg.info/hana2-backup-snapshot.htmlSAP HANA命令行方式恢复: https://blog.csdn.net/u011592350/article/details/82956456RECOVER DATABASE Statement (Backup and Recovery)https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/c4205f73bb571014ba46d209981bc1f5.htmlSAP HANA 2.0新功能及升级https://assets.dm.ux.sap.com/webinars/apj-sc-chinese-resource-center/pdfs/upgrading_sap_hana_1_to_sap_hana2_key_steps_and_recommendations.pdf取消备份https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/3827b99e4c004ed9a91b989ee6f5a114.htmlSAP HANA 管理 – 快速指南https://www.gingerdoc.com/sap_hana_administration/sap_hana_administration_quick_guide