How lot take log backup using script in HANA

[Mofizur]

We have SAP HANA SPS09.

1) We are using script provided by SAP Note#1651055 to take the data backup.But it seems it is not taking log backup.HOw can we schedule logbackup ? or we have to use DBACOCKPIT or Studio only?

2) My DB is log_mode OVERWRITE.I have taken backup using script.But when I tried to check the backup using below command

hdbbackupdiag --check -f -d /mnt/resource/backup/xb8_bkp_19022015/ --logDirs  /mnt/resource/logbackup/,/usr/sap/XB8/HDB00/backup/log

ERROR: [110081] Catalog backup log_backup_0_0_0_0 not found

goazr1app904d:/usr/sap/XB8/HDB00>

Is it like we have the DB in OVERWRITE mode thats why we are getting this error?Will my recovery work ?

Thanks,

Mofizur

[Former Member]

Hi Rahaman,

Yes, it is because log_mode paramater. it should be NORMAL. And yes, Recovery of PIT(Point in time) will not be possible. But, however, you can make recovery of the HANA DB by using existing data backup only.

Regards,

Pavan Gunda

[Former Member]

Did your issue got resolved?

We are having same issue. We are on Rev 82 and using DD Boost EMC to take the backup using BACKINT.

Though we are on Rev 82 I tried option provided by Pavan which didn't worked for me.

hdbbackupdiag --check --useBackintForCatalog --backintDataParamFile /opt/ddbda/config/sap_hana_ddbda.utl -d /usr/sap/A0T/SYS/global/hdb/backint

ERROR: [110081] Catalog backup log_backup_0_0_0_0 not found

Regards,

Nitin

[Former Member]

Have you tried re creating the backup catalog and checked ?

[srinivasan_vinayagam]

Hi Rahaman,

Please check this thread.

Regards,

V Srinivasan

[Mofizur]

HI Srini,

My question is SAP provided script is taking the DATA backup only.I can see in Studio that automatic log backup is running there in every 15 minutes.But if I want the log backup to be done via script also is it possible?ANy sample script for that please.

Thanks,

Mofizur Rahaman

[former_member182967]

Hello M. Rahaman,

You can refer to

No command is documented to manually trigger log backup.

Regards,

Ning Tong