- 备份的设备
- 备份相关参数
- 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