Re: RMAN Restore with Incremental
Date: Thu, 3 Apr 2008 09:32:33 -0700 (PDT)
Can I confirm I understand correctly your remark "one block change in a datafile will cause the entire datafile to be backed up" ? If I have a (full) 4Gb datafile, say, and change a single block (eg. a single row in a table), then the whole 4Gb datafile will be backed up in a subsequent incremental level 1 backup?
This doesn't really seem to tie in to what I've seen in the past - my understanding was only that changed blocks would go into the incremental - regardless of the use of BCTF. Could you point me to the right place in the manual - please!
Thank you very much!
- Original Message ---- From: Robert Freeman <robertgfreeman_at_yahoo.com> To: Charlotte Hammond <charlottejanehammond_at_yahoo.com> Sent: Thursday, April 3, 2008 2:44:38 PM Subject: Re: RMAN Restore with Incremental
The smaller backup set size could reflect a change in the underlying data, a mass delete of rows for example. Without a block change tracking file, one block change in a datafile will cause the entire datafile to be backed up in an incremental. Hense, the BCTF is pretty darned important! :-)
Robert G. Freeman
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com
http://www.freelists.org/webpage/oracle-l Received on Thu Apr 03 2008 - 11:32:33 CDT