Good one for the don't list. I suppose that the ARCHIVELOG mode question
depends on the situation, but for the most part I think ARCHIVELOG mode in
production is a good do...
Granted, if you don't have changes, then as long as you can stand the
outage, then you
can do cold backups.
:-)
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
-----Original Message-----
Sent: Monday, February 24, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
comments
#4 on the Do list assumes that you are an On-Line Transaction Process
database. If you are a Decision Support database, then ARCHIVELOG is not
needed. But, as a general rule, the world would be a better place if more
production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list
is the same as #4 on the DON'T list (or have they got a way now to do hot
backups without ARCHIVELOG mode?)
My #1 don't is never, ever delete an OS file. Rename it, wait a week, and
if everything is still running OK then delete the renamed file.
Freeman Robert -
IL <FREEMANR To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
@tusc.com> cc:
Sent by: root Subject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments
02/23/2003 05:23
PM
Please respond
to ORACLE-L
Here is the list of top 10 do's and don't that I came up with.
#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other Resources
#9 - Do Establish Standards and Change Control Processes
#10 - Do Think Ahead
Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
(With regards to Cary!)
Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.
Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything
Ok, anyone wanna comment?
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
