Re: all time worst question I have been ever asked as a DBA

Rather, I reconsidered the information and the audience, and decided that the value was not really what I had initially thought it to be. ;-)

On Fri, Jul 29, 2011 at 12:00 AM, Kellyn Pot'Vin <kellyn.potvin_at_ymail.com>wrote:

> 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
>

-- 
Cheers,
-- Mark Brinsmead
   Senior DBA,
   The Pythian Group
   http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l