Databases Reference
In-Depth Information
If you need to move the change tracking file, use the following procedure:
1.
Determine the current location of the change tracking file with the following command:
RMAN> select filename from v$block_change_tracking;
FILENAME
--------------------------------------------------------------------------------
/u01/app/oracle/backup/change_track.f
RMAN>
2.
Shut down the database.
3.
Move the change tracking file to the new location using the following command:
$ mv /u01/app/oracle/backup/change_track.f /u01/app/oracle/rman/change_track.f
4.
Start up the database in mount mode:
SQL> startup mount
Use the
alter database rename file
command to rename the change tracking file in the
Oracle database:
5.
SQL> alter database rename file
'/u01/app/oracle/backup/change_track.f' to
'/u01/app/oracle/rman/change_track.f';
6.
Open the database:
SQL> alter database open;
If you can't shut down the database for some reason, you have to first disable change tracking and then reenable
it after you rename the change tracking file, as shown here:
SQL> alter database disable block change tracking;
SQL> alter database enable block change tracking using file
'/u01/app/oracle/rman/change_track.f';
■
You can turn on block change tracking in a physical standby database, thus making the incremental backups
of the standby database run faster.
Note
As a result of directing output to the new change tracking file without shutting down the database, you'll lose the
contents of the original change tracking file. RMAN will scan the entire file as a result until the next time you perform
a level 0 incremental backup.
