ok thanks!

________________________________

From: Rick Warner [mailto:[Email address protected]
Sent: Tuesday, July 31, 2007 3:23 PM
To: Sikyala, Raquel
Subject: RE: Help database not working


Yes. If /u02/oradata/control01.ctl is the only file that was lost, you
should be fine. Please be sure that the database is shut down when you
copy the file.

>>> On 7/31/2007 at 3:07 PM, "Sikyala, Raquel" <[Email address protected]
wrote:

Are you saying something like:

cp /u03/oradata/control02.ctl /u02/oradata/control01.ctl

-----Original Message-----
From: Rick Warner [mailto:[Email address protected]
Sent: Tuesday, July 31, 2007 2:02 PM
To: Sikyala, Raquel
Subject: Re: Help database not working

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


It is not clear from your message if you have any copies of the control
file still intact on the system, but it sounds like you only lost one of
two or more. If you do still have any good copies on the system, you
should be able to shut down the database, copy a known good control file
to the location where Oracle is expecting any other (missing) copies (as
identified in init.ora file or spfile), then restart the database.

>>> On 7/31/2007 at 1:48 PM, "Sikyala Raquel " [Email address
protected] wrote:
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 <http://jobs.lazydba.com/> (
http://jobs.lazydba.com/ ) To
Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/> (
http://www.lazydba.com/ ) To
unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page