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.
03-13-2002, 04:11 PM
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.
03-13-2002, 05:50 PM
if u have multiple controlfiles , then u can just copy from the mirrored copy, else startup nomount and
recreate the controlfile using create controlfile.
03-13-2002, 06:23 PM
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
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
03-13-2002, 06:26 PM
After creating the controlfile, shutdown the database, execute the controlfile
03-13-2002, 06:26 PM
Try shutdown abort;
and then startup nomount again..
03-13-2002, 06:33 PM
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.
03-13-2002, 06:35 PM
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
03-13-2002, 07:14 PM
Send other error messages in detail...
There should be some more messages..
03-13-2002, 07:26 PM
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