Solution for accidental deletion of oracle log files: oracle log files are deleted (mainly for those software such as 360 security guard, QQ computer manager, and Kingsoft guard that use logs as garbage, when using them, be careful, or remove the check box for log files when cleaning.) and, as a result, oracle listening cannot be started, it has been a problem for me for a long time, every time I encounter such a problem, I always uninstall oracle and reinstall it, which is a waste of time and nothing to gain. Today I have encountered another problem. Since oracle logs can be recovered, then I tried to restore the accidentally deleted file. Then I succeeded and solved my major troubles. Below are my operations. I will share them with you. 1. sqlplus/nolog www.2cto.com 2. SQL> conn sys/orcl as sysdba orcl is the advanced user created during installation 3 SQL> recover database until time '2017-04-19 13:45:02 'this time is what you want to log recovery time. 4. SQL> alter database open resetlogs; 5. SQL> shutdown immediate; restart oracle services. Done! From DCX903170332