Re: corrupt datafile

  • From: "Terry Sutton" <terrysutton@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 13 Jun 2004 12:35:48 -0700

(resent with excessive quoting deleted)

Hey Michael,

Yeah, I hope they learn something from this.  The most absurd part is that
their database is only ~50GB.  I can accept that a place on a tight budget
postpones affording new Solaris arrays, etc., but compressed copies of
backups & archive logs for several days could be kept on a PC disk drive
that can be bought for <$200.

I'm just hope they can recover enough of what they need to get back up &
running in some limited extent.  They won't be a new client for long if
they're not in business.


----- Original Message ----- 
> 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")

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: