Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: orbitz fiasco

From: Joe Testa <>
Date: Thu, 20 Nov 2003 07:05:22 -0800
Message-ID: <>

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



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 Jesse System/Database Administrator
> 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
>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:
Author: Joe Testa

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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:05:22 CST

Original text of this message