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
[EMAIL PROTECTED] 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 <[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: Jesse, Rich
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: Mercadante, Thomas F
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).
