SAP Knowledge Base Article - Preview

3218352 - How to release "Free" log segment in a high isolation HA/DR site

Symptom

  • Your HA/DR site is in high isolation.
  • There are many log segments exist in folder mnt0000*/hdb0000*.0000*.
  • Following command shows that lots of segments are in "Free" status. 
    for i in $(find -L /hana/log/${DIR_INSTANCE:9:3} -name 'hdb*' -type d) ; do echo $i ; hdblogdiag seglist $i | grep -oP 'Formatting|Preallocated|Writing|Closed|Truncated|BackedUp|RetainedFree|\bFree\b' | sort | uniq -c ; done

This KBA is focused on clean up disk size when log segment in status "Free". If most of them are in other status,e.g. RetainedFree, you may refer to following note for further analysis.
2083715 - Analyzing log volume full situations


Read more...

Environment

  • HANA 2.0 
  • High Isolation

Product

SAP HANA, platform edition 2.0

Keywords

log area, multidb, database_isolation, hdbcons, system replication, HA, DR , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.