Tuesday 2 July 2024

How to Check Individual Backups Inside an SAP HANA Installation (hdbbackupdiag, hdbbackupcheck)

 Hdbbackupdiag can be used to determine which backup files are needed for recovery.

A backup of an SAP HANA instance comprises multiple parts, each sharing the same prefix. A part of a backup is a backup file in the system storage or a backup object transferred to an external backup storage system.

To check a backup, execute hdbbackupcheck for each backup individually.

Procedure

  1. Identify the backups that you want to check.

    Use the hdbbackupdiag tool.

  2. To check the backups, you need the following information:

    • File name (Location)

      For file-based backups, the location is the file system path to the backup. If the backup is below the current directory, the relative path can be used.

      For backups managed using a third-party backup tool, the location is the complete path and name, beginning with /usr/sap/<SID>/SYS/global/hdb/backint/.

    • External backup ID

      You need the external ID if you are using a third-party backup tool.

    • Optionally, the backup ID assigned by the SAP HANA database when the backup was created.

  3. From the command line, call hdbbackupcheck for each backup file.

    hdbbackupcheck [options] <backup>

    hdbbackupcheck offers the following options:

  4. Example

hdbbackupcheck backup/data/BackupTestMaster_databackup_1_1

Backup '/hana/shared/BNR/HDB00/backup/data/BackupTestMaster_databackup_1_1' successfully checked.


Example

hdbbackupcheck -v backup/data/BackupTestMaster_databackup_1_1

Output Code

Check backup '/hana/shared/BNR/HDB00/backup/data/BackupTestMaster_databackup_1_1'

Check backup '/hana/shared/BNR/HDB00/backup/data/BackupTestMaster_databackup_1_1'.

Destination header information:

DestVersion: 5

DatabaseID: 51a3a622-1627-46c8-e100-00000a1d0eab

InternalStartTime: 1370415876795

CurrDestInformation: [FILE][/usr/sap/BNR/HDB00/backup/data/BackupTestMaster_databackup_1_1]

backupID: 1370415876776

ServiceName: nameserver

NumberOfVolumeFiles: 4

HostName: berl30052174a

VolumeID: 1

DestID: 1

MaxDestID: 1

SrcPoolInformation[0]: [DATABASE_SNAPSHOT]@node[1]

DstPoolInformation[0]: [FILE][/usr/sap/BNR/HDB00/backup/data/BackupTestMaster_databackup_1_1]

Source header information:

SrcType: 1

SourceInformation: [DATABASE_SNAPSHOT]@node[1]

srcVersion: 5

sourceSize: 70455296

 
































































hdbbackupcheck notifies you if errors were detected in the checked part of the backup.


at