You have not configured Oracle Managed Files (OMF) in your database. You do not want to
scan the entire datafile every time an incremental backup is performed. You decide to
enable the block change tracking feature. Which statement should you use to enable the
block change tracking feature?
A.
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
B.
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
C.
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
D.
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
C is correct:
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm
f you cannot shut down the database, then you must disable change tracking and re-enable it at the new location, as in the following example:
ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘new_location’;
If you choose this method, you will lose the contents of the change tracking file. Until the next time you complete a level 0 incremental backup, RMAN will have to scan the entire file.
@Jake, two words of advice
1) Read the article again, this is a specific case, it says, and I quote …
“If you need to move the change tracking file, the ALTER DATABASE RENAME FILE command updates the control file to refer to the new location. The process outlined in this section describes how to change the location of the change tracking file while preserving its contents……”
2) Do not quote (or for that matter even read) a non viable version of the documentation. Please note that the version of oracle exam-ed in IZO-053 is 11.2.0.1 as stated here …
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-053&p_org_id=&lang=
Therefore please refer to the 11.2.0.1 documentation found in …
http://oracle.su/docs/11g/nav/portal_booklist.htm
otherwise you are confusing yourself and others.
Good luck.