Backupfailing on HANA server

[former_member1277512]

error:

2021-06-26T00:23:24+02:00 P0012924 17a452fd37a ERROR BACKUP SAVE DATA finished with error: [447] backup could not be completed, [110112] Extended storage backup error : [SAP][ODBC Driver]Unable to write to archive. ('Failed to open pipe /usr/sap/PH1/SYS/global/hdb/backint/DB_PH1TEN1S/2021_06_26_00_00_00_databackup_differential_1624468383499_16')

cat /usr/sap/PH1/HDB50/ph1db/trace/backup.log | grep -i "broken"
2019-09-04T14:24:35+02:00 P074960 16cfc32a005 ERROR LOGBCKUP state of service: nameserver, ph1db:35001, volume: 1,

2021-07-08T00:52:00.141007+02:00 veat2l000022 SQLAnywhere(esph150): [00000]{0000000000}[-1/-1] 2021-07-08 00:52:00.140281 i esserver UNKNOWN(0) : Error during backup/restore: Failure while trying to fetch SAP HANA log backup option

[former_member751964]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A, as the overview provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

[dvankempen · Accepted solution]

Hi Sanjay,

Thanks for sharing your log files with the community. Did you have a question in mind?

[HakanHaslaman]

Please check, if this helps further:

https://help.sap.com/viewer/269740c67eca42a3b4ffbd376b406fbe/2.00.04/en-US/7aaaea8734b44f81b80edd144...

[former_member1277512]

hakan.haslaman Thanks for the reply. when you mean trace its not system process which we have to montior. we have to montior the below logs:

ex:

mean /hana/shared/PH1/*/*/trace # ls -lrt total 371512 -rw-r--r-- 1 ph1adm sapsys 791 Mar 17 2019 esserver.err

Also, as instructed in weblink we are unable to find esServerInfo.txt file on the server.

[HakanHaslaman]

Full System Info Dump at first should be enough.

[former_member1277512]

ok..please let me know how to do trace also. Some other person also asked.me.to.do.trace on esserveR process but I don't know

[HakanHaslaman]

Could be an issue with the esserver or backint, so please collect the traces and open an incident at the component HAN-DYT or HAN-DB-BAC, so Product Support can start to analyzing the traces,.

[former_member1277512]

please help on how to enable trace for essserver

[former_member1277512]

How to collect trace please help

[former_member1277512]

SAP hana,

Data backups have failed with TSM ,
restarting DT services is resolving is resolving the issue but as its prod server client reqested not to do it.

The error messages i have posted are related to the same. Kindly suggest us on how to proceed. as you see odbc driver error. whats ur suggestion on that

[HakanHaslaman]

I guess, you are using DT, so for further investigate, we have to check the /var/log/messages and full system info dump for more information. If you can't check the traces self, please open a support incident on the component HAN-DB-BAC and let the traces analyzing from Product Support.

[former_member1277512]

Ok thank you

[former_member747869]

I Explained about backup failed with the error messages Backup error: The state 'ManagerCommandRunning' of the BackupManager or Backup error: connection broken SQLSTATE: HY000 or Error: other backup.pl is running

4> ERROR :Command

[su - siddm -c "xyz/usr/sap/SID/home/backup_bkp.pl";] failed with return code [512] and message [* 2: general error: Backup error: The state 'ManagerCommandRunning' of the BackupManager.

workaround for the error -

Backup will fail with this error when another backup is running at same time. In the HANA studio check the thread tab for this. If you see Backup manager is still running from a long time and from server level backup processes are not running. Then this problem will be solved by full system restart.

5> ERROR :Command

[su- sidadm –c “xyz/usr/sap/SID/home/backup_bkp.pl”] failed with return code [512] and message [*2: general error: Backup error: connection broken SQLSTATE: HY000]

workaround for the error -

Backup will fail with error when database went down during backup was running. For this check the availability log and backup timing. You can observe that during backup window database was unavailable.

6> ERROR :Command

[su - sidadm -c "xyz/usr/sap/SID/home/backup_bkp.pl";] failed with exit code [256] and mes-sage [Error: other backup.pl is runnig]

workaround for the error -

If the backup is failing with this error then because of previous running backup.pl new backup will fail. To solve this problem kill the backup processes which are running from a long time and run backup again.

To find the backup ID of the running data backup, use the following SQL command:

select BACKUP_ID from "SYS"."M_BACKUP_CATALOG" where entry_type_name ='complete data backup' and state_name = 'running' order by sys_start_time desc;

Backup Cancel :

Backup Cancel (backup_id)

[former_member1277512]

Any idea about odbc driver requirment

[brunopbaffonso]

Hello sanju6593!

How is your storage partition use?

Type 'df -h' to show the size used in partitions.

Regards;
Bruno Affonso.