oracle 频繁宕机 ORA-00600: internal error code, arguments: [krccacp_badfile]
来源:互联网 发布:映射网络驱动器 本机 编辑:程序博客网 时间:2024/06/03 17:47
oracle出现频繁宕机,日志报如下错误:
Fri Apr 18 18:16:04 2014
Errors in file /u01/app/oracle/admin/zgnc/bdump/zgnc_ctwr_12511.trc:
ORA-00600: internal error code, arguments: [krccacp_badfile], [106067200], [0], [72850812], [0], [], [], []
Fri Apr 18 18:16:05 2014
Errors in file /u01/app/oracle/admin/zgnc/bdump/zgnc_ctwr_12511.trc:
ORA-00600: internal error code, arguments: [krccacp_badfile], [106067200], [0], [72850812], [0], [], [], []
Fri Apr 18 18:16:05 2014
CTWR: terminating instance due to error 487
Instance terminated by CTWR, pid = 12511
CTWR,其全称为Change Tracking Writer,用于记录变化的块并将变化写入相应的日志文件中。
Block chage tracking是Oracle10g的一个新特性,Block change tracking进程记录自从上一次备份以来数据块的变化,并把这些信息记录在跟踪文件中。RMAN使用这个文件判断增量备份中需要备份的变更数据。这极大的促进了备份性能,RMAN可以不再扫描整个文件以查找变更数据
Block chage tracking是Oracle10g的一个新特性,Block change tracking进程记录自从上一次备份以来数据块的变化,并把这些信息记录在跟踪文件中。RMAN使用这个文件判断增量备份中需要备份的变更数据。这极大的促进了备份性能,RMAN可以不再扫描整个文件以查找变更数据。
为此Oracle引入了一个新的后台进程,CTWR,其全称为Change Tracking Writer,用于记录变化的块并将变化写入相应的日志文件中。
启用跟踪可以使用如下命令取消掉CTWR检查设置:
alter database enable block change tracking usingfile '/data5/flash_recovery_area/EYGLE/eygle_block_track.log';
判断当前设置可以查询:
select filename,status,bytes from v$block_change_tracking;
关闭跟踪:
alter database disable block change tracking;
以下步骤供参考:
SYS AS SYSDBA on 29-MAR-05 >alter database enable block change tracking using 2 file '/data5/flash_recovery_area/EYGLE/eygle_block_track.log';Database altered.SYS AS SYSDBA on 29-MAR-05 >select filename,status,bytes from v$block_change_tracking;FILENAME--------------------------------------------------------------------------------STATUS BYTES---------- ----------/data5/flash_recovery_area/EYGLE/eygle_block_track.logENABLED 11599872SYS AS SYSDBA on 29-MAR-05 >alter database disable block change tracking;Database altered.SYS AS SYSDBA on 29-MAR-05 >select filename,status,bytes from v$block_change_tracking;FILENAME--------------------------------------------------------------------------------STATUS BYTES---------- ----------DISABLED
- oracle 频繁宕机 ORA-00600: internal error code, arguments: [krccacp_badfile]
- oracle 断电启动失败:ORA-00600: internal error code, arguments
- Oracle案例之-ORA-00600: internal error code, arguments: [4193]
- ORA-00600 internal error code, arguments
- ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [ksuinfos_modact1], [], [], [], [], [], [], []
- ora-00600 internal error code arguments: [kcratrl_lastbwr],[],[],[],[],[],[],[]
- ORA-00600: internal error code, arguments: [19004]
- ORA-00600 internal error code,arguments
- ORA-00600: internal error code, arguments: [1265]
- ORA-00600: internal error code, arguments: [17182]
- ORA-00600: internal error code, arguments: [keltnf
- ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
- ORA-00600 internal error code,arguments: 问题
- ORA-00600: internal error code, arguments: [kdsgrp1]
- ORA-00600 internal error code,arguments
- ORA-00600: internal error code, arguments: [ktrgcm_3]
- centerimg.css
- hadoop基础----hadoop实战(三)-----hadoop运行MapReduce---对单词进行统计--经典的自带例子wordcount
- spring
- ORU-10027:buffer overflow,limit of 10000 bytes问题的解决
- java中date和calendar的区别
- oracle 频繁宕机 ORA-00600: internal error code, arguments: [krccacp_badfile]
- 人生中开通的第一篇博客
- myeclipse 注册码生成 DEMO
- ios 汇总 - 数据 容器
- leftMenu.css
- 使用EasyUi实现三级联动
- 字符函数库cctype
- 10个核心的Linux面试问题与答案
- 在子View中设置父View是否进行手势拦截