RE: database decommission checklist

  • From: "Matthew Zito" <mzito@xxxxxxxxxxx>
  • To: <Mark.Bobak@xxxxxxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>, <dcowles@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 26 Jun 2009 18:30:19 -0400

 

I think the issue is more that today's storage arrays abstract things
enough that even dd'ing zeroes doesn't necessarily mean you're
destroying any data.  For example, on NetApp, there is no such thing as
overwriting a block of data - when you write a block, it gets written to
free space somewhere in the volume, and the old used block is marked as
free and can be reused.  

 

If you really need to destroy data, you'll need to get the SAN folks
involved.

 

Matt

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Friday, June 26, 2009 5:40 PM
To: Brandon.Allen@xxxxxxxxxxx; dcowles@xxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: database decommission checklist

 

And, might I add, when it comes to wiping the disk, one good wipe is all
it takes, contrary to what government standards say.....

 

I challenge anyone to recover data from a disk after a single pass of:

dd if=/dev/zero of=/dev/sd0

 

You do that, the data is gone, and it's not coming back....

 

-Mark

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: Friday, June 26, 2009 4:42 PM
To: dcowles@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: database decommission checklist

 

I would just add wiping the disk, or taking a sledgehammer to it if it's
really sensitive data and you'll be decommissioning the hardware too,
and then other little things like updating documentation and maybe any
clients, e.g. tnsnames.ora files, that need to be updated.

 

Regards,

Brandon

 

 

 

________________________________

Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.

Other related posts: