Re: corrupt datafile

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Sat, 12 Jun 2004 20:39:01 -0700 (PDT)
Message-ID: <20040613033901.7899.qmail@web50604.mail.yahoo.com>

Hi Terry,

I've read all the other list reponses. Suggestion? Look for partial exports to help rebuild portions of the lost tablespace(s)? What a mess.

You could also suggest they immediately attempt to prevent similar/further hardware failures at the site, unless its proven to be a singular disk system failure. You might help with risk analysis of their other (undamaged) databases and files, or help get some answers from their SA/DBA/etc (new or old). Preventing further issues can save the day after a single data loss.

They should be willing to listen based on (1) how much they value their data, or (2) how much the IT department value their jobs.

Good luck, I hope it works out for you.

Regards,

Mike Thomas

PS: Ask the IT director if he/she has read what's in envelope three. Just kidding. ;-)

(You know the answer: "Make three envelopes")

Terry Sutton <terrysutton_at_usa.net> wrote:
> A new client has a serious corruption error. During
> a hot backup (not RMAN) Thursday morning it was
> discovered that a datafile was corrupted on the
> disk. When the database is started up, the
> following error occurs:
>
...
> Any ideas on what they can do? I can't think of
> anything (other than going back to an export they
> have from 6 months ago, which seems to be the only
> historical backup they have).
>
> --Terry

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sat Jun 12 2004 - 22:35:45 CDT