Re: major blunders

From: Robert Freeman <>
Date: Wed, 7 Oct 2009 09:53:27 -0700 (PDT)
Message-ID: <>

>> Oh yeah: Don't drive on the railroad tracks.
Especially after eating flapjacks...!!!

 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles

  • Original Message ---- From: Rich Jesse <> To: Sent: Wed, October 7, 2009 10:32:10 AM Subject: Re: major blunders

> Compiling a list of major blunders to avoid:
> Don't use the number 8 for scripting or ORACLE_SID due to the wild card
> character * above it.
> Don't use rm *.*
> ....
> Anyone else have some to contribute?

Before instance shutdown:

    SELECT * FROM V$INSTANCE to verify what you're shutting down.     SELECT * FROM V$SESSION (or some variant) to see what's connected.

Don't practice recovery on the same server as the recoverable DB.

Use colors in Unix command line prompts -- red for Prod, green for Dev, etc.

Use instance name in SQL prompt.

Make your terminal scrollback very large -- mine's at least 5000 lines.

Before logging off of ANY remote Windows session, repeat several times OUT LOUD your intentions to logoff and NOT shutdown the server before you actually click the buttons (esp important on Win2K servers!).

Clean up your room. Stand up straight. Pick up your feet. Take it like a man. Be nice to your sister. Don't mix beer and wine, ever. Oh yeah: Don't drive on the railroad tracks.

My $.02,

Received on Wed Oct 07 2009 - 11:53:27 CDT

Original text of this message