All right folks, I'm collecting misconceptions, of the type held by newbies and
oldtimers alike. My OOW proposal this year is for a presentation and paper on a
whole laundry list of these things, similar to what I wrote for hot backup. I
want to share what I have so far and solicit input for your favorites (pet
peeves). I most certainly will credit individuals and this list for any ideas I
glean.
So far my favorite misconceptions are:
* Hot backup stops writing to datafiles
* All network communication is done through the listener
* Always 'switch logfile' after (before, inbetween) hot backups
* Media recovery is required if you crash during backup mode
* Cold backup once a week ("just in case," "as a 'baseline'")
* Export is a good way to back up your database
* Shutdown abort is bad, crash recovery time is as long as 'shutdown immediate'
* Listener.log/alert.log clearing confusion
* ORA-1555 can be solved by setting transaction (use specific rollback seg)
* Big batch jobs should use one big RBS
* ORA-600 means you have corruption / just call support for ORA-600
* Lots of extents are bad
* Databases can't be renamed
* Select count (1) is better than count (*).
* Listeners have to be started before the instance
* NOLOGGING turns off logging for all operations
* Oracle Corp. won't support NFS datafiles
* checkpoint not complete - misguided solutions
* Must reinstantiate standby after failover by recopying
* redolog size change requires outage
What's *your* pet misconception?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 26 Jun 2001, novicedba wrote:
> I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
> I was shocked to read Hot backup mode explained
> If this is true then I may be a victim of a disease called
> 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK style)
> Please help me. If some one has few more articles like this enlighten me
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
