Re: all time worst question I have been ever asked as a DBA
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Fri, 29 Jul 2011 08:37:14 -0700 (PDT)
Message-ID: <1311953834.34180.YahooMailNeo_at_web65408.mail.ac4.yahoo.com>
Date: Fri, 29 Jul 2011 08:37:14 -0700 (PDT)
Message-ID: <1311953834.34180.YahooMailNeo_at_web65408.mail.ac4.yahoo.com>
You forgot to mention your daddy, the Colonel ... :D David Fitzjarrell From: Kellyn Pot'Vin <kellyn.potvin_at_ymail.com> To: pythianbrinsmead_at_gmail.com; Marco.Gralike_at_amis.nl Cc: "Stephens, Chris" <Chris.Stephens_at_adm.com>; " andrew.kerber_at_gmail.com" <andrew.kerber@gmail.com>; Oracle-L <oracle-l@freelists.org> Sent: Thursday, July 28, 2011 9:00 PM Subject: Re: all time worst question I have been ever asked as a DBA Mark, Are you telling us you had valuable information and held back?? (Said with a Southern Bell lilt) Well I jus never heard of such a thang! :) Kellyn(aka Skippy) Mark Brinsmead <pythianbrinsmead_at_gmail.com> wrote: >I sat through the OCP Oracle 11g course a few months back, and noted that >they do, indeed, still tell you to name your redo logs with ".LOG". > >I nearly interrupted the instructor to mention that this is an unsafe >practice (having seen a number or databases trashed by some do-gooder >"deleting some huge log files" in response to a filesystem storage page). >Then I remembered that the purpose of the course is to teach people how to >pass the exam, not how to be a DBA. > >If it comes up on the exam, you will undoubtedly be expected to say that >".LOG" is the best extension to use for online redolog members. > >*sigh* > > >On Wed, Jul 27, 2011 at 1:26 PM, Marco Gralike <Marco.Gralike_at_amis.nl>wrote: > >> BTW >> >> I also never use those file extensions anymore, but then again DBCA still >> has that practice and I would not be surprised if it turned up in OCP >> manuals etc. >> I once created an enhancement request saying that "this new APEX *core*directory, regarding naming is probably not a good idea to implement". >> They didn't get the point, or I didn't got my point across, that old unix >> admin methods / people (maybe still also on linux nowadays) have a practice >> to delete from time to time *core* files and *core* directories on their >> filesystems… >> >> >> >> From: "Stephens, Chris" <Chris.Stephens_at_adm.com> >> Date: Wed, 27 Jul 2011 17:02:52 +0200 >> To: Marco Gralike <marco.gralike_at_amis.nl>, "andrew.kerber_at_gmail.com" < >> andrew.kerber_at_gmail.com>, Oracle-L <oracle-l_at_freelists.org> >> >> Subject: RE: all time worst question I have been ever asked as a DBA >> >> Which is the #1 reason I no longer allow redo logs to end in ‘.log’! J**** >> >> ** ** >> >> I have that as a check implemented in a procedure that runs each night to >> ensure every database in our environment complies with a few standards that >> I don’t consider to be debatable.**** >> >> ** ** >> >> *From:* oracle-l-bounce_at_freelists.org [ >> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On >> Behalf Of *Marco Gralike >> *Sent:* Wednesday, July 27, 2011 9:57 AM >> *To:* andrew.kerber_at_gmail.com; ORACLE-L >> *Subject:* RE: all time worst question I have been ever asked as a DBA**** >> >> ** ** >> >> Be happy that he asked. Sometimes they just delete log files because they >> need the space.**** >> ------------------------------ >> >> *Van:*oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] namens >> Andrew Kerber [andrew.kerber_at_gmail.com] >> *Verzonden:* dinsdag 26 juli 2011 21:38 >> *Aan:* ORACLE-L >> *Onderwerp:* all time worst question I have been ever asked as a DBA**** >> >> So, I am getting this error on one of our virtual Linux servers: >> >> ORA-00210: cannot open the specified control file >> ORA-00202: control file: '/u01/app/oracle/datafiles/devdb/control01.ctl' >> ORA-27086: unable to lock file - already in use >> >> Its probably due to a stale NFS lock. The question from my sys admin:**** >> >> -rw-r----- 1 oracle oinstall 10076160 Jul 22 13:33 control01.ctl**** >> >> can that file just be removed**** >> >> >> >> >> Ok, I am a little frustrated with him... >> >> -- >> Andrew W. Kerber >> >> 'If at first you dont succeed, dont take up skydiving.'**** >> >> CONFIDENTIALITY NOTICE: >> This message is intended for the use of the individual or entity to which >> it is addressed and may contain information that is privileged, confidential >> and exempt from disclosure under applicable law. If the reader of this >> message is not the intended recipient or the employee or agent responsible >> for delivering this message to the intended recipient, you are hereby >> notified that any dissemination, distribution or copying of this >> communication is strictly prohibited. If you have received this >> communication in error, please notify us immediately by email reply. >> >> >> > > >-- >Cheers, >-- Mark Brinsmead > Senior DBA, > The Pythian Group > http://www.pythian.com/blogs †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 29 2011 - 10:37:14 CDT