| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
On a DSS the database is usually in maintenance mode for batch updates (usually Friday night). After the updates you can do a cold backup or full export before bringing the database on-line for regular users. The database would normally not have any other update activity.
But in most instances ARCHIVELOG mode would be the way to go. I do not really disagree with the list as it stands, I was just pointing out a reasonable exception.
"Jesse, Rich"
<Rich.Jesse To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
@qtiworld.com> cc:
Sent by: root Subject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
02/24/2003 11:14
AM
Please respond
to ORACLE-L
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: Thomas Day INET: tday6_at_csc.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).Received on Mon Feb 24 2003 - 11:29:58 CST
 |
 |