Creating a New Control File

SQL> ALTER DATABASE BACKUP CONTROLFILE

TO TRACE;

SQL> ALTER DATABASE RENAME FILE 'MISSING00005'

TO '/u01/app/oracle/oradata/orcl/example01.dbf';

ALTER TABLESPACE "EXAMPLE" ONLINE;