Re: corrupt datafile

From: Terry Sutton <terrysutton_at_usa.net>
Date: Sun, 13 Jun 2004 12:35:48 -0700
Message-ID: <003b01c4517e$56d18f80$0400a8c0@TerrySutton>

(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.

--Terry

• 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: 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 Sun Jun 13 2004 - 14:37:39 CDT