RE: delete one tablespace from all backups

  • From: "Dimensional DBA" <dimensional.dba@xxxxxxxxxxx>
  • To: <gus.spier@xxxxxxxxx>, <niall.litchfield@xxxxxxxxx>
  • Date: Fri, 26 Sep 2014 07:58:57 -0700

There are other ways to achieve this which is why I asked earlier what the 
specifics of the request are.

I have had cases in the past where a a developer turned on debugging and 
started dumping classified data into logs that were mixed with regular backups 
and under the specified rule for the data the backups were then contained with 
the other classified data and there was a process for retrieval that included 
scrubbing of the backups if those backups were ever to be recovered.


Matthew Parker

Chief Technologist

425-891-7934 (cell)


 <> View Matthew Parker's 
profile on LinkedIn


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of August Spier
Sent: Friday, September 26, 2014 3:31 AM
To: niall.litchfield@xxxxxxxxx
Cc: Jeremy Schneider; Oracle-L
Subject: Re: delete one tablespace from all backups


This sounds like a situation where a user inadvertently inserted classified 
data in an unclassified database.  I suppose one could recreate the table(s) 
with CTAS with a very clever where clause and follow up with a CREATE 
CONTROLFILE after dropping the offending redo/undo. 


It would be an interesting exercise if there was enough time to attempt it. 

Gus Spier



540 454 3074


On Sep 26, 2014, at 4:17, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:

Well you can certainly skip tablespaces , and your backup command doesn't have 
to be "backup database" so it's certainly possible not to back it up.  

 I'd like to know what the rationale was though.  


On Thu, Sep 25, 2014 at 2:12 PM, Jeremy Schneider 
<jeremy.schneider@xxxxxxxxxxxxxx> wrote:

someone asked me recently if it's possible to completely remove the data in one 
tablespace from all historical backups of a database.  my knee-jerk response 
was simply "no" - thinking that even if you had the tablespace backups in their 
own backupsets, you couldn't remove data from undo and redo streams.


nonetheless I'm curious if anyone else on the list has ever thought about this 
and what you've come up with.  if there was a business requirement to do this, 
then how close could you come?





Niall Litchfield
Oracle DBA 

Other related posts: