down vote favorite

I need help with creating controlfile using sqlplus. I have used next steps, I altered spfile, shutdown database, startup nomount, used next command to create controlfile but it failed: create controlfile set database orcl logfile controlnew1
('\oracle\oradata\orcl\controlnew1.log’, '\oracle\oradata\orcl\controlnew1.log’) resetlogs; My specifications is to create 2 new controlfiles named contronew1 and controlnew2 in location CONTROL01. I have found related article in oracle documentation but aberrantly I don't understand. I would be thankful for any help to resolve this.


I assume that you are practicing backup and recovery. The best way to do this is to do the following:


This will create a trace file under the diag directory, assuming that you are at least running 11g. You can open the file with notepad and there are two sets of instructions for creating the control file. One for using archive log and one for not using archive log. You should take a look at the file and see what is included. You can use this for moving the database or any of its components. Here are some links that you should look at.



  • Your very welcome – Gandolf989 Oct 12 '17 at 12:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.