在一节点中开启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中
分享到:
相关推荐
介绍在虚拟机上构建Oracle10g RAC集群的操作过程,其中介绍了裸机上安装虚拟机软件ESXi,SuSELinux上安装Oracle10g RAC集群。 安装RAC集群,首先要创建虚拟机共享磁盘,然后分区,挂载裸设备和进行ASM分区,然后安装...
Oracle10g RAC集群技术
ORACLE 11g RAC数据库归档的启用、修改、配置的方法!
oracle10g rac asm for linux oracle10g rac asm for linux
oracle 10g rac 描述,系统讲解oracle 10g rac的原理和基础。
手把手教你用VMware在Linux下安装Oracle 10g RAC
教程名称:Oracle 10g RAC安装过程视频讲解课程目录:【】Oracle10g RAC_1【】Oracle10g RAC_2【】Oracle10g RAC_3【】Oracle10g RAC_4【】Oracle10g RAC_5 资源太大,传百度网盘了,链接在附件中,有需要的同学自取...
oracle 10g RAC
最详细的AIX Oracle 10g RAC实施文档,一册在手学习安装无忧!
oracle 10g rac on rhel5.5 相关包
oracle 10g RAC实施手册,讲解实施过程中的问题和步骤
oracle 10g rac 教程
关于oracle 10g rac的搭建,相信过程请参考文档
Oracle10g RAC ASM 环境日常管理命令
ORACLE 10G RAC参考手册 主要是部署和发布方面
Oracle 10g RAC安装全面解读
基于Vmware 15 + CentOS 7.6 + Oracle 11g RAC+DG安装配置
ORACLE10g RAC FOR SUSE LINUX安装
Oracle 10g RAC on Linux 静默安装过程
超完美Oracle 10g RAC安装全过程 95页中文文档,一册在手,安装无忧!