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)
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 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
Gus.Spier@xxxxxxxxx
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?
-Jeremy
--
<http://about.me/jeremy_schneider> http://about.me/jeremy_schneider
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
