oracle 10g 開啟BLOCK CHANGE TRACKING

byfree發表於2009-09-12
Oracle 10gBloC
1.檢查BLOCK CHANGE TRACKING狀態
SQL> select filename,status,bytes from v$block_change_tracking;
FILENAME                       STATUS          BYTES
----------------------------   ---------- ----------
                               DISABLED
 
2.資料庫到mount狀態
SQL> startup mount force
ORACLE 例程已經啟動。
Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             230689668 bytes
Database Buffers          373293056 bytes
Redo Buffers                7135232 bytes
資料庫裝載完畢。
SQL> select status from v$instance;
STATUS
------------
MOUNTED
3.開啟BLOCK CHANGE TRACKING

SQL> alter database enable block change tracking;
alter database enable block change tracking
*
第 1 行出現錯誤:
ORA-19773: 必須指定更改跟蹤檔名
SQL> alter database enable block change tracking using file 'D:\oracle\product\bct.trc';
資料庫已更改。
SQL> alter database open;
資料庫已更改。
SQL> col filename for a50
SQL> select filename,status,bytes from v$block_change_tracking;
FILENAME                                           STATUS          BYTES
-------------------------------------------------- ---------- ----------
D:\ORACLE\PRODUCT\BCT.TRC                          ENABLED      11599872
 
4.檢查增量備份相關資訊SQL
SQL> SELECT file#,avg(datafile_blocks),avg(blocks_read),avg(blocks_read/datafile_blocks)*100 AS PCT_READ_FOR_BACKUP,avg(blocks) FROM v$backup_datafile WHERE used_change_tracking='YES' AND incremental_level>0 GROUP BY file#;

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

相關文章