SAP Knowledge Base Article - Preview

2801318 - Disk Fragmentation during Database Recovery

Symptom

The Database recovery after HANA 2.0 Upgrade turned erroneous and it failed with disk full error on the Quality Database-ABC.
After adding 1.5 TB on each data volume of ABC database, restarted the recovery once again and it worked fine.

The data volumes size on ABC(Test) as same as the production database CDF(Prod) volumes as example:

Disk Volumes on ABC

PATH FILESYSTEM AVAIL_GB USED_SIZE_GB UNUSED_SIZE_GB FRAGMENTATION_PCT LOCAL MOUNT POINT
hbabcd03-nfsp2:/ABC_data_mnt00002 NFS 4.0T 2.7T 1.4T 66% /hana/data/ABC/mnt00002
hbabcd03-nfsp4:/ABC_data_mnt00004  NFS 4.0T 2.8T 1.3T 68% /hana/data/ABC/mnt00004
hbabcd03-nfsp3:/ABC_data_mnt00003  NFS 4.0T 2.9T 1.2T 72% /hana/data/ABC/mnt00003
hbabcd03-nfsp1:/ABC_data_mnt00001 NFS 2.5T 1015G 1.6T 40% /hana/data/ABC/mnt00001

 

Disk Volumes on CDF:

PATH FILESYSTEM AVAIL_GB USED_SIZE_GB UNUSED_SIZE_GB FRAGMENTATION_PCT LOCAL MOUNT POINT
hbefgh12-nfsp4:/CDF_data_mnt00004  NFS 2.5T 1.7T 821G 68% /hana/data/CDF/mnt00004
hbefgh12-nfsp2:/CDF_data_mnt00002 NFS 2.5T 1.6T 956G 63% /hana/data/CDF/mnt00002
hbefgh12-nfsp3:/CDF_data_mnt00003  NFS 2.5T 1.8T 769G 70% /hana/data/CDF/mnt00003
hbefgh12-nfsp1:/CDF_data_mnt00001   NFS 2.5T 1.4T 1.2T 53% /hana/data/CDF/mnt00001

 

This example shows, that the disk is heavily de-fragmented during Recovery phase.


Read more...

Environment

SAP HANA DB Version 2.0

Product

SAP HANA, platform edition 2.0

Keywords

restore, full, volume , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , Problem

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.