1、SAP HANA studio
HANA studio - 右键SID - Backup and Recovery - Back Up system 备份完整数据库或者打开Open Backup Console选择备份类型
这里的备份文件命名自动生成,如果是同样的备份路径,上一次备份将会被覆盖
2、SAP HANA cockpit,从studio进入或者打开链接
https://eccqas:4300/sap/hana/admin/cockpit/
http://eccqas:8000/sap/hana/admin/cockpit/
SAP HANA Backup - Create Backup创建一个backup马上备份
或者创建一个schedule周期调度,注意Backup Prefix,调度名字,周期
3、Native SQLDBA Cockpit for SAP HANA
过程参考:http://tecadmin.net/backup-sap-hana-database-using-command-line/#
可以在系统下用crontab:
complete 全备:hdbsql -U USER4BACKUP "backup data using file ('complete_backup_prefix')"
incremental增备:hdbsql -U USER4BACKUP "backup data INCREMENTAL using file ('incremental_backup_prefix')"
differential差备:hdbsql -U USER4BACKUP "backup data DIFFERENTIAL using file ('differential_backup_prefix')"
异步最后加上ASYNCHRONOUS
1950261 - SAP HANA Database Backup Policy Recommendations and Regular Backup Script
第三方备份工具将file改成backint
4、通过SAP HANA Cockpit备份HANA数据库
事务码:DBACOCKPIT 或者DB13,
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞1
添加新评论0 条评论