Tag Archives: ASM

删除归档出现ORA-15028错误

在10.2.0.4 RAC环境中使用RMAN删除归档报错ORA-15028。 错误信息如下: RMAN> DELETE archivelog ALL completed BEFORE ‘sysdate-3’; Do you really want TO DELETE the above objects (enter YES OR NO)? YES RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure OF DELETE command … Continue reading

Posted in BUG | Tagged , , , , , , | Leave a comment

KFED-320错误

利用kfed的repair命令修复asm头块,碰到这个错误。 错误信息如下: $kfed repair /dev/rhdisk3 KFED-00320: Invalid block num1 = [3], num2 = [1], error = [type_kfbh]$kfed repair /dev/rhdisk3 KFED-00320: Invalid block num1 = [3], num2 = [1], error = [type_kfbh] 导致这个错误的原因是由于当前磁盘组的AUSIZE不是默认值1M,而是4M。 对于磁盘组的头块损坏,不知道具体AUSIZE的值的情况,有两个方法,一是通过ASM的告警日志文件,找磁盘组创建时的参数信息: SUCCESS: CREATE diskgroup oradata external redundancy disk … Continue reading

Posted in ORACLE | Tagged , , , , | Leave a comment

ORA-7445(kfcbCloseCIC10)错误

10.2.0.3 RAC的ASM实例,出现ORA-7445错误导致实例崩溃。 详细错误信息为: Tue Nov 9 10:47:59 2010 NOTE: reconfiguration OF GROUP 4/0x654fe2a9 (DATA), FULL=1 NOTE: disk validation pending FOR GROUP 4/0x654fe2a9 (DATA) ERROR: GROUP 4/0x654fe2a9 (DATA): could NOT validate disk 25 SUCCESS: validated disks FOR 4/0x654fe2a9 (DATA) NOTE: PST … Continue reading

Posted in BUG | Tagged , , , , , , , | Leave a comment

ORA-600(1403)和ORA-7445($cold_kslgetsl)错误

10.2.0.2 RAC的ASM实例,出现这两个错误并导致实例的崩溃。 错误信息为: Thu Apr 12 18:55:42 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 lan901 192.168.0.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 lan900 198.5.1.0 configured FROM OCR … Continue reading

Posted in BUG | Tagged , , , , , , , , , , , | Leave a comment

ORA-600(kfioUnidentify01)错误

Oracle 10.2.0.4 RAC环境的ASM出现这个错误。 错误信息为: Mon Sep 19 18:06:01 2011 Shutting down instance: further logons disabled Mon Sep 19 18:06:01 2011 Shutting down instance (immediate) License high water mark = 10 Mon Sep 19 18:06:01 2011 ERROR: diskgroup DATA was NOT … Continue reading

Posted in BUG | Tagged , , , , , | Leave a comment

访问ASM的ONNN进程占用大量CPU

客户的11.2 RAC环境中突然一个O002进程占用了100%的CPU,且一直不释放。 导致这个问题的原因应该是通过ASMCMD工具从ASM中拷贝了一个归档日志到本地磁盘,随后就发现一个ora_ [root@node-2 ~]# top top – 21:14:25 up 257 days, 4:33, 2 users, LOAD average: 1.69, 1.70, 1.56 Tasks: 994 total, 2 running, 991 sleeping, 0 stopped, 1 zombie Cpu(s): 2.2%us, 0.1%sy, 0.0%ni, 97.5%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st … Continue reading

Posted in BUG | Tagged , , , | Leave a comment

11.2单实例ASM启动报错ORA-15186

客户安装了一个Oracle 11.2.0.2 for Linux X64环境,使用了ASM方式,重启后发现数据库没有启动。 检查操作系统进程,发现ASM已经启动,CLUSTER环境也启动完成,但是数据库并未启动,尝试手工启动数据库,报错找不到对应的SPFILE。 登录ASM实例,查询发现找不到任何的ASM磁盘组信息: [grid@rptdb trace]$ sqlplus / AS sysasm SQL*Plus: Release 11.2.0.2.0 Production ON Tue DEC 20 18:41:41 2011 Copyright (c) 1982, 2010, Oracle. ALL rights reserved.   Connected TO: Oracle DATABASE 11g Enterprise Edition Release … Continue reading

Posted in ORACLE | Tagged , , , , , , , , , | Leave a comment

创建ASM启动SPFILE报错ORA-17502

客户的数据库的ASM启动存在问题,通过手工创建PFILE,解决了ASM启动的问题,但是尝试利用PFILE生成SPFILE时报错。 详细错误信息为: [grid@rptdb ~]$ sqlplus / AS sysasm SQL*Plus: Release 11.2.0.2.0 Production ON Tue DEC 20 19:05:33 2011 Copyright (c) 1982, 2010, Oracle. ALL rights reserved. Connected. SQL> shutdown abort ASM instance shutdown SQL> startup pfile=/home/grid/init+ASM.ora ASM instance started Total … Continue reading

Posted in ORACLE | Tagged , , , | Leave a comment

DBCA建库导致已有数据库出现ORA-27140错误

通过DBCA在服务器上创建一个额外的实例,结束后以外发现,原有的数据库实例出现了异常。 简单描述一下系统环境,Oracle 11.2.0.2 for Linux x86-64,随后又安装了GRID,创建了ASM磁盘组。原有的数据库有部分表空间和REDO存放在ASM磁盘组中。 为了测试,通过DBCA创建了额外的实例,事实上,通过DBCA又先后创建了两个数据库实例,第二个数据库实例创建后一切正常,将第二个实例关闭,通过DBCA创建第三个数据库实例时,导致服务器上的第一个实例出现了异常。 检查实例1上的告警日志,可以发现大量下面的错误信息: 2011-08-30 10:20:54.502000 +08:00 Process W000 died, see its trace file 2011-08-30 10:20:58.518000 +08:00 Process W000 died, see its trace file 2011-08-30 10:21:02.524000 +08:00 Process W000 died, see its trace file 2011-08-30 10:21:06.527000 … Continue reading

Posted in BUG | Tagged , , , , , , , , | Leave a comment