on 06-28-2015 8:15 PM
Hi Experts,
while starting Hana DB we are facing issue in index server starting.we have deleted log file because storage issue , after this we are facing this starting issue, we are try to create dummy log file, please le me know how to create dummy log file and where. please let know is there any way to solve this issue.
Thanks in advance.
Jana
I don't know which error you actually got and in general it is not advised to create dummy log files. Instead you should better restore the correct log files from backup or copy them back from the temporary location to the original location. In exceptional cases you can create empty log files using touch, see e.g. SAP Note 1788692. You just have to be aware that a recovery across this empty log file will be no longer possible and so you need to have a good backup afterwards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reddy,
1. Check the HANA trace files in the following location /usr/sap/<SID>/HDB<instance#>/<server name>/trace.
2. Kindly refer the SAP KBA for Dump collection:
1732157 - Collecting diagnosis information for SAP HANA
Regards.
SS.
Hi Sriram,
Thank you for your response.
I have cross verified all traces. but still i am not able to get anything form trace file. we have deleted all log and data files from backup directory. so that we are unable to start HANA DB, for this we need to create dummy log and backup files for HANA DB starting.
Please guide for for this.
Thanks
Jana
Hi Reddy,
Without any error message we many not help you, You have to find the error message while starting the HANA DB. Kindly refer the SCN Wiki link for troubleshooting guide :
SAP HANA and In-Memory Computing Troubleshooting Guide - Technology Troubleshooting Guide - SCN Wiki
Regards
SS
I am not sure if you can get out of this error. According to my understanding you can never start a system with the corrupted logs. I think you need to rebuild the system. However, raise a SAP message and see if you can get some solution from them.
Also, going forward ensure that you have proper backup kept in a different location/drive
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.