Oracle 10g rac开启block change tracking

uywmrjkadi

在一节点中开启block change tracking时报如下错误
引用
Tue Nov 23 13:59:47 2010
Starting background process CTWR
CTWR started with pid=435, OS id=3153976
Tue Nov 23 14:00:24 2010
Errors in file /oracle/admin/orcl/bdump/orcl1_ctwr_3153976.trc:
ORA-04031: unable to allocate 1819360 bytes of shared memory ("shared pool","unknown object","sga heap(4,0)","CTWR dba buffer")
Tue Nov 23 14:00:24 2010
Block change tracking service stopping.
Tue Nov 23 14:00:24 2010
Stopping background process CTWR
Error 19760 occurred while enabling or disabling change tracking
Tue Nov 23 14:00:26 2010
Errors in file /oracle/admin/orcl/bdump/orcl1_ckpt_1208398.trc:
ORA-19760: error starting change tracking
Tue Nov 23 14:06:24 2010
alter database enable block change tracking using file '+ASM_DATA/orcl/changetracking/orcl.bcf'
Tue Nov 23 14:06:25 2010
Block change tracking file is current.
Tue Nov 23 14:06:25 2010
Starting background process CTWR
CTWR started with pid=321, OS id=2691178
Tue Nov 23 14:06:26 2010
Errors in file /oracle/admin/orcl/bdump/orcl1_ctwr_2691178.trc:
ORA-04031: unable to allocate 1819360 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","CTWR dba buffer")
Block change tracking service stopping.
Tue Nov 23 14:06:26 2010
Stopping background process CTWR
Error 19760 occurred while enabling or disabling change tracking
Tue Nov 23 14:06:28 2010
Errors in file /oracle/admin/orcl/bdump/orcl1_ckpt_1208398.trc:
ORA-19760: error starting change tracking
Tue Nov 23 14:08:01 2010
ORA-1013 signalled during: alter database enable block change tracking using file '+ASM_DATA/orcl/changetracking/orcl.bcf'...
WARNING: Cannot delete file +ASM_DATA/orcl/changetracking/orcl.bcf
Tue Nov 23 14:08:01 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_1351810.trc:
ORA-01265: Unable to delete CHANGE TRACKING +ASM_DATA/orcl/changetracking/orcl.bcf
ORA-15028: ASM file '+ASM_DATA/orcl/changetracking/orcl.bcf' not dropped; currently being accessed
ORA-01013: user requested cancel of current operation


由以上日志明显可以看出，shared pool内存不够，导致CTWR dba buffer不能分配，只需再次分配内存即可
引用
SQL> alter system set db_cache_size=7500m scope=both sid='orcl1';

System altered.

SQL> alter system set shared_pool_size=2500m scope=both sid='orcl1';

System altered.

SQL> alter database enable block change tracking using file '+ASM_DATA/orcl/changetracking/orcl.bcf2';

Database altered.


在rac环境中开启block change tracking需要注意的是：
1、增量变化跟踪文件需要放置在共享存储中
2、增量变化跟踪文件可以存放在asm中