As with 11g Oracle comes with a new feature for Oracle Data Guard: Active Data guard. And with Active Data Guard enabled we can use Block Change Tracking feature for the physical standby database.

Now, what is Block Change Tracking?

Block Change Tracking: RMAN change tracking feature for incremental backups improves incremental backup performance by recording changed blocks in each datafile in a change tracking file. If change tracking is enabled, RMAN uses the change tracking file to identify changed blocks for incremental backup, thus avoiding the need to scan every block in the data file.

With Active Data Guard we can enable block change tracking at Standby side, so when we back up a physical standby database, RMAN will use the block change tracking file to quickly identify the blocks that have changed since last incremental backup.

Follow below steps to enable block change tracking.

Step 1: Checking Database role as we are applying this on a physical standby database.

Step 2: Check if  block change tracking is enabled or not

Step 3: Check if OMF is enabled or not.

In this case, OMF is not enabled. If OMF is enabled we just need to write ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; and then BCT file will be created to the destination we have specified in the db_create_file_dest parameter.

But here we need to enable it by specifying using clause.

We can see in alert log file CTWR background process associated with BCT is started.

Note: We can not enable Block Change Tracking for standby database which does not have Active Data guard option enabled, because Block Change Tracking need database opened in read-write mode or read-only mode and it can not work if your database is just mounted.

Stay tuned for More articles on Oracle DataGuard

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:

Skant Gupta’s LinkedIn:

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.