Incremental Backup and Change Block Tracking Questions

  • From: "Sam Bootsma" <sbootsma@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 22 Feb 2008 10:52:45 -0500

Hello all,


Oracle, Enterprise Edition, on AIX 5.3.


I am preparing to change our RMAN backups to use Incremental Backups and
Change Block Tracking.  I am also considering to use compression.  But
first I have a few questions that I hope you can assist with.  


1. Have you found Incremental backups and Change Block Tracking to be
reliable; i.e, can you reliably backup and then restore and recover?


2. What about Oracle compression during an RMAN backup?  Is that


3. How much of a performance hit using the Change Block Tracking
feature?  What about Oracle compression?


4. Do you know if any of these features are additional cost?  Do you
know if there is a view in Oracle that outlines what features come with
EE and what features are additional cost?


5. We also have the option to do compression at the tape drive level.
Is anybody aware of any reason that Oracle compression (during backup)
would be better or worse than letting the tape drive do it?


6. I have read that restores of a cumulative backup a generally faster
than restores of a differential backup.  What makes cumulative faster?
Is it simply that RMAN will just one incremental file to restore and
recover from (plus archive logs)?  If there are six differential backups
to recover from, RMAN should be able to restore and recover the six
files without DBA intervention.  I don't see a significant time
difference.  Perhaps a couple minutes extra because it has six more
files to deal with?


Thanks for your input!


Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma@xxxxxxxxxxxxxx <mailto:sbootsma@xxxxxxxxxxxxxx> 


Other related posts: