Incremental Backup and Change Block Tracking Questions
Date: Fri, 22 Feb 2008 10:52:45 -0500
Oracle 10.2.0.3, 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.
- Have you found Incremental backups and Change Block Tracking to be reliable; i.e, can you reliably backup and then restore and recover?
- What about Oracle compression during an RMAN backup? Is that reliable?
- How much of a performance hit using the Change Block Tracking feature? What about Oracle compression?
- 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?
- 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?
- 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!
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
E-mail: sbootsma_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>