Message-Id: <10717.125148@fatcity.com> From: "Jesse, Rich" Date: Thu, 21 Dec 2000 12:19:18 -0600 Subject: 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@qtiworld.com Quad/Tech International, Sussex, WI USA ----------------------------------------------------------------------- This message has been scanned for viruses with Trend Micro's Interscan VirusWall.