delete one tablespace from all backups
From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Thu, 25 Sep 2014 09:12:05 -0400
Message-ID: <CA+fnDAbv+KUKUvFA9jd95OhYyfveKFz88jtPX2ktGL0HCOP4Yg_at_mail.gmail.com>
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.
Date: Thu, 25 Sep 2014 09:12:05 -0400
Message-ID: <CA+fnDAbv+KUKUvFA9jd95OhYyfveKFz88jtPX2ktGL0HCOP4Yg_at_mail.gmail.com>
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://www.freelists.org/webpage/oracle-l
Received on Thu Sep 25 2014 - 15:12:05 CEST