on 05-26-2016 10:12 PM
Hi all,
When I check disk usage, I observe that 94% on the /vol_HDB/shared volume.
But this time it is coming from following directories
22G on /vol_HDB/shared/HDB/global/hdb/log/mnt00001/
14G on /vol_HDB/shared/HDB/exe/
When I have a look at /vol_HDB/shared/HDB/global/hdb/log/mnt00001/
I see that there are 4 directories (hdb00001, hdb00002, hdb00003, hdb00004) and in each directory there are some dat files also says DO_NOT_TOUCH_FILES_IN_THIS_DIRECTORY as you can see below in the pic.
So I didn't delete these dat files. Should I delete them to make more free space or what do you suggest to me? Or is it normal to have 94% on /vol_HDB/shared ?
Thanks,
Inanc
Have you tried ALTER SYSTEM RECLAIM LOG?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Inanc,
Log volumes are located in directory /vol_HDB/shared/HDB/global/hdb/log/mnt0000x/ which are not too large.
HANA binaries are located in directory /vol_HDB/shared/HDB/exe/ whose usage are in normal situation.
Please use command du -sh to check the directory usage.
Maybe the space is consumed by HANA backups, can you check?
Regards,
Ning
Hi guys,
I solved the problem as below.
First I changed log_mode to 'overwrite'
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'log_mode') = 'overwrite' WITH RECONFIGURE;
then I restarted database and executed
ALTER SYSTEM RECLAIM LOG;
then restart database and change log_mode to 'normal' (which was default for me)
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'log_mode') = 'normal' WITH RECONFIGURE;
then a final restart to database. Now log volume is 54%.
I referenced this webpage by the way
http://www.stechies.com/log-volume-full-log-mode-legacy-database-doesnt-accept-an/
Thanks,
Inanc
The first thing you should check is the state of the log files in HANA Studio: Administration -> Volumes tab -> and drill down to the log volumes for the service in question. Check to make sure that the log files are in a "Free" state. If they are, you can just run ALTER SYSTEM RECLAIM LOG; If not, you need to investigate why... but ultimately, what you did will work as well for your situation...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jason,
I just checked the HANA Studio, state of the logs are free right now as in the picture. However I am not sure about their states before I solved the issue.
I think I took a look at HANA Studio last night before the issue solved, as far as I remember there were some logs which are not Free. I am not sure whether I checked the same logs or about their reason being not free.
This has the explanations for each state: SAP HANA Reference: M_LOG_SEGMENTS
This view describes each allocated log segment and shows its current state and log position range, which is currently contained in this segment.
The following log segment states exist:
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.