Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: orbitz fiasco

RE: orbitz fiasco

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Thu, 20 Nov 2003 07:49:55 -0800
Message-ID: <F001.005D744D.20031120074955@fatcity.com>


The Orbitz fiasco and "what happen" was up on Public radio here about a week after the mess. They interviewed the CIO who sounded like a trusting soul looking to get screwed. According to her, she was informed it was a database problem by her "smart" people. I therefore would conclude that restoring the control file from tape was probably one of their ideas vs. OTS. I have found that OTS seems to believe in the worst case scenario when you call them.

        BTW, according to the interview the CIO was not informed of the true cause of the problem until just before the interview. Moral: Believe in your people, but know what you, and they, are talking about.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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

oracle support has a bit to be desired somedays,

sceanario: someone(CE) accidentally makes the prod SAN, a scratch pool instead of the new SAN. Literally wipes it clean, think of fdisk like.

  get OS reloaded, oracle binaries reloaded, need to do restore/recovery via rman, repository wasted also, oracle 8, so we need to manually extract the controlfile from backups, then restore the database, no biggie got the RF rman book in front of me and i've tested this a few dozen times, client wants to talk to support just to be sure, get support on the phone, he starts down the road of "we'll have to extract the controlfile and every single data file manually using the dbms_backup_restore package". I'm like wait a minute, if we get the controlfile, the info on the backups is stored there, we can just let rman do the extraction of that stuff, support is like "yea that will work also".

doooh..

joe

Jesse, Rich wrote:

>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.
>
>1. 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.
>
>2. This corrupted a control file. They did multiplex their control files.
>
>3. However, they chose to restore the control file from tape. This
>invalidated their database.
>
>4. 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: Joe Testa
  INET: oracle-l_at_oracle-dba.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: DGoulet_at_vicr.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 - 09:49:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US