COntrol file failure

Hi friends,
By mistake I deleted the control file. But I have a old copy of that, with that I started the database. Instance started but finally, it gives error #ora01102-cannot mount the db in EXCLUSIVE mode. How can I open the DB in the situation. Pl help me.Thanks in advance.
Bye
Siva

If you have backup copy from the back to the right location, if not copy from one of your control file and rename it to the file that was deleted( I hope you have more than one file).

shutdown the database and start up, you won't have any problem.

if u have multiple controlfiles , then u can just copy from the mirrored copy, else startup nomount and
recreate the controlfile using create controlfile.

thanks gpsingh and mike73,
The problem is I dont have backup copy of the file that I deleted. I have very old one, with that I have problem So I created te control in Nomount stage by using following script

create controlfile database "test" noresetlogs
maxlogfiles 32
maxlogmembers 2
maxdatafiles 1
maxloghistory 1815
logfile
group 1 'c:\oracledb\log1test.ora',
group 2 'c:\oracledb\log2test.ora'
datafile
'c:\oracledb\systest.ora'
;

I end up with follwoing errors, control file creation failed and
ora-01158, Database already mounted,
I started the database with Nomount only.
I dont know Where I went wrong. Pl hlep me
bye
siva

After creating the controlfile, shutdown the database, execute the controlfile

kishore

Try shutdown abort;

and then startup nomount again..

there must be another message accompanying this message , reuse before database keyword
and be sure u have the current logfiles.
then do startup nomount and create the controlfle.I hope the database is not already corrupt.

Is the control file script correct?, I have not disturbed any other file.Only I deleted was control file.
repeatedly I am getting similar error message

bye
Siva

Send other error messages in detail...
There should be some more messages..

this waht I have done

SVRMGR> startup pfile=c:\oracledb\inittest.ora nomount
ORACLE instance started.
Total System Global Area 8509232 bytes
Fixed Size 46136 bytes
Variable Size 7529208 bytes
Database Buffers 409600 bytes
Redo Buffers 524288 bytes

SVRMGR> @c:\oracledb\control.sql
create controlfile database "test" noresetlogs
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01158: database already mounted
SVRMGR>

this is what I got, I have no error message.
Pl help me
BYe
siva