Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fast Incremental Backup

Dude!Jun 18 2010 — edited Sep 7 2010
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2010
Added on Jun 18 2010
10 comments
3,047 views