路径
创新互联建站是一家专注于成都做网站、成都网站设计、成都外贸网站建设与策划设计,琼山网站建设哪家好?创新互联建站做网站,专注于网站建设十余年,网设计领域的专业建站公司;建站业务涵盖:琼山等地区。琼山做网站价格咨询:18980820575
数据备份路径:/usr/sap/SID/HDBnr/backup/data
日志备份路径:/usr/sap/SID/HDBnr/backup/log
如果想更改路径,可以studio的backup console中更改
也可以在global.ini配置文件中更改$(DIR_INSTANCE)/../SYS/global/hdb/custom/config
Catalog
与oracle的catalog作用类似,记录所备份的内容
SP12的catalog文件和log备份文件同在一个目录,格式:log_backup_0_0_0_0.<BackupID>
详细版本说明可参考如下note
1812980 - Changes to the backup catalog as of Revision 4
其中有一句话需要注意:
When an SAP HANA database is recovered, the system uses the file log_backup_0_0_0_0 that has the highest version ID in the suffix. The system uses the information contained in this file to determine the other backups that are required for the recovery.
意思是在恢复数据库的时候,将从最新的catalog文件里面获取所需要使用备份文件的信息。
数据备份文件
格式:<Prefix>_databackup_<Volume ID>_<Index>
Prefix一般是日期+时间,用于区别每一次的备份,因为后面的命名相同,不然将覆盖上一次备份
databackup是系统自动增加
Volume ID与service对应,确定当前备份文件属于那个服务
Index当前是1
比如下面的
2016-11-25.complete_databackup_0_1 2016-11-25.complete_databackup_1_1 2016-11-25.complete_databackup_2_1 2016-11-25.complete_databackup_3_1
2016-11-25.complete_databackup_N_1代表是哪个服务的备份呢?
0/1是nameserver,2是xsengine,3是indexserver
可以通过hdbbackupcheck -v backupfilename来检查,同时backupid也会显显示在结果中
具体可查看note 1705945 - Determining required restoration files
4.日志备份文件
默认是15分钟,即900秒备份一次,可以自行更改
备份一次也会相应产生一次catalog文件
格式:log_backup_<Volume ID>_<Partition ID>_ <FirstRedoLogPosition>_<LastRedoLogPosition>
The SAP HANA database always adds the character string "log_backup_" to the file name and it therefore refers to a log backup.
The <Volume ID> identifies the database service to which the backup belongs.---与数据备份文件一样意思
The <Partition ID> is currently always 0.
The <FirstRedoLogPosition> is the redo log position of the first or oldest log entry that is contained in the log.
The <LastRedoLogPosition> corresponds to the first redo log position of the next log backup that follows.
如下:
-rw-r----- 1 heqadm sapsys 12288 Nov 25 10:37 log_backup_0_0_0_0.1480041459523 -rw-r----- 1 heqadm sapsys 61440 Nov 25 10:52 log_backup_2_0_11928192_11929024.1480042320558 -rw-r----- 1 heqadm sapsys 86016 Nov 25 10:52 log_backup_1_0_1686400_1687616.1480042320555 -rw-r----- 1 heqadm sapsys 16384 Nov 25 10:52 log_backup_0_0_0_0.1480042322962 -rw-r----- 1 heqadm sapsys 1069056 Nov 25 10:52 log_backup_3_0_4943550784_4943567360.1480042320564 -rw-r----- 1 heqadm sapsys 1007616 Nov 25 10:52 log_backup_1_0_1687616_1703232.1480042321464 -rw-r----- 1 heqadm sapsys 22958080 Nov 25 10:52 log_backup_3_0_4943567360_4943925952.1480042322229 -rw-r----- 1 heqadm sapsys 16384 Nov 25 10:52 log_backup_0_0_0_0.1480042323923 -rw-r----- 1 heqadm sapsys 16384 Nov 25 10:52 log_backup_0_0_0_0.1480042325885
最后一个字符串是backupID
也可以通过hdbbackupcheck -v logbackupname来检查
具体可查看note 1705945 - Determining required restoration files
追加说明
1852242 - Confusion about file-based backup catalog naming
1. From revision 45 until 49: log_backup_0_0_0_0.<digit1><digit2>
2. From revision 50 until 51: log_backup_0_0_0_0.<BackupID>
3. From revision 52 until 53: log_backup_0_0_0_0.<digit1><digit2>
4. From revision 54: log_backup_0_0_0_0.<BackupID>
参考:https://sapbi.blog/2013/03/20/sap-hana-backup-notes/
文章名称:HANA备份文件说明
分享路径:https://www.cdcxhl.com/article22/jgpsjc.html
成都网站建设公司_创新互联,为您提供品牌网站设计、网站建设、网站收录、做网站、外贸网站建设、Google
声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源: 创新互联