Re: delete one tablespace from all backups

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 26 Sep 2014 09:17:24 +0100
Message-ID: <CABe10sbf1wfpafDgtdZwUsi+=t8XyXm=KBTHA-MBMcpV=v3GvQ_at_mail.gmail.com>



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_at_ardentperf.com> 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
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 26 2014 - 10:17:24 CEST

Original text of this message