RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Rich,

I agree. We have a warehouse here that is not in archivelog mode. They perform loads two days a week (Sunday and Monday) followed by a cold backup on Tuesday. The cold backup is now taking 18 hours to complete. I've suggested switching into Archivelog mode and performing Rman backups - at least the database is up and available to the users during the backup! It's probably going to happen, just waiting for the proper discussion.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, February 24, 2003 11:14 AM To: Multiple recipients of list ORACLE-L comments

Wouldn't ARCHIVELOG on a DSS DB depend on how much downtime you can withstand on that DB? If your recovery time for most situations is much shorter using ARCHIVELOG mode (perhaps on very large DBs or systems w/limited IO), wouldn't that be better than NOARCHIVELOG?

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

-----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 <ORACLE-L_at_fatcity.com>                    
                      @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: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

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: ListGuru_at_fatcity.com (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: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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: ListGuru_at_fatcity.com (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).