block change tracking檔案可以放在flash_recovery_area裡!

warehouse發表於2008-09-21
If the change tracking file was stored in the database area, then it is deleted when you disable change tracking.[@more@]

SQL> alter database enable block change tracking using file
2 'C:block_changerman_change_track.txt' ;

資料庫已更改。
SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;

資料庫已更改。
--block change tracking檔案可以放在flash_recovery_area,如果放在
flash_recovery_area裡面,則tracking檔案會被自動刪除,否則不會
If the change tracking file was stored in the database area, then it is deleted when you disable change tracking.
SQL> alter database enable block change tracking ;

資料庫已更改。
SQL> select *from V$BLOCK_CHANGE_TRACKING;

STATUS FILENAME BYTES
---------- ------------------------------------------------------- ----------
ENABLED C:TESTTESTCHANGETRACKINGO1_MF_4GXVJTK3_.CHG 11599872

SQL> show parameter db_recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string C:test
db_recovery_file_dest_size big integer 3G
SQL>

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/19602/viewspace-1010882/,如需轉載,請註明出處,否則將追究法律責任。

相關文章