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

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 27 Jul 2011 15:40:28 -0700 (PDT)
Message-ID: <1311806428.55186.YahooMailRC_at_web113206.mail.gq1.yahoo.com>


This get's into some of the things I talk about in my blog of late, like 
communication. The real problem here and the solution is not an argument or 
letting things fail, but it's rather stated SLA's and RPO's defined and agreed 
to by all. With these in place we change the conversation like this:


Them: "I've been reading and exports take  up less space than backups, so we'll 
do those instead.  Oh, and shut off  this archivelog stuff, that will save disk 
space."
Me: "You can't do point-in-time recovery if I shut off archive logging and only 
perform exports. Using exports will violate our standards, the SLA's established 
for this application and will also violate the standard RPO. If you want that 
done, you need to take this through the exception and change control process"
Them: "All that work just to get around standards?"
Me: "Yup. Want me to give you the change request form?"
Them: "Um... no, thanks."
This will stop a lot of these stupid conversations in their tracks. When people 
realize that they will have to go through a formal process to change a 
standardized practice and justify it, they usually will back down unless it has 
real meaning and importance. SLA's, standards and the like are leverage to be 
used like a big bad hammer. 


My 2 cents....

RF



 Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com


Note: THIS EMAIL IS NOT AN OFFICIAL ORACLE SUPPORT COMMUNICATION. It is just the 
opinion of one Oracle employee. I can be wrong, have been wrong in the past and 
will be wrong in the future. If your problem is a critical production problem, 
you should always contact Oracle support for assistance. Statements in this 
email in no way represent Oracle Corporation or any subsidiaries and reflect 
only the opinion of the author of this email.




________________________________
From: David Fitzjarrell <oratune_at_yahoo.com>
To: "Marco.Gralike_at_amis.nl" <Marco.Gralike_at_amis.nl>; "Stephens, Chris" 
<Chris.Stephens_at_adm.com>; "andrew.kerber_at_gmail.com" <andrew.kerber@gmail.com>; 
Oracle-L <oracle-l_at_freelists.org>
Sent: Wed, July 27, 2011 2:29:56 PM
Subject: Re: all time worst question I have been ever asked as a DBA


Back to the original topic -- it wasn't a question so much as a statement:
 
Them: "I've been reading and exports take up less space than backups, so we'll 
do those instead.  Oh, and shut off this archivelog stuff, that will save disk 
space."
Me: "You can't do point-in-time recovery if I shut off archive logging and only 
perform exports."
Them: "Why not?  You do the export at the end of the day and we're good."
Me: "That won't capture batch-processed data."
Them: "We can rerun the batch.  Do as I ask."
 
I did.  Several weeks later a hardware failure lost the database and they 
could only restore from the most recent export and, as expected, the batch jobs 
needed to be rerun and all user transactions  had to be re-entered.  The RCA 
revealed the above conversation.  You can guess who remained and who didn't.
 
David Fitzjarrell
 

From: Marco Gralike <Marco.Gralike_at_amis.nl>
To: "Stephens, Chris" <Chris.Stephens_at_adm.com>; "andrew.kerber_at_gmail.com" 
<andrew.kerber_at_gmail.com>; Oracle-L <oracle-l_at_freelists.org>
Sent: Wednesday, July 27, 2011 10:26 AM
Subject: Re: all time worst question I have been ever asked as a DBA


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] 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.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 27 2011 - 17:40:28 CDT

Original text of this message