Shulou(Shulou.com)06/01 Report--

path

Data backup path: /usr/sap/SID/HDBnr/backup/data

Log backup path: /usr/sap/SID/HDBnr/backup/log

If you want to change the path, you can change it in the backup console of studio.

You can also change $(DIR_INSTANCE)/../in the global.ini configuration file SYS/global/hdb/custom/config

Catalog

Similar to oracle catalog, record the contents of the backup

SP12 catalog file and log backup file are in the same directory, format: log_backup_0_0_0.

Detailed version description can refer to the following note

1812980 - Changes to the backup catalog as of Revision 4

There is one sentence that needs attention:

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.

This means that when the database is restored, the information about the backup files to be used will be obtained from the latest catalog file.

data backup file

Format: _databackup__

Prefix is usually date + time, used to distinguish each backup, because the latter name is the same, otherwise it will overwrite the previous backup.

databackup is automatically added by the system

Volume ID corresponds to service and determines which service the current backup file belongs to.

Index is currently 1

For example, below.

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 represents the backup of which service?

0/1 is nameserver, 2 is xsengine, 3 is indexserver

This can be checked by hdbbackupcheck -v backupfilename, and the backend will also be displayed in the results

Note 1705945 - Determining required restoration files

4. log backup file

The default is 15 minutes, i.e. 900 seconds backup time, you can change it yourself

A backup also generates a catalog file

Format: log_backup___ _

The SAP HANA database always adds the character string "log_backup_" to the file name and it therefore refers to a log backup.

The identifies the database service to which the backup belongs.--- Same meaning as data backup file

The is currently always 0.

The is the redo log position of the first or oldest log entry that is contained in the log.

The corresponds to the first redo log position of the next log backup that follows.

As 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

The last string is backupID

It can also be checked by hdbbackupcheck -v logbackupname

Note 1705945 - Determining required restoration files

Additional explanation

1852242 - Confusion about file-based backup catalog naming

1. From revision 45 until 49: log_backup_0_0_0_0.

2. From revision 50 until 51: log_backup_0_0_0_0.

3. From revision 52 until 53: log_backup_0_0_0_0.

4. From revision 54: log_backup_0_0_0_0.

Reference: sapbi.blog/2013/03/20/sap-hana-backup-notes/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.