RE: disable recyclebin?
Date: Thu, 21 Apr 2011 14:28:50 -0500
Message-ID: <F077F09A0E11504D9E720358BEE994D10785E9D7_at_APSW0553EVS.ms.ds.uhc.com>
I was born paranoid. Takes me more than one or six checks to make sure I am where I am supposed to be before I do a simple data delete.
-----Original Message-----
From: Mark W. Farnham [mailto:mwf_at_rsiz.com]
Sent: Thursday, April 21, 2011 2:04 PM
To: Lange, Kevin G; 'oracle Freelists'
Subject: RE: disable recyclebin?
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 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-lReceived on Thu Apr 21 2011 - 14:28:50 CDT