oracle 10g 开启BLOCK CHANGE TRACKING

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17997/viewspace-614495/