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