RE: My 10 Commandments of Database Administration...

  • From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
  • To: <FREEMANR@xxxxxxxx>, "'Oracle-L (E-mail) ' " <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Sep 2004 17:40:12 -0400

 A fellow just asked me about a huge corporation solution for
backup..lots of pros a cons..but I told him the cenario to watch out for
was... When the backup fails... And all the recoverer has to say is.....
Well I press the "Gui button" and it doesn't work - or a get java script
error!! I guess we are in deep do do.  I don't want to be tell some CEO
that... I was know of a place where I saw  that cenario just about
happen... Lots of panic quite a while. An actually I know of a billion
dollar company that outsourced the backups... And needed to restore...
And it one day- went back to paper... .its a great story-  my Uncle was
the VP. Great outsourcing story :)

Brian

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman Robert - IL
Sent: Wednesday, September 22, 2004 5:30 PM
To: ''Oracle-L (E-mail) ' '
Subject: RE: My 10 Commandments of Database Administration...


I was just throwing out a topic for discussion.... thats all... :-) Felt
a bit chatty I suppose.

RF


-----Original Message-----
From: Carel-Jan Engel
To: Freeman Robert - IL
Cc: 'Oracle-L (E-mail) '
Sent: 9/22/2004 4:39 PM
Subject: Re: My 10 Commandments of Database Administration...

What do you want me to do: suggest a candidate for replacement or are we
going to add extra commandments?

There you go:

12: Thou shalt not use GUI's
13: Thou shalt script your commandline commands.

 <//www.freelists.org/webpage/oracle-l>=20







Best regards,





Carel-Jan Engel





=3D=3D=3D


If you think education is expensive, try ignorance. (Derek Bok)


=3D=3D=3D

=09


On Wed, 2004-09-22 at 23:17, Freeman Robert - IL wrote:=20

My 10 commandments of Database administration ... Anyone want to add to

this?



1. Thou shalt backup thy database.

2. Thou shalt test thy database backup, often.

3. Thou shalt remove as many single points of failure as possible.

4. Thou shalt not assume anything.

5. Thou shalt not use version x.0.0 of anything.

6. Thou shalt not assume a 99.999% buffer hit ratio is a good thing.

7. Thou shalt not add hardware, when fixing the application code/SQL
will

fix the problem.

8. Thou shalt not allow the user to have DBA privilges.

9. Thou shall document everything.

10. Thou shalt monitor ORACLE-L, read with abandon and imerse thyself in
all

that is Oracle.



and my personal 11th commandment



11. Thou shalt use RMAN, and buy all of Robert Freemans books.



Cheers,



Robert



--

 <//www.freelists.org/webpage/oracle-l>
//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: