My 10 commandments of Database administration ... Anyone want to add to
this?
- Thou shalt backup thy database.
- Thou shalt test thy database backup, often.
- Thou shalt remove as many single points of failure as possible.
- Thou shalt not assume anything.
- Thou shalt not use version x.0.0 of anything.
- Thou shalt not assume a 99.999% buffer hit ratio is a good thing.
- Thou shalt not add hardware, when fixing the application code/SQL will
fix the problem.
- Thou shalt not allow the user to have DBA privilges.
- Thou shall document everything.
- Thou shalt monitor ORACLE-L, read with abandon and imerse thyself in all
that is Oracle.
and my personal 11th commandment
- Thou shalt use RMAN, and buy all of Robert Freemans books.
Cheers,
Robert
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 22 2004 - 16:13:11 CDT