RE: disable recyclebin?
Date: Thu, 21 Apr 2011 15:03:34 -0400
Message-ID: <0a0901cc0056$d1baced0$75306c70$_at_rsiz.com>
No one said not to set things up so you can always recover from "oopses." The question is whether recycle bin is a good way to do that in a particular situation. IF you decide recycle bin is net productive in a given setting, please don't let it be the only way you have to get things back. That is foolishly trusting the errant dropper to let you know before the space is re-used. If the call is going to come at 2 AM, there is a good chance you'll be reloading from an intentionally delayed replicant, a split mirror flashback, a partial restore on another machine, or some other method I've missed anyway.
It was humorous to have someone suggest that I'm not paranoid enough though...
mwf
"You're not paranoid to be risk averse if the world really is out to get
you." (the 2nd DBA mantra)
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Lange, Kevin G
Sent: Wednesday, April 20, 2011 4:07 PM
To: oracle Freelists
Subject: RE: disable recyclebin?
I had this conversation before with a group of people.
One guy in the conversation said "Why do you need all that protection ?
Don't you trust yourself ?"
And another answered "Of course I trust myself. It's the others I do not
trust."
My response was ..... "You trust yourself ? Fool !"
Like the Physician who treats himself, or the Lawyer who defends himself, or the Accountant who does his taxes, the DBA who trusts himself not to make a mistake is the one who will one day destroy the database with no chance of recovery.
Mark Twice ... Cut Once.
Not only good in Carpentry, but in prety much every other profession.
Anything you can put into a job to stop you from doing something wrong on a 2 am call from the vice president of the company is a good thing.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling
Sent: Wednesday, April 20, 2011 2:58 PM
To: oracle Freelists
Cc: TESTAJ3_at_nationwide.com; dbvision_at_iinet.net.au; Guillermo Alan Bort
Subject: Re: disable recyclebin?
There is no such thing as a free lunch. As far as features are concerned
there are always costs or side-effects. At the very least having those
recyclebin objects around consumes space and time during backups. If I can
avoid those costs by being careful when performing destructive actions and
checking twice then I shall. Such actions should be scripted and how much
effort does it take to put in a statement which checks for the database name
and aborts if it is production. That should be a standard piece of code in
every script and thus require a deliberate action to remove if you really
mean production.
Of course, as Mark pointed out, production can have many meanings and
damaging a dev/test database by mistake can be just as costly as doing it in
a "production" database.
On 2011-04-20, at 12:39 PM, Guillermo Alan Bort wrote:
> I had one experience where recycle bin saved me a lot of work, so I
leave it on.
>
> I was working on a data refresh from a Prod DB to a Dev DB. I finished
the consistent export from Prod and promptly dropped all the tables in the
schema only to realize that I had dropped the tables in the PROD database.
>
> A restore would have taken several hours and customer was already
pissed about delays in this implementation. After informing them of my
mistake I restored all the tables from the recycle bin with a total downtime
of 10 minutes (as opposed to several hours!). So... I leave Recycle Bin on.
>
> And I don't think that if you have a way to minimize impact people
having to learn that there are consequences is a good argument against using
that feature... it's like saying you don't buy stuff in the supermarket
because people need to learn the real value of things or that you don't use
computers because people need to learn to calculate stuff by themselves.
Recycle Bin is there to make your life easier in the event of a MISTAKE, are
you above making mistakes?
>
> I seem to be ranting a lot today... good thing i don't work
tomorrow...
-- http://www.freelists.org/webpage/oracle-l This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 21 2011 - 14:03:34 CDT