Fast Incremental Backup
Dude!Jun 18 2010 — edited Sep 7 2010Hi,
I'm looking for some answers regarding Block Change Tracking or Fast Incremental Backup, but was not successful searching in Google and Oracle documentation so far. Maybe I will have more luck here....
Following:
A) From what I understand, after enabling block change tracking, a level 0 backup is required in order for the block change tracking file to have a reference. Level 0 backups can be done as backupset, image copy. Which one does it apply to? Which incremental level and backup type does it apply to?
B) The block change tracking is a live file that records as changes are made. If I disable block change tracking, the block change tracking file will be deleted, provided it is in an oracle managed file location. When I enable block change tracking a new file will be created. What happens if I disable and re-enable block change tracking after a level 0 and level 1 backup? Will fast incremental backup be ignored until the next level 0 backup? Does a level 0 backup clear the block change tracking file?
C) What happens if the block change tracking file gets corrupt? What if lost. I was reading if it is lost than it will automatically be recreated at next restart of the database.
D) I guess in a RAC, the block change tracking file will have to be in a cluster shared location?
E) To enable block change tracking the database has to be in mount mode. I assume it is updating the controlfile. What happens when restoring a database using the backup controlfile? I guess I will have to delete the existing block change tracking file in order to enable block change tracking using the same file?
Thanks.