浏览 2220 次
|
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
|
|
|---|---|
| 作者 | 正文 |
|
发表时间：2010-11-25
在一节点中开启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中 声明：ITeye文章版权属于作者，受法律保护。没有作者书面许可不得转载。
推荐链接
|
| 返回顶楼 | |
