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

  • From: David Fitzjarrell <oratune@xxxxxxxxx>
  • To: "kellyn.potvin@xxxxxxxxx" <kellyn.potvin@xxxxxxxxx>, "pythianbrinsmead@xxxxxxxxx" <pythianbrinsmead@xxxxxxxxx>, "Marco.Gralike@xxxxxxx" <Marco.Gralike@xxxxxxx>
  • Date: Fri, 29 Jul 2011 08:37:14 -0700 (PDT)

You forgot to mention your daddy, the Colonel ...   :D


David Fitzjarrell


From: Kellyn Pot'Vin <kellyn.potvin@xxxxxxxxx>
To: pythianbrinsmead@xxxxxxxxx; Marco.Gralike@xxxxxxx
Cc: "Stephens, Chris" <Chris.Stephens@xxxxxxx>; " andrew.kerber@xxxxxxxxx" 
<andrew.kerber@xxxxxxxxx>; Oracle-L <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxx>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@xxxxxxx>
>> Date: Wed, 27 Jul 2011 17:02:52 +0200
>> To: Marco Gralike <marco.gralike@xxxxxxx>, "andrew.kerber@xxxxxxxxx" <
>> andrew.kerber@xxxxxxxxx>, Oracle-L <oracle-l@xxxxxxxxxxxxx>
>>
>> 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@xxxxxxxxxxxxx [
>> mailto:oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>] *On
>> Behalf Of *Marco Gralike
>> *Sent:* Wednesday, July 27, 2011 9:57 AM
>> *To:* andrew.kerber@xxxxxxxxx; 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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] namens
>> Andrew Kerber [andrew.kerber@xxxxxxxxx]
>> *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É^

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2011