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:
set database orcl
('\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.