In this article we will enable block change tracking

Now, what is block change tracking?

Block change tracking is a mechanism of Oracle database to record changed blocks in a file. It helps us in taking incremental backups. While tracking incremental backups, instead of scanning all datafiles for changed blocks RMAN can simply read change tracking file and can take backup accordingly.

Step 1: Connect to the target database and enable block change tracking using ENABLE BLOCK CHANGE TRACKING command.

Step 2: Now lets us see the effect here.

Take incremental level 0 backup :

Step 3: I am changing blocks of data files by inserting some records in a table

Step 4: Take an incremental level 1 backup.

We can see in above output CDB level backup completed in 00:00:01 time and pdb backup skipped as we have not changed any data block on pdb level.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.