COntrol file failure

[Siva]

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

[mike73]

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.

[gpsingh]

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

[Siva]

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

[sumi_ocp]

Try shutdown abort;

and then startup nomount again..

[Kishore]

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

kishore

[gpsingh]

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.

[Siva]

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

[sumi_ocp]

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

[Siva]

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