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

From: Mark Brinsmead <pythianbrinsmead_at_gmail.com>
Date: Thu, 28 Jul 2011 23:44:42 -0400
Message-ID: <CAMeSnB4kX86gc9ecXqCWFsTPUQfqZPO4qjArXMKP1MyLfiMNEA_at_mail.gmail.com>

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

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

Received on Thu Jul 28 2011 - 22:44:42 CDT