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

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. Received on Thu Dec 21 2000 - 12:19:18 CST