Thursday, February 11, 2016

2044438 - HANA: Backup fails for Out Of Memory error

Symptom

When you try to backup the HANA database, OOM error below pops up.


You also can see error message below in backup.log file.
2014-07-16T10:28:45+09:00  P00890      1473cc932dd ERROR   BACKUP   SAVE DATA finished with error: [447] backup could not be completed, [1000002] Out of memory ; $size$=16777216; $name$=PersistentSpace(0); $type$=pool; $inuse_count$=14; $allocated_size$=8064


Environment
HANA 1.0 all revisions


Cause
There is no enough space in memory for backup process.


Resolution
You can find HANA parameter data_backup_buffer_size under global.ini -> [backup] in the HANA Studio.
This parameter limits the buffer size of backup process.
The default value is 512(MB). You can set it 256 and try backup again.
If reducing the parameter cannot solve the problem, you have to restart the HANA Database.
If you want to find out the root cause that why memory exhausted, please refer to SAP Note 1840954 and 1984422.
You can collect necessary information mentioned in these notes and send to SAP Support for further investigation.


See Also
1840954 - Alerts related to HANA memory consumption
1984422 - SAP HANA: Analysis of Out-of-memory (OOM) Dumps


Keywords
full backup, OOM, Out of Memory, HANA Memory



Header Data

Released On 22.07.2014 06:16:25
Release Status Released to Customer
Component HAN-DB-BAC SAP HANA Backup & Recovery
Priority Normal
Category How To
Database
HDB 1.0

No comments:

Post a Comment