onlinedbalearning.blogspot.com
SET NEWNAME FOR BLOCK CHANGE TRACKING FILE TO '/oracle/oradata/ TESTDB/block_change.bct';
SET NEWNAME FOR BLOCK CHANGE TRACKING FILE TO '/oracle/oradata/ TEST/block_change.bct';
Bug 11744544 - Set newname for database does not apply to block change tracking file (Doc ID 11744544.8). Yes… it was a hard day for me.
If you use Block Change Tracking on your production database and try to
Apply the patch 11744544 and issue set newname for block change tracking file to new; – This doesnt work as the error says that it is unable to ...
If you want to redirect the block change tracking file, then add the following line to the RMAN script: SET NEWNAME FOR BLOCK CHANGE TRACKING FILE ...
1) create a dummy (empty) block change tracking file in the same location as it wanted it in live
We can enable or disable change tracking when the database is either open or mounted. To alter the change tracking setting, we must use SQL* ...
... SPARC (64-bit) - SET NEWNAME FOR DATABASE DOES NOT APPLY TO BLOCK CHANGE TRACKING FILE Patch Reviews - DB (MOSC)
Using SET NEWNAME to Name File System Data Files and Temp Files