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

From: <dgoulet_at_vicr.com>
Date: Thu, 21 Dec 2000 16:20:46 -0500
Message-Id: <10717.125180@fatcity.com>

Ouch!!! Been there, did that, got the t-shirt (framed for me).

Dick Goulet

____________________Reply Separator____________________

Subject: How much beer should a DBA consume? (Or, how to learn from m Author: "Jesse; Rich" <Rich.Jesse_at_qtiworld.com> Date: 12/21/2000 10:21 AM

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

Received on Thu Dec 21 2000 - 15:20:46 CST