RE: OT: Re: Common Oracle RDBMS Misconceptions
Rachel, I love those animations on the last slide!! :0) g -Original Message- Sent: Wednesday, June 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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).
RE: OT: Re: Common Oracle RDBMS Misconceptions
thanks I thought it would be a good way to end it on a smile From: Guy Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Re: Common Oracle RDBMS Misconceptions Date: Fri, 29 Jun 2001 08:11:48 -0800 Rachel, I love those animations on the last slide!! :0) g -Original Message- Sent: Wednesday, June 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
Re: Common Oracle RDBMS Misconceptions
hi chris, I was shocked because if one paragraph can be wrong, then others can be wrong too. Meaning all books may have something that is wrong, Oracle manual not being an exception coz I have found oracle manual totally contradicting its own statements. Correct me if I am wrong coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 11:00 PM I think he was shocked by the fact he had a completely different opinion, and many as well as oracle preach similar opinions. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 7:15 AM To: Multiple recipients of list ORACLE-L well whats wrong with the article. It is true. It is the way Oracle Handles the HOT Backup. Ravinder Vladimir Begun [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L crimea.ua [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions 26-Jun-2001 06:33 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba 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
Re: Common Oracle RDBMS Misconceptions
I want pointers to some more articles like that so that I rid myself of the disease called 'Common Oracle RDBMS Misconceptions' enlighten me with clear explanations along with proof coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 4:03 PM On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba 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).
Re: Common Oracle RDBMS Misconceptions
Hi, Can't remember who started this thread but the most common misconception I see is : NOLOGGING (UNRECOVERABLE) stops redo log generation. though another favourite of mine is : The Universal Installer is useful and You can use the 8i database assistant to reliably create a database. Regards, Mike Disclaimer : 2 of the above statements are only my opinion and are not necessarily shared by my other personalities. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Common Oracle RDBMS Misconceptions
Hi Slightly off-topic ... if you're interested in a dictionary of clear definitions of mystical concepts, may I recommend ... http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/tail-recursion.html There's also a well-written boil-down of the last 50 years of IT development into one and a half paragraphs on http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/Infinite-Monkey-Theorem .html Cheers Greg -Original Message- Sent: Thursday, 28 June 2001 14:21 To: Multiple recipients of list ORACLE-L I want pointers to some more articles like that so that I rid myself of the disease called 'Common Oracle RDBMS Misconceptions' enlighten me with clear explanations along with proof coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 4:03 PM On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba 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)... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Solomon 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).
RE: Common Oracle RDBMS Misconceptions
I still like the Scott Adams variant: If you have an infinite number of monkeys and an infinite number of type writers, then you will eventually get ... a lot of dead monkeys Tip: You need to feed them --- Greg Solomon [EMAIL PROTECTED] wrote: Hi Slightly off-topic ... if you're interested in a dictionary of clear definitions of mystical concepts, may I recommend ... http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/tail-recursion.html There's also a well-written boil-down of the last 50 years of IT development into one and a half paragraphs on http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/Infinite-Monkey-Theorem .html Cheers Greg -Original Message- Sent: Thursday, 28 June 2001 14:21 To: Multiple recipients of list ORACLE-L I want pointers to some more articles like that so that I rid myself of the disease called 'Common Oracle RDBMS Misconceptions' enlighten me with clear explanations along with proof coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 4:03 PM On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba 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)... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Solomon 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Re: Common Oracle RDBMS Misconceptions
sorry greg I could make neither head nor tail of the links coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 8:49 PM Hi Slightly off-topic ... if you're interested in a dictionary of clear definitions of mystical concepts, may I recommend ... http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/tail-recursion.html There's also a well-written boil-down of the last 50 years of IT development into one and a half paragraphs on http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/Infinite-Monkey-Theorem .html Cheers Greg -Original Message- Sent: Thursday, 28 June 2001 14:21 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba 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).
Re: Common Oracle RDBMS Misconceptions
Sorry, that attempt at humour has been withdrawn due to quality control issues. Regards, Mike |+--- || novicedba | || novicedba@ho| || tmail.com | || | || 06/27/01 | || 06:20 AM | || Please | || respond to | || ORACLE-L | || | |+--- --| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]| | cc: (bcc: Mike Hately/ETECH) | | Subject: Re: Common Oracle RDBMS Misconceptions| --| well it does not exist will you 'please' be more clear as to what you want to convey coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 8:16 PM I've never found hot backups shocking myself. Is it possible that rather than visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be checking). If it does exist I'm sure that switching logs means something entirely different there. Regards, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Common Oracle RDBMS Misconceptions
Tee hee Mike said spank hooo ho -Original Message- Sent: 26 June 2001 14:47 To: Multiple recipients of list ORACLE-L I've never found hot backups shocking myself. Is it possible that rather than visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be checking). If it does exist I'm sure that switching logs means something entirely different there. Regards, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. Northern Electric plc Carliol House Market Street Newcastle-upon-Tyne NE1 6NE Registered in England and Wales: Number 2366942 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Garner, John (NESL-IT) 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).
RE: Common Oracle RDBMS Misconceptions
Yes, but look also at bug 1176609. Dr. Nikolay Kumanov MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:[EMAIL PROTECTED] Show me a completely smooth operation and I'll show you someone who's covering mistakes. Real boats rock. - Frank Herbert, Chapterhouse: Dune -Original Message- Posted At: Wednesday, June 27, 2001 3:51 AM Posted To: Oracle Conversation: Common Oracle RDBMS Misconceptions snip * You *have* to create an additional Rollback segment in the SYSTEM tablespace before creating *any* object in a tablespace other than SYSTEM (even additional Rbs in a non-SYSTEM tablespace). This used to be true in V6 and before, not anymore. snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikolay Kumanov 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).
RE: Common Oracle RDBMS Misconceptions
I guess so .. as when I told the new guys at my place about they very much went into defensive mode on this one. Christopher Spence To: Multiple recipients of list ORACLE-L cspence@Fuel[EMAIL PROTECTED] Spot.comcc: Sent by: Subject: RE: Common Oracle RDBMS root@fatcity.Misconceptions com 27-Jun-2001 01:30 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book I think he was shocked by the fact he had a completely different opinion, and many as well as oracle preach similar opinions. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 7:15 AM To: Multiple recipients of list ORACLE-L well whats wrong with the article. It is true. It is the way Oracle Handles the HOT Backup. Ravinder Vladimir Begun [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L crimea.ua [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions 26-Jun-2001 06:33 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego
Re: OT: Re: Common Oracle RDBMS Misconceptions
Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 20:30:31 -0800 Rachel, i'm not even on the board(OOUG) anymore(seems most people forget that). Hit up Kevin, he's playing webmaster. joe Rachel Carmichael wrote: dunno... it's their site. oh JOE! I'll see if I can get it fixed there. If not, again, will see if I can get it onto the NYOUG site From: Post, Ethan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 18:16:04 -0800 Couldn't open it with PPT 97. - E -Original Message- Sent: Tuesday, June 26, 2001 6:10 PM To: Multiple recipients of list ORACLE-L well, the slides are at: http://www.ooug.org/slides.html i'm trying to find a copy of the paper... we gave it in Ohio and at ECO but I don't see the paper on their sites. Once I get a copy, it will get posted to the NYOUG site (www.nyoug.org) Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 12:26:20 -0800 Where can I get the exploding the myths paper? Thanks, Ken Janusz, CPIM Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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
RE: Common Oracle RDBMS Misconceptions - standby db?
Title: RE: Common Oracle RDBMS Misconceptions - standby db? I guess that's the scenario I was thinking of, Stephane. Primary completely hosed and needing modification in one way or the other... and several hours between failover and switching back with the possibility of a few lost transactions. Thanks for your comments. Lisa -Original Message- From: Stephane Faroult [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 8:28 PM To: Multiple recipients of list ORACLE-L Subject: Re: Common Oracle RDBMS Misconceptions - standby db? But in practice, why would you switch to the standby database, unless the primary database is crashed or worse? You know how it is in a production environment, the database crashes. Even if failover is easy, you always have to instruct users to connect as scott/tiger@backup instead of scott/tiger@prod - or perhaps modify the tnsnames.ora to make it transparent, or perhaps play with IP addresses which may mean trouble for a while with in-memory routing tables etc. My point is that, even if the switch can be quasi-immediate, it is not so easy, so people will naturally try to make the main machine work first, there will be some delay assessing the damage, waiting until 2am to ring the VP in his bed to get the authorization to switch, etc. In real life, half-an-hour or an hour is easily passed before everybody is back at work on the backup machine, busy trying to catch up on the wasted time. Do not forget that since the transmission of redo logs is asynchronous (I have heard about improvements with 9i) some transactions - committed ones - will have been lost, so users will have to check and probably reenter the missing transactions. At this point the main machine will probably be totally out of order. Wait another 2 or 4 hours to have somebody to come if it's a hardware problem, I guess that when everything is over everybody will be on their knees and the last thing they will have in mind is make the old primary database the new standby - assuming of course that all files are intact. And even if the ex-standby machine is possibly less powerful, everybody will probably wait until a quieter time, say the W/E, to switch back to the initial configuration. At which time, in all likelihood, a full database copy will have become necessary; I think that the simple fact of having reentered a couple of transactions not transmitted yet to the standby database would require it. Do I err ? -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax: +44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- Jeremiah Wilton wrote: With graceful standby failover (I demo'd it last year at OOW), you can switch back and forth, back and forth as many times as you want without recopying any database. Basically, when you fail over to a standby, you shut down the primary, apply all the archived redologs to the standby, then copy all the online logs and the controlfile from the primary to the standby. People who use incremental checkpoints (DB_BLOCK_MAX_DIRTY_TARGET) must do a 'create controlfile reuse database blah noresetlogs' at this point. Other people don't have to. Finally, you recover database to get the last one or two online logs and open the standby noresetogs. The standby just picks up the chain of SCNs where the primary left off. The old primary can be immediately pressed into service as a standby. Just generate a standby controlfile on the new primary, copy it into place on the old primary and start it up as a standby database. You can go back and forth in this way as many times as you want, and one just picks up the chain of SCNs where the last one left off. You never get a divergence of changes. I have talked to people who found this out, and looked like they were going to cry, thinking of the countless hours they had spent after every standby failover, recopying to the standby to get it rollong forward again. In 9i, they have an automated graceful failover mechanism for standby database. I haven't taken a look at it yet. Probably it is a massive java-based GUI that instantly consumes 512Mb or RAM. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Koivu, Lisa wrote: OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying' is a misconception. Yes, like many of the things you state below, the documentation does say that - once you open a standby db in r/w mode, it is no longer a valid standby after switching back to the primary. Can someone shed some light on why this is not true? It seemed
RE: Common Oracle RDBMS Misconceptions - standby db?
Title: RE: Common Oracle RDBMS Misconceptions - standby db? Thank you Jeremiah for your explanation. But to clarify, you can't have both databases open at the same time, can you? That's where I hosed stuff up the first time, and I realized why it didn't work immediately after seeing my error (incompatible archive logs). Or am I off track? -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 7:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: Common Oracle RDBMS Misconceptions - standby db? With graceful standby failover (I demo'd it last year at OOW), you can switch back and forth, back and forth as many times as you want without recopying any database. Basically, when you fail over to a standby, you shut down the primary, apply all the archived redologs to the standby, then copy all the online logs and the controlfile from the primary to the standby. People who use incremental checkpoints (DB_BLOCK_MAX_DIRTY_TARGET) must do a 'create controlfile reuse database blah noresetlogs' at this point. Other people don't have to. Finally, you recover database to get the last one or two online logs and open the standby noresetogs. The standby just picks up the chain of SCNs where the primary left off. The old primary can be immediately pressed into service as a standby. Just generate a standby controlfile on the new primary, copy it into place on the old primary and start it up as a standby database. You can go back and forth in this way as many times as you want, and one just picks up the chain of SCNs where the last one left off. You never get a divergence of changes. I have talked to people who found this out, and looked like they were going to cry, thinking of the countless hours they had spent after every standby failover, recopying to the standby to get it rollong forward again. In 9i, they have an automated graceful failover mechanism for standby database. I haven't taken a look at it yet. Probably it is a massive java-based GUI that instantly consumes 512Mb or RAM. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Koivu, Lisa wrote: OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying' is a misconception. Yes, like many of the things you state below, the documentation does say that - once you open a standby db in r/w mode, it is no longer a valid standby after switching back to the primary. Can someone shed some light on why this is not true? It seemed to make complete sense to me. I can see how opening a database read only will work and not invalidate the standby, but r/w? -- 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).
RE: OT: Re: Common Oracle RDBMS Misconceptions
Rachel: The problem seems to be the ftp from work to the OOUG web site (it gets corrupted in the transfer.) I'll try again later from home. Kevin -Original Message- Sent: Wednesday, June 27, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 20:30:31 -0800 Rachel, i'm not even on the board(OOUG) anymore(seems most people forget that). Hit up Kevin, he's playing webmaster. joe Rachel Carmichael wrote: dunno... it's their site. oh JOE! I'll see if I can get it fixed there. If not, again, will see if I can get it onto the NYOUG site From: Post, Ethan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 18:16:04 -0800 Couldn't open it with PPT 97. - E -Original Message- Sent: Tuesday, June 26, 2001 6:10 PM To: Multiple recipients of list ORACLE-L well, the slides are at: http://www.ooug.org/slides.html i'm trying to find a copy of the paper... we gave it in Ohio and at ECO but I don't see the paper on their sites. Once I get a copy, it will get posted to the NYOUG site (www.nyoug.org) Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 12:26:20 -0800 Where can I get the exploding the myths paper? Thanks, Ken Janusz, CPIM Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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
RE: Common Oracle RDBMS Misconceptions - standby db?
tears of happiness thank you, thank you, thank you... /tears of happiness --- Jeremiah Wilton [EMAIL PROTECTED] wrote: With graceful standby failover (I demo'd it last year at OOW), you can switch back and forth, back and forth as many times as you want without recopying any database. Basically, when you fail over to a standby, you shut down the primary, apply all the archived redologs to the standby, then copy all the online logs and the controlfile from the primary to the standby. People who use incremental checkpoints (DB_BLOCK_MAX_DIRTY_TARGET) must do a 'create controlfile reuse database blah noresetlogs' at this point. Other people don't have to. Finally, you recover database to get the last one or two online logs and open the standby noresetogs. The standby just picks up the chain of SCNs where the primary left off. The old primary can be immediately pressed into service as a standby. Just generate a standby controlfile on the new primary, copy it into place on the old primary and start it up as a standby database. You can go back and forth in this way as many times as you want, and one just picks up the chain of SCNs where the last one left off. You never get a divergence of changes. I have talked to people who found this out, and looked like they were going to cry, thinking of the countless hours they had spent after every standby failover, recopying to the standby to get it rollong forward again. In 9i, they have an automated graceful failover mechanism for standby database. I haven't taken a look at it yet. Probably it is a massive java-based GUI that instantly consumes 512Mb or RAM. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Koivu, Lisa wrote: OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying' is a misconception. Yes, like many of the things you state below, the documentation does say that - once you open a standby db in r/w mode, it is no longer a valid standby after switching back to the primary. Can someone shed some light on why this is not true? It seemed to make complete sense to me. I can see how opening a database read only will work and not invalidate the standby, but r/w? -- 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti 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).
RE: Common Oracle RDBMS Misconceptions - standby db?
Also check out the notes on metalink: #90817.1. It states all the steps and
concept clearly!
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
mohammed
bhatti To: Multiple recipients of list ORACLE-L
mkb125@yahoo[EMAIL PROTECTED]
.comcc:
Sent by: Subject: RE: Common Oracle RDBMS
Misconceptions -
root@fatcity.standby db?
com
06/27/01
09:20 AM
Please
respond to
ORACLE-L
tears of happiness
thank you, thank you, thank you...
/tears of happiness
--- Jeremiah Wilton [EMAIL PROTECTED] wrote:
With graceful standby failover (I demo'd it last
year at OOW), you can switch
back and forth, back and forth as many times as you
want without recopying any
database.
Basically, when you fail over to a standby, you shut
down the primary, apply all
the archived redologs to the standby, then copy all
the online logs and the
controlfile from the primary to the standby. People
who use incremental
checkpoints (DB_BLOCK_MAX_DIRTY_TARGET) must do a
'create controlfile reuse
database blah noresetlogs' at this point. Other
people don't have to.
Finally, you recover database to get the last one
or two online logs and open
the standby noresetogs. The standby just picks up
the chain of SCNs where the
primary left off.
The old primary can be immediately pressed into
service as a standby. Just
generate a standby controlfile on the new primary,
copy it into place on the old
primary and start it up as a standby database.
You can go back and forth in this way as many times
as you want, and one just
picks up the chain of SCNs where the last one left
off. You never get a
divergence of changes.
I have talked to people who found this out, and
looked like they were going to
cry, thinking of the countless hours they had spent
after every standby
failover, recopying to the standby to get it rollong
forward again.
In 9i, they have an automated graceful failover
mechanism for standby
database. I haven't taken a look at it yet.
Probably it is a massive
java-based GUI that instantly consumes 512Mb or RAM.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 26 Jun 2001, Koivu, Lisa wrote:
OK. I admit my knowledge on standby is minimal,
having only read up on it,
fiddled with it and used the idea sparingly for
migrations.
However, Jeremiah, I'm very curious. You state
that 'Must reinstantiate
standby after failover by recopying' is a
misconception. Yes, like many of
the things you state below, the documentation does
say that - once you open
a standby db in r/w mode, it is no longer a valid
standby after switching
back to the primary.
Can someone shed some light on why this is not
true? It seemed to make
complete sense to me. I can see how opening a
database read only will work
and not invalidate the standby, but r/w?
--
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
Re: Common Oracle RDBMS Misconceptions
How about timed_statistics=true is a performance overhead. Or you still worry about temp segments not being released after a sort. From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough 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).
Re: Common Oracle RDBMS Misconceptions - standby db?
On Tue, 26 Jun 2001, Stephane Faroult wrote: But in practice, why would you switch to the standby database, unless the primary database is crashed or worse? - Hardware replace/repair - Move to a larger host - O/S upgrade - File layout revision - Planned/impending infrastructure outage - Database problem in which datafiles are corrupted but redologs are not - Frequent memory faults - Any chronic but not terminal host-related problem - Migration to a new I/O subsystem You know how it is in a production environment, the database crashes. Even if failover is easy, you always have to instruct users to connect as scott/tiger@backup instead of scott/tiger@prod - or perhaps modify the tnsnames.ora to make it transparent, or perhaps play with IP addresses which may mean trouble for a while with in-memory routing tables etc. Well, I guess the presumption is that if someone went to the trouble of setting up a standby, they would actually have a way to point people at the standby in the event of a failover. As you point out, there are a number of scriptable solutions that are suitable. The easiest, and one you mention, is IP address assumption. This is the same method that is used by HA cluster solutions like Veritas HA, HP MC Serviceguard and Compaq TruCluster. It is easy to script, manage and execute. Contrary to your belief, no problems with in-memory routing tables arise, and the change is immediate. It is a simple matter of 'ifconfig delete' and 'ifconfig alias.' These actions take all necessary steps to notify routers and switches on your subnet that ther MAC address of the IP has changed and that packets should be routed accordingly. Using a dedicated IP address just for the database service is a good idea even if you aren't building a standby or HA solution. It comes in handy if you ever decide you want to rehost the database. My point is that, even if the switch can be quasi-immediate, it is not so easy, so people will naturally try to make the main machine work first, there will be some delay assessing the damage, waiting until 2am to ring the VP in his bed to get the authorization to switch, etc. Well, not everyone has to have authorization from a VP to fail over to a standby. The endless troubleshooting is a real problem. At many sites, they set an upper bound on time spent on diagnostics, and require a failover (if a failover is appropriate) after some number of minutes. The various failover scenarios are scripted and packaged in advance. You don't rush around trying to figure it out when the system is failing. In real life, half-an-hour or an hour is easily passed before everybody is back at work on the backup machine, busy trying to catch up on the wasted time. Do not forget that since the transmission of redo logs is asynchronous (I have heard about improvements with 9i) some transactions - committed ones - will have been lost, so users will have to check and probably reenter the missing transactions. At this point the main machine will probably be totally out of order. Wait another 2 or 4 hours to have somebody to come if it's a hardware problem, I guess that when everything is over everybody will be on their knees and the last thing they will have in mind is make the old primary database the new standby - assuming of course that all files are intact. And even if the ex-standby machine is possibly less powerful, everybody will probably wait until a quieter time, say the W/E, to switch back to the initial configuration. At which time, in all likelihood, a full database copy will have become necessary; I think that the simple fact of having reentered a couple of transactions not transmitted yet to the standby database would require it. Do I err ? Basically, the only time you wouldn't do a graceful failover is in the rare event that you didn't have access to the last few logs the primary had written. In that case, you would be forced to activate the standby database as of the time of the last log you have. This is one of the risks you take with a standby database, and the standby must be presented to others within the company as a redundant solution that may result in the loss of some large number of transactions, depending on how how often the standby pulls logs. There must be a contingency plan in place to handle this eventuality that takes your application and data into account. Synchronous log update on the standby side is available in 9.0, and available on previous versions using third-party technologies such as EMC SRDF or Veritas SRVM. These products can be employed to mirror the online logs and controlfile, in order to create a no-loss standby. The problem with this configuration is that it makes the primary beholden to network latency for log writes. This can have a significant impact on performance. I discuss *all* of these considerations at some length in my HA paper on my site. http://www.speakeasy.org/~jwilton/241.pdf -- Jeremiah
Re: Common Oracle RDBMS Misconceptions
Jeremiah, You've hit most of mine, but here are a few more: * It's OK to continue using a db after you've forced it open. * To remove a datafile from the db, all you need to do is offline drop it. * All there is to switching from RBO to CBO is to analyse the tables. * You can apply archived logs to an export. * TRANSACTIONS_PER_ROLLBACK_SEGMENT determines the max # of transactions that can use a rollback segment. * The way to resolve enqueue waits is to increase ENQUEUE_RESOURCES. * If OPTIMIZER_MODE=RULE then the RBO will always be used. Closely related to, if tkprof shows RULE then the RBO was used. * When in doubt, recreate the controlfile. * All changes to the data dictionary use the system RBS. OK, so it was more than a few ;) -- Anita --- Jeremiah Wilton [EMAIL PROTECTED] wrote: 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
RE: Common Oracle RDBMS Misconceptions - standby db?
I'm not sure, but he was probably referring to resyncing a standby. Some people think that in order to get the standby back up after a crash, they need to start over by copying all of the datafiles. Instead, all you have to do is ftp the archive log files over, recover standby database and apply the logs, and put into managed recovery mode. Mike From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Common Oracle RDBMS Misconceptions - standby db? Date: Tue, 26 Jun 2001 11:12:24 -0800 OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying' is a misconception. Yes, like many of the things you state below, the documentation does say that - once you open a standby db in r/w mode, it is no longer a valid standby after switching back to the primary. Can someone shed some light on why this is not true? It seemed to make complete sense to me. I can see how opening a database read only will work and not invalidate the standby, but r/w? Thanks Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Subject:Re: Common Oracle RDBMS Misconceptions Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L
Re: OT: Re: Common Oracle RDBMS Misconceptions
Toepke, Kevin M wrote: Rachel: The problem seems to be the ftp from work to the OOUG web site (it gets corrupted in the transfer.) I'll try again later from home. Kevin -Original Message- Sent: Wednesday, June 27, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel Rachel, In the presentation, I saw: always set timed_statistics=true having lots of extents is not a problem - |lots|= ??? Care to repent - or stipulate that it was for a de-supported (or soon to be) version? Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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).
Re: Common Oracle RDBMS Misconceptions
On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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).
Re: Common Oracle RDBMS Misconceptions
well whats wrong with the article. It is true. It is the way Oracle Handles the HOT Backup. Ravinder Vladimir Begun [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L crimea.ua [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions 26-Jun-2001 06:33 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Re: Common Oracle RDBMS Misconceptions
Well i dont know about everyone else, but i knew thats how the hot backup worked, but then again, i've not attended oracle education classes either, just some hard core reading and have gotten all of my backup/recovery concepts from Rama Velpuri's book. An excellent book if you dont have it. joe On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
Re: Common Oracle RDBMS Misconceptions
we've had this discussion here a number of times. And I know that Oracle teaches how hot backup works, at least in the Server Internals classes I didn't think it was shocking though :) From: Joseph S. Testa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 04:00:54 -0800 Well i dont know about everyone else, but i knew thats how the hot backup worked, but then again, i've not attended oracle education classes either, just some hard core reading and have gotten all of my backup/recovery concepts from Rama Velpuri's book. An excellent book if you dont have it. joe On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
RE: Common Oracle RDBMS Misconceptions
Yep, that's the way it works. Whoever started the rumor that the datafiles were unwriteable hadn't looked into the process deeply enough to understand it. The Oracle Ed. class that I took for backup and recovery explained the process exactly as it is, using the checkpoint, redo, and rollbacks but still writing to files. Rodd -Original Message- From: novicedba [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 4:06 AM To: Multiple recipients of list ORACLE-L Subject: Common Oracle RDBMS Misconceptions Hi everyone, I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained http://www.speakeasy.org/~jwilton/hot-backup.html 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 coz I am a novice Oracle Certifiable DBBS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney 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).
RE: Common Oracle RDBMS Misconceptions
Same as in normal operation. That's where the before image of any data changed is stored for undo. My point was that Oracle operates as you would normally expect it to, except the header block of the files are frozen at the start backup checkpoint, and you generate more redo as it is logging the stuff that needs to be applied when restored (until the end backup command). Original Message On 6/26/01, 11:10:28 AM, Jeremiah Wilton [EMAIL PROTECTED] wrote regarding RE: Common Oracle RDBMS Misconceptions: Rollbacks? What's their role in the hot backup mechanism? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Holman, Rodney wrote: Yep, that's the way it works. Whoever started the rumor that the datafiles were unwriteable hadn't looked into the process deeply enough to understand it. The Oracle Ed. class that I took for backup and recovery explained the process exactly as it is, using the checkpoint, redo, and rollbacks but still writing to files. -Original Message- From: novicedba [SMTP:[EMAIL PROTECTED]] I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained http://www.speakeasy.org/~jwilton/hot-backup.html 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 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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).
RE: Common Oracle RDBMS Misconceptions
Rollbacks? What's their role in the hot backup mechanism? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Holman, Rodney wrote: Yep, that's the way it works. Whoever started the rumor that the datafiles were unwriteable hadn't looked into the process deeply enough to understand it. The Oracle Ed. class that I took for backup and recovery explained the process exactly as it is, using the checkpoint, redo, and rollbacks but still writing to files. -Original Message- From: novicedba [SMTP:[EMAIL PROTECTED]] I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained http://www.speakeasy.org/~jwilton/hot-backup.html 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 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).
RE: Common Oracle RDBMS Misconceptions
yeah, that is an awesome write up he did. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: novicedba [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 26, 2001 5:06 AMTo: Multiple recipients of list ORACLE-LSubject: Common Oracle RDBMS Misconceptions Hi everyone, 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 cozI am anoviceOracle Certifiable DBBS
RE: Common Oracle RDBMS Misconceptions
I think he was shocked by the fact he had a completely different opinion, and many as well as oracle preach similar opinions. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 7:15 AM To: Multiple recipients of list ORACLE-L well whats wrong with the article. It is true. It is the way Oracle Handles the HOT Backup. Ravinder Vladimir Begun [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L crimea.ua [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions 26-Jun-2001 06:33 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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).
RE: Common Oracle RDBMS Misconceptions
Thank you - I just spewed coffee all over my monitor! ROFLMAO!!! Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 9:47 AM To: Multiple recipients of list ORACLE-L Subject: Re: Common Oracle RDBMS Misconceptions I've never found hot backups shocking myself. Is it possible that rather than visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be checking). If it does exist I'm sure that switching logs means something entirely different there. Regards, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Common Oracle RDBMS Misconceptions
Bhahahaah Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 26, 2001 10:47 AM To: Multiple recipients of list ORACLE-L I've never found hot backups shocking myself. Is it possible that rather than visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be checking). If it does exist I'm sure that switching logs means something entirely different there. Regards, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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).
Re: Common Oracle RDBMS Misconceptions
Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
RE: Common Oracle RDBMS Misconceptions
Well perhaps you can start writing articles for people. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 26, 2001 8:01 AM To: Multiple recipients of list ORACLE-L Well i dont know about everyone else, but i knew thats how the hot backup worked, but then again, i've not attended oracle education classes either, just some hard core reading and have gotten all of my backup/recovery concepts from Rama Velpuri's book. An excellent book if you dont have it. joe On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, 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 -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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).
RE: Common Oracle RDBMS Misconceptions
oh yea baby. Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -Original Message- Sent: Tuesday, June 26, 2001 10:47 AM To: Multiple recipients of list ORACLE-L I've never found hot backups shocking myself. Is it possible that rather than visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be checking). If it does exist I'm sure that switching logs means something entirely different there. Regards, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Tom 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).
RE: Common Oracle RDBMS Misconceptions
Based on Gaja's book, tune based on waits not based on hit ratios. Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -Original Message- Sent: Tuesday, June 26, 2001 1:05 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Tom 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).
OT RE: Common Oracle RDBMS Misconceptions
Yea, hit ratios are never important. Ever. For anything. -Original Message- Sent: Tuesday, June 26, 2001 2:01 PM To: Multiple recipients of list ORACLE-L Based on Gaja's book, tune based on waits not based on hit ratios. Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -Original Message- Sent: Tuesday, June 26, 2001 1:05 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Tom 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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).
Re: Common Oracle RDBMS Misconceptions
1) If an index exists, it will always be used. 2) It is ALWAYS a database problem. Terry Jeremiah Wilton wrote: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball 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).
OT RE: Common Oracle RDBMS Misconceptions
I think it's on a site somewhere in Bulgaria. -Original Message- Sent: Tuesday, June 26, 2001 2:47 PM To: Multiple recipients of list ORACLE-L Rachel, I am interested in reading your paper - Exploding the Myths. How do I get access to this paper? Is it available on any website? Thanks Rao -Original Message- Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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).
RE: Common Oracle RDBMS Misconceptions
Hi Jeremiah, First, I believe it's a misconception that on a Unix system there can be no data lost in an Oracle DB from a system crash. This HAS to be a function of syncer, doesn't it? And, therefore, until syncer decides any buffer writes actually go to disk, transactions can be toast. Granted, this is a very short time, but the possibility would still exist for a standalone Oracle DB, especially for one with a high transaction count. But I haven't seen any official info, whether true or false, from Oracle about this. Comments, anyone??? Second, I hope you're going to have explanations and/or qualifications (even brief ones!) about the misconceptions somewhere on your website? There's a few in your list that have me intrigued! Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, June 26, 2001 12:05 To: Multiple recipients of list ORACLE-L 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. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
RE: Common Oracle RDBMS Misconceptions
Rachel, I am interested in reading your paper - Exploding the Myths. How do I get access to this paper? Is it available on any website? Thanks Rao -Original Message- Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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).
RE: Common Oracle RDBMS Misconceptions
Title: RE: Common Oracle RDBMS Misconceptions I missed the call for presentations for OOW! Is it too late? Where do I find it? (looked at ioug.org, didn't see it) R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Give me an hour alone in a bank Pay all my tickets, wipe the slate blank Give me a car, fill up the tank Tell me a boat full of lawyers just sank - Robert Cray -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Subject: Re: Common Oracle RDBMS Misconceptions Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
RE: Common Oracle RDBMS Misconceptions
Is your paper available yet? I would be curious to read it. And something to add: Misconceptions: 1. 99.9% hit ratio is perfect 2. Number datatype storage 3. Index performs better than full table scan 4. Raid 5 is poor performance for low write applications 5. DBA's get weekends off I only took a few seconds to come up with these so I feel like I have added something. There are many, and it is a great topic to write about. Please pay Microsoft to complete rebooting your PC. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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
RE: Common Oracle RDBMS Misconceptions - standby db?
Title: RE: Common Oracle RDBMS Misconceptions - standby db? OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying' is a misconception. Yes, like many of the things you state below, the documentation does say that - once you open a standby db in r/w mode, it is no longer a valid standby after switching back to the primary. Can someone shed some light on why this is not true? It seemed to make complete sense to me. I can see how opening a database read only will work and not invalidate the standby, but r/w? Thanks Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Subject: Re: Common Oracle RDBMS Misconceptions Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
RE: Common Oracle RDBMS Misconceptions
1) A full table scan is a bad thing 2) the order of things in the FROM/WHERE clause matters (is true in the RULE-based world) -Original Message- Sent: Tuesday, June 26, 2001 2:27 PM To: Multiple recipients of list ORACLE-L 1) If an index exists, it will always be used. 2) It is ALWAYS a database problem. Terry Jeremiah Wilton wrote: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M 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).
RE: OT RE: Common Oracle RDBMS Misconceptions
Gaja makes very good points about the importance of hit ratios but I don't think we should go 180 degrees the other way and abandon them all together. They certainly tell us something. They just shouldn't necessarily be a tuning goal. However, most of us are only seeing the hit ratio as of database startup. This is somewhat meaningless. If you are aware of your hit ratios as they look throughout the average day they become more meaningful when something is awry. I think the real misconception is bad hit ratio = more memory or bad hit ratio = bad dba. This is what we need to clear up and bring some commen sense to. - Ethan -Original Message- Sent: Tuesday, June 26, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Yea, hit ratios are never important. Ever. For anything. -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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).
RE: Common Oracle RDBMS Misconceptions
On Tue, 26 Jun 2001, Jesse, Rich wrote: First, I believe it's a misconception that on a Unix system there can be no data lost in an Oracle DB from a system crash. This HAS to be a function of syncer, doesn't it? And, therefore, until syncer decides any buffer writes actually go to disk, transactions can be toast. Granted, this is a very short time, but the possibility would still exist for a standalone Oracle DB, especially for one with a high transaction count. But I haven't seen any official info, whether true or false, from Oracle about this. The question of whether a write results in data being written directly to disk or only to the UBC depends on the oflag that is used when a process open a file with the open() call. Oracle's log writer (I believe) opens the online redologs with the O_DSYNC flag. That means that a given write() call will not return successfully (and thus a commit will not return as complete) until that data has been written down to disk. Syncer is only responsible for the data's write out to disk if a flag like O_RDWR was used to open the file. Your concern may apply to a disk subsystem and controller that have their own cache. In the case of these systems, they return success to the operating system as soon as a write has been successfully added to the controller's cache. Such controllers have battery backups, so that in case power is lost to the unit, pending writes in the cache can complete before the unit powers off. That battery backup on caching disk controllers is pretty key to running Oracle successfully. This is just the kind of caveat that I think would be good to include in a presentation on misconceptions. Second, I hope you're going to have explanations and/or qualifications (even brief ones!) about the misconceptions somewhere on your website? There's a few in your list that have me intrigued! Of course I plan to explain them, but tell me what intrigues you. I'd love to hash the issues out here before I make a fool of myself in SF in December. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- 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).
Re: Common Oracle RDBMS Misconceptions
Jesse, Rich wrote: Hi Jeremiah, First, I believe it's a misconception that on a Unix system there can be no data lost in an Oracle DB from a system crash. This HAS to be a function of syncer, doesn't it? And, therefore, until syncer decides any buffer writes actually go to disk, transactions can be toast. Granted, this is a very short time, but the possibility would still exist for a standalone Oracle DB, especially for one with a high transaction count. But I haven't seen any official info, whether true or false, from Oracle about this. Comments, anyone??? Second, I hope you're going to have explanations and/or qualifications (even brief ones!) about the misconceptions somewhere on your website? There's a few in your list that have me intrigued! Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA I got my information 15 years ago, but ... In fact, Oracle used to claim that they were using some undocumented Unix system calls (fflush() would have looked fine to me, but it musn't be subtle enough) to force Unix to sync and to return 'Committed' when your transaction is actually written to disk (I'd like to precise to the redo log files but they weren't any then). I have indeed met some systems where the said calls had probably not been implemented (or the Oracle charm offensive had not be enough to have it disclosed) and it was specifically specified in the installation guide that you HAD to use raw devices if you wanted to be certain not to lose a transaction. In fact 'lost transaction' doesn't mean that you do not lose any update, it just means that once you have got the acknowledgment from Oracle that it has been validated your change is safe. Concerning misconceptions, I find the topic interesting but tricky. There are some obvious misconceptions. There are also misconceptions today which were the plain truth some releases ago (some versions ago sometimes) - and may no longer be misconceptions in the future, so they have to be stamped with a version number. Oracle themselves have originated a number of misconceptions (eg, version 6.0 'automatically increasing extent size by a factor of 1.5 will solve fragmentation problems' - for a while, even rollback segments were submitted to the PCTINCREASE rule, totally insane as they soon noticed). Some good ideas never take off, or are dumped. Curious to find out how many of Oracle9i fancy features will prove, in the long term, to have been misconceptions. I guess I am growing more and more sceptical. My 0.02 cents. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
Re: Common Oracle RDBMS Misconceptions
Where can I get the exploding the myths paper? Thanks, Ken Janusz, CPIM Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: OT RE: Common Oracle RDBMS Misconceptions
I guess I shudda thrown a smiley in there. yikes... Anyway, I hope i am not in the minority when i say that i think hit ratios *are* important, even in tuning. I just don't think they are the sine qua non of tuning. -Original Message- Sent: Tuesday, June 26, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Gaja makes very good points about the importance of hit ratios but I don't think we should go 180 degrees the other way and abandon them all together. They certainly tell us something. They just shouldn't necessarily be a tuning goal. However, most of us are only seeing the hit ratio as of database startup. This is somewhat meaningless. If you are aware of your hit ratios as they look throughout the average day they become more meaningful when something is awry. I think the real misconception is bad hit ratio = more memory or bad hit ratio = bad dba. This is what we need to clear up and bring some commen sense to. - Ethan -Original Message- Sent: Tuesday, June 26, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Yea, hit ratios are never important. Ever. For anything. -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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).
RE: Common Oracle RDBMS Misconceptions
Too late!! Gaja stole it and wrote a book about it !! - Kirti -Original Message- From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:47 PM To: Multiple recipients of list ORACLE-L Subject: RE: Common Oracle RDBMS Misconceptions Rachel, I am interested in reading your paper - Exploding the Myths. How do I get access to this paper? Is it available on any website? Thanks Rao -Original Message- Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: Common Oracle RDBMS Misconceptions - standby db?
With graceful standby failover (I demo'd it last year at OOW), you can switch back and forth, back and forth as many times as you want without recopying any database. Basically, when you fail over to a standby, you shut down the primary, apply all the archived redologs to the standby, then copy all the online logs and the controlfile from the primary to the standby. People who use incremental checkpoints (DB_BLOCK_MAX_DIRTY_TARGET) must do a 'create controlfile reuse database blah noresetlogs' at this point. Other people don't have to. Finally, you recover database to get the last one or two online logs and open the standby noresetogs. The standby just picks up the chain of SCNs where the primary left off. The old primary can be immediately pressed into service as a standby. Just generate a standby controlfile on the new primary, copy it into place on the old primary and start it up as a standby database. You can go back and forth in this way as many times as you want, and one just picks up the chain of SCNs where the last one left off. You never get a divergence of changes. I have talked to people who found this out, and looked like they were going to cry, thinking of the countless hours they had spent after every standby failover, recopying to the standby to get it rollong forward again. In 9i, they have an automated graceful failover mechanism for standby database. I haven't taken a look at it yet. Probably it is a massive java-based GUI that instantly consumes 512Mb or RAM. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Koivu, Lisa wrote: OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying' is a misconception. Yes, like many of the things you state below, the documentation does say that - once you open a standby db in r/w mode, it is no longer a valid standby after switching back to the primary. Can someone shed some light on why this is not true? It seemed to make complete sense to me. I can see how opening a database read only will work and not invalidate the standby, but r/w? -- 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).
Re: Common Oracle RDBMS Misconceptions - standby db?
But in practice, why would you switch to the standby database, unless the primary database is crashed or worse? You know how it is in a production environment, the database crashes. Even if failover is easy, you always have to instruct users to connect as scott/tiger@backup instead of scott/tiger@prod - or perhaps modify the tnsnames.ora to make it transparent, or perhaps play with IP addresses which may mean trouble for a while with in-memory routing tables etc. My point is that, even if the switch can be quasi-immediate, it is not so easy, so people will naturally try to make the main machine work first, there will be some delay assessing the damage, waiting until 2am to ring the VP in his bed to get the authorization to switch, etc. In real life, half-an-hour or an hour is easily passed before everybody is back at work on the backup machine, busy trying to catch up on the wasted time. Do not forget that since the transmission of redo logs is asynchronous (I have heard about improvements with 9i) some transactions - committed ones - will have been lost, so users will have to check and probably reenter the missing transactions. At this point the main machine will probably be totally out of order. Wait another 2 or 4 hours to have somebody to come if it's a hardware problem, I guess that when everything is over everybody will be on their knees and the last thing they will have in mind is make the old primary database the new standby - assuming of course that all files are intact. And even if the ex-standby machine is possibly less powerful, everybody will probably wait until a quieter time, say the W/E, to switch back to the initial configuration. At which time, in all likelihood, a full database copy will have become necessary; I think that the simple fact of having reentered a couple of transactions not transmitted yet to the standby database would require it. Do I err ? -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- Jeremiah Wilton wrote: With graceful standby failover (I demo'd it last year at OOW), you can switch back and forth, back and forth as many times as you want without recopying any database. Basically, when you fail over to a standby, you shut down the primary, apply all the archived redologs to the standby, then copy all the online logs and the controlfile from the primary to the standby. People who use incremental checkpoints (DB_BLOCK_MAX_DIRTY_TARGET) must do a 'create controlfile reuse database blah noresetlogs' at this point. Other people don't have to. Finally, you recover database to get the last one or two online logs and open the standby noresetogs. The standby just picks up the chain of SCNs where the primary left off. The old primary can be immediately pressed into service as a standby. Just generate a standby controlfile on the new primary, copy it into place on the old primary and start it up as a standby database. You can go back and forth in this way as many times as you want, and one just picks up the chain of SCNs where the last one left off. You never get a divergence of changes. I have talked to people who found this out, and looked like they were going to cry, thinking of the countless hours they had spent after every standby failover, recopying to the standby to get it rollong forward again. In 9i, they have an automated graceful failover mechanism for standby database. I haven't taken a look at it yet. Probably it is a massive java-based GUI that instantly consumes 512Mb or RAM. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Koivu, Lisa wrote: OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying' is a misconception. Yes, like many of the things you state below, the documentation does say that - once you open a standby db in r/w mode, it is no longer a valid standby after switching back to the primary. Can someone shed some light on why this is not true? It seemed to make complete sense to me. I can see how opening a database read only will work and not invalidate the standby, but r/w? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Common Oracle RDBMS Misconceptions
Jeremiah, Here's some more misconceptions for ya!: * You *have* to take a COLD backup of the database after using resetlogs. (Not required - a Hot backup and archive logs is adequate. All hot backups / archive logs prior to that are invalid, though...) * You *have* to create an additional Rollback segment in the SYSTEM tablespace before creating *any* object in a tablespace other than SYSTEM (even additional Rbs in a non-SYSTEM tablespace). This used to be true in V6 and before, not anymore. * Backup the online redologs along with the datafiles/controlfiles in a Hot backup (Disaster strikes when the redologs are restored on the current online redo logs!!) * Continuously run ALTER TABLESPACE COALESCE * Allocate different values of INITIAL/NEXT extent sizes for large objects depending on the 'expected growth pattern' - this makes sure that the number of extents for large objects is kept down. (Sheesh!) * COMPRESS=Y during Export compresses the extents into 1 huge extent, and that's GOOD! * Make sure that all your Tablespaces have at least 15% (or whatever) free (i.e. stress the percentage rather than making sure that the largest free fragment is larger than the largest NEXT extent at the least) * You are absolutely protected from Redolog file corruption by hardware multiplexing it. (i.e. What if you fat-fingered an online redolog?) I might have added more on Tuning and Performance, but Gaja has already exploded all those myths! One thing I will note though - there's bound to be lots of fire and flak erupting in your presentation. There are *lots* of so-called experienced DataBase Baby Sitters out there fed exclusively on 'Oracle for Dummies' books who had adopted these myths as reality and will be prepared to defend their position. You will need documented evidence in the form of logs or timings to make your stand for exploding some of these myths. All the best! John Kanagaraj PS: On a related topic, I am unable to submit an abstract for OOW. Have been unable to do so for quite a while - spoke to Oracle, emailed 'em of no avail. Anyone else with the same story? (Or advice as to how this can be done?) -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Common Oracle RDBMS Misconceptions 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). -- Please see the official ORACLE-L FAQ: http
Re: Common Oracle RDBMS Misconceptions
well, the slides are at: http://www.ooug.org/slides.html i'm trying to find a copy of the paper... we gave it in Ohio and at ECO but I don't see the paper on their sites. Once I get a copy, it will get posted to the NYOUG site (www.nyoug.org) Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 12:26:20 -0800 Where can I get the exploding the myths paper? Thanks, Ken Janusz, CPIM Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
RE: Common Oracle RDBMS Misconceptions
From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 12:40:50 -0800 snip Of course I plan to explain them, but tell me what intrigues you. I'd love to hash the issues out here before I make a fool of myself in SF in December. Jeremiah, it's not possible for you to do that of course, I may have to argue the questionaire answers with you again :) _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
RE: Common Oracle RDBMS Misconceptions - standby db?
there is a paper out on Metalink called Graceful Switchover and Switchback by Lawrence To (who is my hero G) that describes this concept. Revised and valid for 7.3, 8.0 and 8.1 Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Common Oracle RDBMS Misconceptions - standby db? Date: Tue, 26 Jun 2001 15:21:00 -0800 With graceful standby failover (I demo'd it last year at OOW), you can switch back and forth, back and forth as many times as you want without recopying any database. Basically, when you fail over to a standby, you shut down the primary, apply all the archived redologs to the standby, then copy all the online logs and the controlfile from the primary to the standby. People who use incremental checkpoints (DB_BLOCK_MAX_DIRTY_TARGET) must do a 'create controlfile reuse database blah noresetlogs' at this point. Other people don't have to. Finally, you recover database to get the last one or two online logs and open the standby noresetogs. The standby just picks up the chain of SCNs where the primary left off. The old primary can be immediately pressed into service as a standby. Just generate a standby controlfile on the new primary, copy it into place on the old primary and start it up as a standby database. You can go back and forth in this way as many times as you want, and one just picks up the chain of SCNs where the last one left off. You never get a divergence of changes. I have talked to people who found this out, and looked like they were going to cry, thinking of the countless hours they had spent after every standby failover, recopying to the standby to get it rollong forward again. In 9i, they have an automated graceful failover mechanism for standby database. I haven't taken a look at it yet. Probably it is a massive java-based GUI that instantly consumes 512Mb or RAM. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Koivu, Lisa wrote: OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying' is a misconception. Yes, like many of the things you state below, the documentation does say that - once you open a standby db in r/w mode, it is no longer a valid standby after switching back to the primary. Can someone shed some light on why this is not true? It seemed to make complete sense to me. I can see how opening a database read only will work and not invalidate the standby, but r/w? -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
Re: Common Oracle RDBMS Misconceptions - standby db?
Stephane, Um, how about because hardware maintenance is needed on the primary server? I know I would much rather gracefully schedule a fallover and fallback to do something like that, given the luxury of actually being able to close the database for the few minutes it takes to complete the switch. In the case of a crash, of course all bets are off -- you can't really DO a graceful switchover (well,remote mirroring the online logs maybe) But we all always forget that there are on occasion SCHEDULED downtimes to build procedures for Rachel From: Stephane Faroult [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions - standby db? Date: Tue, 26 Jun 2001 16:27:34 -0800 But in practice, why would you switch to the standby database, unless the primary database is crashed or worse? You know how it is in a production environment, the database crashes. Even if failover is easy, you always have to instruct users to connect as scott/tiger@backup instead of scott/tiger@prod - or perhaps modify the tnsnames.ora to make it transparent, or perhaps play with IP addresses which may mean trouble for a while with in-memory routing tables etc. My point is that, even if the switch can be quasi-immediate, it is not so easy, so people will naturally try to make the main machine work first, there will be some delay assessing the damage, waiting until 2am to ring the VP in his bed to get the authorization to switch, etc. In real life, half-an-hour or an hour is easily passed before everybody is back at work on the backup machine, busy trying to catch up on the wasted time. Do not forget that since the transmission of redo logs is asynchronous (I have heard about improvements with 9i) some transactions - committed ones - will have been lost, so users will have to check and probably reenter the missing transactions. At this point the main machine will probably be totally out of order. Wait another 2 or 4 hours to have somebody to come if it's a hardware problem, I guess that when everything is over everybody will be on their knees and the last thing they will have in mind is make the old primary database the new standby - assuming of course that all files are intact. And even if the ex-standby machine is possibly less powerful, everybody will probably wait until a quieter time, say the W/E, to switch back to the initial configuration. At which time, in all likelihood, a full database copy will have become necessary; I think that the simple fact of having reentered a couple of transactions not transmitted yet to the standby database would require it. Do I err ? -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- Jeremiah Wilton wrote: With graceful standby failover (I demo'd it last year at OOW), you can switch back and forth, back and forth as many times as you want without recopying any database. Basically, when you fail over to a standby, you shut down the primary, apply all the archived redologs to the standby, then copy all the online logs and the controlfile from the primary to the standby. People who use incremental checkpoints (DB_BLOCK_MAX_DIRTY_TARGET) must do a 'create controlfile reuse database blah noresetlogs' at this point. Other people don't have to. Finally, you recover database to get the last one or two online logs and open the standby noresetogs. The standby just picks up the chain of SCNs where the primary left off. The old primary can be immediately pressed into service as a standby. Just generate a standby controlfile on the new primary, copy it into place on the old primary and start it up as a standby database. You can go back and forth in this way as many times as you want, and one just picks up the chain of SCNs where the last one left off. You never get a divergence of changes. I have talked to people who found this out, and looked like they were going to cry, thinking of the countless hours they had spent after every standby failover, recopying to the standby to get it rollong forward again. In 9i, they have an automated graceful failover mechanism for standby database. I haven't taken a look at it yet. Probably it is a massive java-based GUI that instantly consumes 512Mb or RAM. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Jun 2001, Koivu, Lisa wrote: OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations. However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover by recopying
RE: Common Oracle RDBMS Misconceptions
Good thread but I have not been following so I apologize if this was already said: PCTINCREASE = 1 - Ethan -Original Message- Sent: Tuesday, June 26, 2001 5:51 PM To: Multiple recipients of list ORACLE-L Jeremiah, Here's some more misconceptions for ya!: * You *have* to take a COLD backup of the database after using resetlogs. (Not required - a Hot backup and archive logs is adequate. All hot backups / archive logs prior to that are invalid, though...) * You *have* to create an additional Rollback segment in the SYSTEM tablespace before creating *any* object in a tablespace other than SYSTEM (even additional Rbs in a non-SYSTEM tablespace). This used to be true in V6 and before, not anymore. * Backup the online redologs along with the datafiles/controlfiles in a Hot backup (Disaster strikes when the redologs are restored on the current online redo logs!!) * Continuously run ALTER TABLESPACE COALESCE * Allocate different values of INITIAL/NEXT extent sizes for large objects depending on the 'expected growth pattern' - this makes sure that the number of extents for large objects is kept down. (Sheesh!) * COMPRESS=Y during Export compresses the extents into 1 huge extent, and that's GOOD! * Make sure that all your Tablespaces have at least 15% (or whatever) free (i.e. stress the percentage rather than making sure that the largest free fragment is larger than the largest NEXT extent at the least) * You are absolutely protected from Redolog file corruption by hardware multiplexing it. (i.e. What if you fat-fingered an online redolog?) I might have added more on Tuning and Performance, but Gaja has already exploded all those myths! One thing I will note though - there's bound to be lots of fire and flak erupting in your presentation. There are *lots* of so-called experienced DataBase Baby Sitters out there fed exclusively on 'Oracle for Dummies' books who had adopted these myths as reality and will be prepared to defend their position. You will need documented evidence in the form of logs or timings to make your stand for exploding some of these myths. All the best! John Kanagaraj PS: On a related topic, I am unable to submit an abstract for OOW. Have been unable to do so for quite a while - spoke to Oracle, emailed 'em of no avail. Anyone else with the same story? (Or advice as to how this can be done?) -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Common Oracle RDBMS Misconceptions 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
RE: Common Oracle RDBMS Misconceptions
Couldn't open it with PPT 97. - E -Original Message- Sent: Tuesday, June 26, 2001 6:10 PM To: Multiple recipients of list ORACLE-L well, the slides are at: http://www.ooug.org/slides.html i'm trying to find a copy of the paper... we gave it in Ohio and at ECO but I don't see the paper on their sites. Once I get a copy, it will get posted to the NYOUG site (www.nyoug.org) Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 12:26:20 -0800 Where can I get the exploding the myths paper? Thanks, Ken Janusz, CPIM Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: Common Oracle RDBMS Misconceptions
dunno... it's their site. oh JOE! I'll see if I can get it fixed there. If not, again, will see if I can get it onto the NYOUG site From: Post, Ethan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 18:16:04 -0800 Couldn't open it with PPT 97. - E -Original Message- Sent: Tuesday, June 26, 2001 6:10 PM To: Multiple recipients of list ORACLE-L well, the slides are at: http://www.ooug.org/slides.html i'm trying to find a copy of the paper... we gave it in Ohio and at ECO but I don't see the paper on their sites. Once I get a copy, it will get posted to the NYOUG site (www.nyoug.org) Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 12:26:20 -0800 Where can I get the exploding the myths paper? Thanks, Ken Janusz, CPIM Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions Date: Tue, 26 Jun 2001 09:05:27 -0800 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
Re: Common Oracle RDBMS Misconceptions
well it does not exist will you 'please' be more clear as to what you want to convey coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 8:16 PM I've never found hot backups shocking myself. Is it possible that rather than visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be checking). If it does exist I'm sure that switching logs means something entirely different there. Regards, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba 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).
