检查改变跟踪是否被开启
检查块改变跟踪是否被开启,如果已经开启,则查看块改变跟踪文件。
sys@TESTDB12>alter database enable block change tracking;
Database altered.
sys@TESTDB12>col status for a8 sys@TESTDB12>col filename for a60 sys@TESTDB12>select status, filename from v$block_change_tracking;
STATUS FILENAME -------- ------------------------------------------------------------ ENABLED /disk01/omf_file/TESTDB12/changetracking/o1_mf_8y86x4y3_.chg |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1087818/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1087818/