Determining required recovery files with hdbbackupdiag

hdbbackupdiag in HANA

The hdbbackupdiag displays the files that are required for the recovery of the database.The output of hdbbackupdiag contains the names of all the files required to recover the SAP HANA database.

Example 

Display all the backups required to recover the database until May 11, 2015, 01:05:00 p.m. The metadata of the backups is not checked.

The time specified is UTC time, not local time.

hdbbackupdiag -f -d /usr/sap/MBY/HDB01/backup/log -u “2015-05-11 13:05:00”

2015-05-11_13-05_databackup_0_1 2015-05-11_13-05_databackup_1_1 2015-05-11_13-05_databackup_2_1 2015-05-11_13-05_databackup_3_1 2015-05-11_13-05_databackup_4_1 log_backup_1_0_426304_427776.1431332400000 log_backup_1_0_427776_428288.1431333300000 log_backup_1_0_428288_428608.1431334200000 log_backup_1_0_428608_429376.1431335100000 log_backup_1_0_429376_429696.1431336000000 log_backup_1_0_429696_430464.1431336900000 log_backup_1_0_430464_430784.1431337800000 log_backup_1_0_430784_431552.1431338700000 log_backup_1_0_431552_431872.1431339600000 log_backup_2_0_598080_598592.1431340500000 log_backup_2_0_598592_598976.1431341400000 log_backup_2_0_598976_599360.1431342300000 log_backup_2_0_599360_602304.1431343200000 log_backup_2_0_602304_602688.1431344100000 log_backup_3_0_536064_538304.1431345000000 log_backup_4_0_1190656_1191360.1431345900000 log_backup_4_0_1191360_1191680.1431346800000 log_backup_4_0_1191680_1192000.1431347700000 log_backup_4_0_1192000_1192640.1431348600000 log_backup_4_0_1192640_1192960.1431349500000

Related Information

Manually Checking Whether a Recovery is Possible – https://help.sap.com/saphelp_hanaplatform/helpdata/en/f6/0cd67cd71846a9ae3da198a78f7851/content.htm

Sap Note : 1821207,1873247,1705945

Leave a Reply