Recovery of Control file from trace

suppose all CONTROL is lost and every thing is ok. No RMAN backup is available.But control file backup as TRACE is exist.

Solution : We will up our database by TRACE control file backup.

Database : Now instance is down

step # 1

c:\> sqlplus /nologsql> conn /as sysdba
sql> startup nomount

step # 2
Copy : create controlfile script which is NORESETLOGS into command screen from trace file backup. as following

sql> CREATE CONTROLFILE REUSE DATABASE "DB1" NORESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'C:\ORACLE9I\ORADATA\DB1\REDO01.LOG' SIZE 100M,
GROUP 2 'C:\ORACLE9I\ORADATA\DB1\REDO02.LOG' SIZE 100M,
GROUP 3 'C:\ORACLE9I\ORADATA\DB1\REDO03.LOG' SIZE 100M

-- STANDBY LOGFILE
DATAFILE 'C:\ORACLE9I\ORADATA\DB1\SYSTEM01.DBF', 'C:\ORACLE9I\ORADATA\DB1\UNDOTBS01.DBF',
'C:\ORACLE9I\ORADATA\DB1\CWMLITE01.DBF',
'C:\ORACLE9I\ORADATA\DB1\DRSYS01.DBF',
'C:\ORACLE9I\ORADATA\DB1\EXAMPLE01.DBF',
'C:\ORACLE9I\ORADATA\DB1\INDX01.DBF',
'C:\ORACLE9I\ORADATA\DB1\ODM01.DBF',
'C:\ORACLE9I\ORADATA\DB1\TOOLS01.DBF',
'C:\ORACLE9I\ORADATA\DB1\XDB01.DBF',
'C:\ORACLE9I\ORADATA\DB1\RMAN_TS1.DBF',
'C:\ORACLE9I\ORADATA\DB1\TEST_TS1.DBF',
'C:\ORACLE9I\ORADATA\DB1\TEST_USERS1.DBF',
'C:\ORACLE9I\ORADATA\DB1\TEST_USERS2.DBF'
CHARACTER SET WE8MSWIN1252;

Control file created.

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;
Database altered.