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

  • From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
  • To: "Marco.Gralike@xxxxxxx" <Marco.Gralike@xxxxxxx>, "andrew.kerber@xxxxxxxxx" <andrew.kerber@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 27 Jul 2011 10:02:52 -0500

Which is the #1 reason I no longer allow redo logs to end in ‘.log’!  ☺

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] 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<mailto: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.

Other related posts:

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