Control files deleted

Environment
Oracle 10.2.0.4, Solaris 10

Problem
Oracle control files were accidentally deleted when database was open.
No backups were available. Database is in noarchivelog mode.

Solution
Luckily redo logs were not overwritten since database startup so media recovery is possible.

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;

Prepare SQL statement to create control file with NORESETLOGS option, e.g.
CREATE CONTROLFILE REUSE DATABASE "DHMERT01" NORESETLOGS  NOARCHIVELOG ...

SQL> @create_controlfile.sql

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/oradata/01/DHMERT01/system01.dbf'

SQL> alter database recover database;
Database altered.

SQL> alter database open;
Database altered.