RE: Security Issue

  • From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
  • To: "Richard J. Goulet" <richard.goulet@xxxxxxxxxxxxx>, "Freeman, Donald" <dofreeman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 11 Jun 2007 10:43:58 -0400

We are not using RMAN encryption.  We have multiple backups and want to
use the same encryption for all of them for simplicities sake.  I am
trying to answer a "what-if?" question.  These backups, like probably
everyone elses, are going to go off-site to a secure, hardened facility.
I'm pretty sure there is limited interest in our data but management
wants to know how hard it would be to recover data from a datafile.  If
they had the whole backup could just to restore it to a server

This interest extends to our scratch tapes.  Once they expire they old
tapes are returned here and thrown into a bin for reuse.  If I
understand correctly the Veritas software marks them as expired and
can't be used to pull them off the tapes but I'm sure some smart person
somewhere could.   

-----Original Message-----
From: Richard J. Goulet [mailto:richard.goulet@xxxxxxxxxxxxx] 
Sent: Monday, June 11, 2007 10:37 AM
To: dofreeman@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Security Issue


        Have you tried setting encryption on for an rman backup?
According to the FM it's suppose to encrypt the output for removable

Please note that on May 25, 2007 my email address  changed to

Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 /
Fax: 508.229.2019 /  Email: richard.goulet@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Litchfield
Sent: Friday, June 08, 2007 3:48 PM
To: dofreeman@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Security Issue

Hi Don,

I'm in the process of researching and developing what will be an open 
source, post-database intrusion forensics tool called F.E.D.S. (the
Examiner's Database Scalpel) that is capable of extracting information
row data, deleted or otherwise, from datafiles and the redo logs. Some
this research I've written up in the following papers:

If you're concerned about people gaining unauthorized access to data on 
backup files you should look to encrypt them (there are a number of 
commercial and open source solutions available) and store them in a 
physically secure location.

David Litchfield

----- Original Message ----- 
From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, June 08, 2007 6:25 PM
Subject: Security Issue

Is it possible to recover information from an undo datafile?   I have
been searching for information on securing oracle datafiles and see that
there are .dbf file viewers that claim to be able to view/edit/export
the contents as text.   I am thinking that its not likely to be possible
to reconstruct anything usable from an undo datafile.

I know that Oracle 10G has the ability to encrypt the contents of
datafiles and store the key in a wallet.  We are planning an upgrade in
a year but right now I'm having to answer questions about vulnerabilty
of backups stored on removable media.

Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
(717) 703-5782


The information contained in this email and any subsequent
correspondence is private, is solely for the intended recipient(s) and
may contain confidential or privileged information. For those other than
the intended recipient(s), any disclosure, copying, distribution, or any
other action taken, or omitted to be taken, in reliance on such
information is prohibited and may be unlawful. If you are not the
intended recipient and have received this message in error, please
inform the sender and delete this mail and any attachments.

The views expressed in this email do not necessarily reflect NGS policy.
NGS accepts no liability or responsibility for any onward transmission
or use of emails and attachments having left the NGS domain.

NGS and NGSSoftware are trading names of Next Generation Security
Software Ltd. Registered office address: 52 Throwley Way, Sutton, SM1
4BF with Company Number 04225835 and VAT Number 783096402

This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you are not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all
copies of this message.


Other related posts: