I know this is going to sound very vanilla, but I've been here before
and there are troubleshooting steps you could try.

I don't have time to help right now, but PLEASE, GET AN EXPORT since you
were able to mount.

The worse case scenario is that you rebuild the database, create table
spaces, create the schema owner, and import.

There are ways around bad control files, but the results vary....

Way your options, but since there has already been downtime, now is a
good time to take the easy way out....


Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]


-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x68251383.[Email address protected]
Sent: Tuesday, July 31, 2007 10:49 AM
To: LazyDBA Discussion
Subject: Help database not working

My client's server had a bad disk which was also being mirrored and that
disk had to be replaced. This disk had one of the control files stored
on it. To my understanding before fixing the hard disk failure the SA
shutdown the database. When the disk was replaced and the SA did what he
needed to do after replacing the disk he attempted to startup the
database but he got a ORA 205 error. However, he says he got a message
that the startup was successful. Later the client tried to access the
database and she got a ORA-01033 error. I am not sure if the solution to
this problem is an Oracle solution or a SA solution. The SA is asking if
there is a way to create another control file to recover the database. I
told him from what I understand if there is no backup then there is no
way to recover. I am not 100 % sure. Could someone tell me if it is
possible to not lose any data and rebuild a corrupt or bad control file?

Raquel Sikyala



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page