| Control file crashed!!!! [message #58515] |
Thu, 04 September 2003 07:33  |
sachin kumar gupta
Messages: 157
Registered: March 2003
|
Senior Member |
|
|
Is there any way that I can recover through the situation when I have lost the control file. Also, I don't have any backup of control file/very old control file. And in between so many operations were performed like tablespace addition, datafile resized, datafile added etc..
Sachin
|
|
|
|
| Re: Control file crashed!!!! [message #58517 is a reply to message #58515] |
Thu, 04 September 2003 08:52  |
jelmer
Messages: 3
Registered: September 2003
|
Junior Member |
|
|
Hello Sachin,
I am no DBA but I remember something like this. If I remember well, there are always two controlfiles, which have the same name and are in different directories (or they have different names and are in the same directory). They should be exactly equal in content. Maybe you can find the good one and copy it to the bad controlfile, and restart the database. If you don't know which one is good, try them both.
But I think you should verify all this before going on, for as I said, I am no expert
Wish you good luck, Jelmer
|
|
|
|
| Re: Control file crashed!!!! [message #58527 is a reply to message #58517] |
Thu, 04 September 2003 15:22 |
Kartik Nair
Messages: 15
Registered: August 2003
|
Junior Member |
|
|
Try to recreate the control file by first connecting as SYS.
startup nomount;
recreate the Control file using the following command.
Create controlfile reuse database "db-name" resetlogs noarchivelog
You will need to provide all the other relevent information like maxlogfiles etc.
Good luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
