[SAP HAAN]备份管理
- 备份的设备
- 备份相关参数
- SQL 备份
1.备份设备
https://www.sap.com/dmc/exp/2013_09_adpd/enEN/#/partners?filters=1108&search=BACKINT
2.备份参数
参数功能 | 参数 | |
备份配置设定 | basepath_databackup | |
日志备份配置设定 | basepath_logbackup | |
日志模式 |
log_mode:normal/overwrite |
默认为normal,重新设定需要重启系统 |
内存限定值 | global_allocation_limit | |
备份文件加密 | data_encryption | |
是否充许日志自动备份 | enable_auto_log_backup=yes | |
日志自动备份间隔 | log_backup_timeout_s | |
内存数据写入磁盘间隔 | savepoint_interval_s | |
日志备份间隔模式 | log_backup_interval_mode |
-immediate -services |
enable_accumulated_catalog_backup |
defaul is false |
global.ini --->persistence
3.SQL 备份
BACKUP DATA USING FILE ('/backup/HDB/data/BACKUP_FULL_2014/SAPHANA')
4. 删除备份
BACKUP CATALOG DELETE BACKUP_ID <backup_id> [complete] backup catelog delete all before backup_id <backup_id> [with file]|[with backint]|[Complete]
5.备份日志
#System DB /usr/sap/<SID>/HDB<NO>/<host>/trace/backup.log #Tenant Database /usr/sap/<SID>/HDB<NO>/<host>/trace/DB_<name>/backup.log
6. 相关视图
M_BACKUP_PROGRESS
M_BACKUP_CATALOG_FILES
M_BACKUP_PROGRESS
SAP note 2036111 Frequently used config parametersin SAP HANA
每天进步一点点,多思考,多总结
版权声明:本文为CNblog博主「zaituzhong」的原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接及本声明。