RE: delete one tablespace from all backups
- From: "Dimensional DBA" <dimensional.dba@xxxxxxxxxxx>
- To: <jeremy.schneider@xxxxxxxxxxxxxx>, "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2014 08:50:34 -0700
I think I would ask "What is the purpose of this request?"
I have had many odd requests from legal and compliance organizations and in
the end they normally are looking for a way to solve a perceived problem but
are trying to choose a way that does not match legal or compliance law or
rules.
IMHO you should step back and have the question answered first, then you
could discuss the how the perceived problem could be solved.
Matthew Parker
Chief Technologist
425-891-7934 (cell)
Dimensional.dba@xxxxxxxxxxx
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew
Parker's profile on LinkedIn
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jeremy Schneider
Sent: Thursday, September 25, 2014 6:12 AM
To: Oracle-L
Subject: delete one tablespace from all backups
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?
-Jeremy
--
<http://about.me/jeremy_schneider> http://about.me/jeremy_schneider
Other related posts:
