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: How much beer should a DBA consume? (Or, how to learn from my mis

Re: How much beer should a DBA consume? (Or, how to learn from my mis

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Thu, 21 Dec 2000 19:20:42 -0000
Message-Id: <10717.125158@fatcity.com>


You have my DEEPEST sympathies....... hard lesson to learn but you'll never make that mistake again.

Rachel

>From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: How much beer should a DBA consume? (Or, how to learn from my mis
>Date: Thu, 21 Dec 2000 10:21:09 -0800
>
>So, there I was, creating a new QA pre-production copy-of-production
>Oracle8
>database. I figured that I could just use a copy of the DB/TS/RBS creation
>scripts that I used for the Development DB, right?
>
>Well, when you forget to edit the TS create script and it re-creates
>datafiles over your Development DB, it doesn't work. And, as a bonus, it
>trashes your Development DB.
>
>Did I mention that we were having problems backing up Development (Tivoli,
>OmniBack, etc.)? Did I mention that I just got done writing triggers for
>three weeks and the only place they existed was in the Dev DB?
>
>Luckily, the SYSTEM tablespace was in the create DB script, which I DID
>edit
>before trashing the rest of the Dev DB, and I can recover the DB objects
>(like my triggers) sans data. And the data *should* be just development,
>right? I can only hope.
>
>REMEMBER, PEOPLE: BACKUP YOUR DATABASE AND *VERIFY* YOUR BACKUPS! AND NOT
>JUST YOUR PRODUCTION DATABASES, EITHER!
>
> "Payday came and with it beer."
> -- Rudyard Kipling
>
> http://www.execpc.com/~legoman
> Home of the Beer Ale Lager Lovers Society
>
>Rich Jesse System/Database Administrator/Society
>President
>Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
>
>
>-----------------------------------------------------------------------
>
>This message has been scanned for viruses with Trend Micro's Interscan
>VirusWall.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).



Get your FREE download of MSN Explorer at http://explorer.msn.com Received on Thu Dec 21 2000 - 13:20:42 CST

Original text of this message

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