RE: My 10 Commandments of Database Administration...

 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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:

1. Thou shalt not use GUI's
2. Thou shalt script your commandline commands.

 <http://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.

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

that is Oracle.

and my personal 11th commandment

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

Cheers,

Robert

--

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

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