Oracle-L: RE: orbitz fiasco

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Thu, 20 Nov 2003 06:44:51 -0800
Message-ID: <F001.005D743F.20031120064451@fatcity.com>

Wow. Restoring a control file from tape for this situation? Man, that's not just wrong, it's fundamentally wrong. At a high-profile site that must have Gold Support (or whatever they're calling it today), if this is true someone was really not thinking that day.

Kinda interesting about the firmware upgrade, too, because my Oracle DBA instructor used an example exactly like this to explain why control files must be triplicated even if you're RAIDed up the wahzoo.

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-----Original Message-----
Sent: Thursday, November 20, 2003 7:40 AM To: Multiple recipients of list ORACLE-L

I was at an Oracle usergroup meeting last week and a guy at Oracle said the following happened. Can anyone confirm? Just curious.

Orbitz did an upgrade to some software other than Oracle. I think it was firmware. They did NOT test it first. Did it directly in production.
This corrupted a control file. They did multiplex their control files.
However, they chose to restore the control file from tape. This invalidated their database.
So the delay was restoring the whole database from tape and rolling forward.

Anyone know if that is what what happened? Wouldnt surprise me, however, it is Oracle's side of the story...

I know atleast one other person from the list was there. I forget the guys name who said it. He is one the RAC specialists.

--

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

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 20 2003 - 08:44:51 CST