-
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
-
Try shutdown abort;
and then startup nomount again..
-
After creating the controlfile, shutdown the database, execute the controlfile
kishore
Thanks
Kishore Kumar
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|