ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(kfdds:badaddr)错误

ORA-600(kfdds:badaddr)错误

原创 Linux操作系统 作者:yangtingkun 时间:2011-06-04 23:39:52 0 删除 编辑

客户数据库出现IO问题的同时出现了这个ORA-600错误。

 

 

详细错误信息为:

WARNING: Read Failed. group:5 disk:0 AU:105 offset:0 size:131072
WARNING: Read Failed. group:5 disk:0 AU:106 offset:0 size:49152
WARNING: failed to read mirror side 1 of virtual extent 4 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 106 reason error; if possible,will try another mirror side
WARNING: failed to read mirror side 1 of virtual extent 3 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 105 reason error; if possible,will try another mirror side
WARNING: failed to read mirror side 1 of virtual extent 2 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 104 reason error; if possible,will try another mirror side
WARNING: failed to read mirror side 1 of virtual extent 1 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 103 reason error; if possible,will try another mirror side
WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 102 reason error; if possible,will try another mirror side
WARNING: Read Failed. group:5 disk:0 AU:102 offset:49152 size:81920
WARNING: Read Failed. group:5 disk:0 AU:103 offset:0 size:131072
WARNING: Read Failed. group:5 disk:0 AU:104 offset:0 size:131072
WARNING: Read Failed. group:5 disk:0 AU:105 offset:0 size:131072
WARNING: Read Failed. group:5 disk:0 AU:106 offset:0 size:49152
WARNING: failed to read mirror side 1 of virtual extent 4 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 106 reason error; if possible,will try another mirror side
WARNING: failed to read mirror side 1 of virtual extent 3 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 105 reason error; if possible,will try another mirror side
WARNING: failed to read mirror side 1 of virtual extent 2 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 104 reason error; if possible,will try another mirror side
WARNING: failed to read mirror side 1 of virtual extent 1 logical extent 0 of file 256 in group [5.641283253] from disk REDO1 allocation unit 103 reason error; if possible,will try another mirror side
SUCCESS: diskgroup DG_REDO was dismounted
SUCCESS: diskgroup DG_REDO was dismounted
Errors in file /oracle/diag/rdbms/spsp/SPSP1/trace/SPSP1_ora_14285.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 1 logical extent 0 of file 256 in group 5 on disk 0 allocation unit 103
WARNING: group 5 dismounted: failed to read virtual extent 0 of file 256
Errors in file /oracle/diag/rdbms/spsp/SPSP1/trace/SPSP1_ora_14285.trc (incident=11073):
ORA-00600: internal error code, arguments: [kfdds::badaddr], [0x2ACA30123DB0], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/spsp/SPSP1/incident/incdir_11073/SPSP1_ora_14285_i11073.trc
Dumping diagnostic data in directory=[cdmp_20110514060335], requested by (instance=1, sid=14285), summary=[incident=11073].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 14285
Sat May 14 06:03:37 2011
PMON (ospid: 14209): terminating the instance due to error 397
System state dump requested by (instance=1, sid=14209 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /oracle/diag/rdbms/spsp/SPSP1/trace/SPSP1_diag_14219.trc
Dumping diagnostic data in directory=[cdmp_20110514060337], requested by (instance=1, sid=14209 (PMON)), summary=[abnormal instance termination].
Instance terminated by PMON, pid = 14209

对应的详细TRACE信息为:

*** 2011-05-14 06:03:34.223
*** SESSION ID:(35.1) 2011-05-14 06:03:34.223
*** CLIENT ID:() 2011-05-14 06:03:34.223
*** SERVICE NAME:() 2011-05-14 06:03:34.223
*** MODULE NAME:(oraagent.bin@Oracle-01 (TNS V1-V3)) 2011-05-14 06:03:34.223
*** ACTION NAME:() 2011-05-14 06:03:34.223

Dump continued from file: /oracle/diag/rdbms/spsp/SPSP1/trace/SPSP1_ora_14285.trc
ORA-00600: internal error code, arguments: [kfdds::badaddr], [0x2ACA30123DB0], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 11073 (ORA 600 [kfdds::badaddr]) ========

*** 2011-05-14 06:03:34.229
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=7zw2thz9ggwb6) -----
ALTER DATABASE MOUNT /* db agent *//* {2:51839:2} */

----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+36        call     kgdsdst()            000000000 ? 000000000 ?
                                                   7FFF7CB5E6D8 ? 000000001 ?
                                                   000000001 ? 000000002 ?
ksedst1()+98         call     skdstdst()           000000000 ? 000000000 ?
                                                   7FFF7CB5E6D8 ? 000000001 ?
                                                   000000000 ? 000000002 ?
ksedst()+34          call     ksedst1()            000000000 ? 000000001 ?
                                                   7FFF7CB5E6D8 ? 000000001 ?
                                                   000000000 ? 000000002 ?
dbkedDefDump()+2741  call     ksedst()             000000000 ? 000000001 ?
                                                   7FFF7CB5E6D8 ? 000000001 ?
                                                   000000000 ? 000000002 ?
ksedmp()+36          call     dbkedDefDump()       000000003 ? 000000002 ?
                                                   7FFF7CB5E6D8 ? 000000001 ?
                                                   000000000 ? 000000002 ?
ksfdmp()+64          call     ksedmp()             000000003 ? 000000002 ?
                                                   7FFF7CB5E6D8 ? 000000001 ?
                                                   000000000 ? 000000002 ?
dbgexPhaseII()+1764  call     ksfdmp()             000000003 ? 000000002 ?
                                                   7FFF7CB5E6D8 ? 000000001 ?
                                                   000000000 ? 000000002 ?
dbgexProcessError()  call     dbgexPhaseII()       2ACA2FBB9710 ? 2ACA2FBBA410 ?
+2651                                              7FFF7CB6AA50 ? 000000001 ?
                                                   000000000 ? 000000002 ?
dbgeExecuteForError  call     dbgexProcessError()  2ACA2FBB9710 ? 2ACA2FBBA410 ?
()+83                                              000000001 ? 000000000 ?
                                                   100000000 ? 000000002 ?
dbgePostErrorKGE()+  call     dbgeExecuteForError  2ACA2FBB9710 ? 2ACA2FBBA410 ?
2131                          ()                   000000001 ? 000000001 ?
                                                   000000000 ? 000000002 ?
dbkePostKGE_kgsf()+  call     dbgePostErrorKGE()   000000000 ? 2ACA2FBC29A0 ?
63                                                 000000258 ? 2ACA2FBBA410 ?
                                                   100000000 ? 000000002 ?
kgeadse()+390        call     dbkePostKGE_kgsf()   00B7C8EA0 ? 2ACA2FBC29A0 ?
                                                   000000258 ? 2ACA2FBBA410 ?
                                                   100000000 ? 000000002 ?
kgerinv_internal()+  call     kgeadse()            00B7C8EA0 ? 2ACA2FBC29A0 ?
45                                                 000000258 ? 100000000 ?
                                                   000000000 ? 000000002 ?
kgerinv()+33         call     kgerinv_internal()   00B7C8EA0 ? 2ACA2FBC29A0 ?

错误居然发生在MOUNT过程中,仔细查询了metalink,没有找到参数为kfdds::badaddrORA-600错误,不过在另外一个和ASMIO错误有关的文档中,找到了kfdds信息。

检查对应时刻的ASM日志,同样发现大量的IO相关的错误:

Sat May 14 06:03:34 2011
WARNING: Read Failed. group:2 disk:1 AU:59 offset:98304 size:16384
WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 255 in group [2.639186098] from disk VD2 allocation unit 59 reason error; if possible,will try another mirror side
WARNING: Read Failed. group:2 disk:0 AU:60 offset:98304 size:16384
WARNING: failed to read mirror side 2 of virtual extent 0 logical extent 1 of file 255 in group [2.639186098] from disk VD1 allocation unit 60 reason error; if possible,will try another mirror side
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_ora_13801.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 0 logical extent 0 of file 255 in group 2 on disk 0 allocation unit 60
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_ora_13801.trc:
ORA-15081: failed to submit an I/O operation to a disk
WARNING: Read Failed. group:3 disk:1 AU:0 offset:0 size:4096
WARNING: Read Failed. group:3 disk:0 AU:0 offset:0 size:4096
NOTE: SMON starting instance recovery for group DG_DATA domain 3 (mounted)
NOTE: SMON skipping disk 0 - no header
NOTE: SMON skipping disk 1 - no header
WARNING: Read Failed. group:3 disk:1 AU:2 offset:0 size:4096
WARNING: cache failed reading from group=3(DG_DATA) fn=3 blk=0 count=1 from disk= 1(DATA2) kfkist=0x20 status=0x02 file=kfc.c line=11317
ERROR: cache failed to read group=3(DG_DATA) fn=3 blk=0 from disk(s): 1(DATA2)
ORA-15080: synchronous I/O operation to a disk failed
System State dumped to trace file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_smon_13769.trc
NOTE: client exited [13791]
NOTE: failed to create amdu dump with error -1
NOTE: cache initiating offline of disk 1 group DG_DATA
NOTE: process 13769 initiating offline of disk 1.3916022862 (DATA2) with mask 0x7e in group 3
WARNING: Disk DATA2 in mode 0x7f is now being offlined
WARNING: Disk DATA2 in mode 0x7f is now being taken offline
NOTE: initiating PST update: grp = 3, dsk = 1/0xe969c44e, mode = 0x15
NOTE: Deferred communication with ASM instance
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_ora_13801.trc:
ORA-15130: diskgroup "DG_CRS" is being dismounted
NOTE: deferred map free for map id 2
GMON updating disk modes for group 3 at 21 for pid 17, osid 13769
ERROR: too many offline disks in PST (grp 3)
Sat May 14 06:03:34 2011
NOTE: cache dismounting (not clean) group 3/0x262934B3 (DG_DATA)
WARNING: Disk DATA2 in mode 0x7f offline aborted
WARNING: Offline for disk DATA2 in mode 0x7f failed.
NOTE: halting all I/Os to diskgroup 3 (DG_DATA)
NOTE: aborting instance recovery of domain 3 due to diskgroup dismount
NOTE: SMON skipping lock domain validation because diskgroup being dismounted
Abort recovery for domain 3
WARNING: Read Failed. group:4 disk:0 AU:0 offset:0 size:4096
NOTE: SMON starting instance recovery for group DG_FLSH domain 4 (mounted)
NOTE: SMON skipping disk 0 - no header
WARNING: Read Failed. group:4 disk:0 AU:4 offset:0 size:4096
WARNING: cache failed reading from group=4(DG_FLSH) fn=3 blk=0 count=1 from disk= 0(FLSH1) kfkist=0x20 status=0x02 file=kfc.c line=11317
ERROR: cache failed to read group=4(DG_FLSH) fn=3 blk=0 from disk(s): 0(FLSH1)
ORA-15080: synchronous I/O operation to a disk failed
System State dumped to trace file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_smon_13769.trc
NOTE: failed to create amdu dump with error -1
NOTE: cache initiating offline of disk 0 group DG_FLSH
NOTE: process 13769 initiating offline of disk 0.3916022863 (FLSH1) with mask 0x7e in group 4
WARNING: Disk FLSH1 in mode 0x7f is now being offlined
WARNING: Disk FLSH1 in mode 0x7f is now being taken offline
NOTE: initiating PST update: grp = 4, dsk = 0/0xe969c44f, mode = 0x15
GMON updating disk modes for group 4 at 22 for pid 17, osid 13769
ERROR: too many offline disks in PST (grp 4)
Sat May 14 06:03:34 2011
NOTE: cache dismounting (not clean) group 4/0x263934B4 (DG_FLSH)
WARNING: Disk FLSH1 in mode 0x7f offline aborted
WARNING: Offline for disk FLSH1 in mode 0x7f failed.
NOTE: halting all I/Os to diskgroup 4 (DG_FLSH)
NOTE: aborting instance recovery of domain 4 due to diskgroup dismount
NOTE: SMON skipping lock domain validation because diskgroup being dismounted
Abort recovery for domain 4
Sat May 14 06:03:35 2011
NOTE: [crsd.bin@Oracle-01 (TNS V1-V3) 14388] opening OCR file
NOTE: LGWR doing non-clean dismount of group 1 (DG_ARCH)
NOTE: LGWR sync ABA=5.19 last written ABA 5.19
NOTE: LGWR doing non-clean dismount of group 2 (DG_CRS)
NOTE: LGWR sync ABA=5.0 last written ABA 5.0
NOTE: LGWR doing non-clean dismount of group 3 (DG_DATA)
NOTE: LGWR sync ABA=5.170 last written ABA 5.170
NOTE: LGWR doing non-clean dismount of group 4 (DG_FLSH)
NOTE: LGWR sync ABA=4.10750 last written ABA 4.10750
WARNING: Read Failed. group:1 disk:0 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:1 disk:0 AU:1 offset:0 size:4096
ERROR: no PST quorum in group: required 1, found 0
ERROR: Could not heartbeat PST for grp 1. Force dismounting the disk group.
Sat May 14 06:03:36 2011
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_b004_14438.trc:
ORA-15130: diskgroup "" is being dismounted
Sat May 14 06:03:36 2011
NOTE: Deferred communication with ASM instance
WARNING: Read Failed. group:2 disk:2 AU:1 offset:4096 size:4096
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_pmon_13735.trc:
ORA-15130: diskgroup "" is being dismounted
WARNING: Read Failed. group:2 disk:2 AU:1 offset:0 size:4096
WARNING: Read Failed. group:2 disk:1 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:2 disk:1 AU:1 offset:0 size:4096
WARNING: Read Failed. group:2 disk:0 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:2 disk:0 AU:1 offset:0 size:4096
ERROR: no PST quorum in group: required 2, found 0
ERROR: Could not heartbeat PST for grp 2. Force dismounting the disk group.
NOTE: Deferred communication with ASM instance
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_pmon_13735.trc:
ORA-15130: diskgroup "" is being dismounted
Sat May 14 06:03:36 2011
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_b004_14440.trc:
ORA-15130: diskgroup "" is being dismounted
WARNING: Read Failed. group:3 disk:1 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:3 disk:1 AU:1 offset:0 size:4096
NOTE: Deferred communication with ASM instance
WARNING: Read Failed. group:3 disk:0 AU:1 offset:4096 size:4096
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_pmon_13735.trc:
.
.
.
Sat May 14 06:03:36 2011
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_b004_14445.trc:
ORA-15130: diskgroup "" is being dismounted
List of instances:
1 2
Dirty detach reconfiguration started (new ddet inc 2, cluster inc 4)
Global Resource Directory partially frozen for dirty detach
* dirty detach - domain 1 invalid = TRUE
15 GCS resources traversed, 0 cancelled
Dirty Detach Reconfiguration complete
freeing rdom 1
WARNING: dirty detached from domain 1
NOTE: cache dismounted group 1/0x261934B1 (DG_ARCH)
NOTE: cache deleting context for group DG_ARCH 1/0x261934b1
SQL> alter diskgroup DG_ARCH dismount force /* ASM SERVER */
GMON dismounting group 1 at 23 for pid 37, osid 14350
NOTE: Disk in mode 0x8 marked for de-assignment
SUCCESS: diskgroup DG_ARCH was dismounted
SUCCESS: alter diskgroup DG_ARCH dismount force /* ASM SERVER */
ERROR: PST-initiated MANDATORY DISMOUNT of group DG_ARCH
kjbdomdet send to inst 2
detach from dom 2, sending detach message to inst 2
List of instances:
1 2
Dirty detach reconfiguration started (new ddet inc 2, cluster inc 4)
Global Resource Directory partially frozen for dirty detach
* dirty detach - domain 2 invalid = TRUE
16 GCS resources traversed, 0 cancelled
Dirty Detach Reconfiguration complete
freeing rdom 2
WARNING: dirty detached from domain 2
NOTE: cache dismounted group 2/0x261934B2 (DG_CRS)
NOTE: cache deleting context for group DG_CRS 2/0x261934b2
.
.
.
SSat May 14 06:03:34 2011
WARNING: Read Failed. group:2 disk:1 AU:59 offset:98304 size:16384
WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 255 in group [2.639186098] from disk VD2 allocation unit 59 reason error; if possible,will try another mirror side
WARNING: Read Failed. group:2 disk:0 AU:60 offset:98304 size:16384
WARNING: failed to read mirror side 2 of virtual extent 0 logical extent 1 of file 255 in group [2.639186098] from disk VD1 allocation unit 60 reason error; if possible,will try another mirror side
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_ora_13801.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 0 logical extent 0 of file 255 in group 2 on disk 0 allocation unit 60
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_ora_13801.trc:
ORA-15081: failed to submit an I/O operation to a disk
WARNING: Read Failed. group:3 disk:1 AU:0 offset:0 size:4096
WARNING: Read Failed. group:3 disk:0 AU:0 offset:0 size:4096
NOTE: SMON starting instance recovery for group DG_DATA domain 3 (mounted)
NOTE: SMON skipping disk 0 - no header
NOTE: SMON skipping disk 1 - no header
WARNING: Read Failed. group:3 disk:1 AU:2 offset:0 size:4096
WARNING: cache failed reading from group=3(DG_DATA) fn=3 blk=0 count=1 from disk= 1(DATA2) kfkist=0x20 status=0x02 file=kfc.c line=11317
ERROR: cache failed to read group=3(DG_DATA) fn=3 blk=0 from disk(s): 1(DATA2)
ORA-15080: synchronous I/O operation to a disk failed
System State dumped to trace file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_smon_13769.trc
NOTE: client exited [13791]
NOTE: failed to create amdu dump with error -1
NOTE: cache initiating offline of disk 1 group DG_DATA
NOTE: process 13769 initiating offline of disk 1.3916022862 (DATA2) with mask 0x7e in group 3
WARNING: Disk DATA2 in mode 0x7f is now being offlined
WARNING: Disk DATA2 in mode 0x7f is now being taken offline
NOTE: initiating PST update: grp = 3, dsk = 1/0xe969c44e, mode = 0x15
NOTE: Deferred communication with ASM instance
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_ora_13801.trc:
ORA-15130: diskgroup "DG_CRS" is being dismounted
NOTE: deferred map free for map id 2
GMON updating disk modes for group 3 at 21 for pid 17, osid 13769
ERROR: too many offline disks in PST (grp 3)
Sat May 14 06:03:34 2011
NOTE: cache dismounting (not clean) group 3/0x262934B3 (DG_DATA)
WARNING: Disk DATA2 in mode 0x7f offline aborted
WARNING: Offline for disk DATA2 in mode 0x7f failed.
NOTE: halting all I/Os to diskgroup 3 (DG_DATA)
NOTE: aborting instance recovery of domain 3 due to diskgroup dismount
NOTE: SMON skipping lock domain validation because diskgroup being dismounted
Abort recovery for domain 3
WARNING: Read Failed. group:4 disk:0 AU:0 offset:0 size:4096
NOTE: SMON starting instance recovery for group DG_FLSH domain 4 (mounted)
NOTE: SMON skipping disk 0 - no header
WARNING: Read Failed. group:4 disk:0 AU:4 offset:0 size:4096
WARNING: cache failed reading from group=4(DG_FLSH) fn=3 blk=0 count=1 from disk= 0(FLSH1) kfkist=0x20 status=0x02 file=kfc.c line=11317
ERROR: cache failed to read group=4(DG_FLSH) fn=3 blk=0 from disk(s): 0(FLSH1)
ORA-15080: synchronous I/O operation to a disk failed
System State dumped to trace file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_smon_13769.trc
.
.
.
Sat May 14 06:03:35 2011
NOTE: [crsd.bin@Oracle-01 (TNS V1-V3) 14388] opening OCR file
NOTE: LGWR doing non-clean dismount of group 1 (DG_ARCH)
NOTE: LGWR sync ABA=5.19 last written ABA 5.19
NOTE: LGWR doing non-clean dismount of group 2 (DG_CRS)
NOTE: LGWR sync ABA=5.0 last written ABA 5.0
NOTE: LGWR doing non-clean dismount of group 3 (DG_DATA)
NOTE: LGWR sync ABA=5.170 last written ABA 5.170
NOTE: LGWR doing non-clean dismount of group 4 (DG_FLSH)
NOTE: LGWR sync ABA=4.10750 last written ABA 4.10750
WARNING: Read Failed. group:1 disk:0 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:1 disk:0 AU:1 offset:0 size:4096
ERROR: no PST quorum in group: required 1, found 0
ERROR: Could not heartbeat PST for grp 1. Force dismounting the disk group.
Sat May 14 06:03:36 2011
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_b004_14438.trc:
ORA-15130: diskgroup "" is being dismounted
Sat May 14 06:03:36 2011
NOTE: Deferred communication with ASM instance
WARNING: Read Failed. group:2 disk:2 AU:1 offset:4096 size:4096
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_pmon_13735.trc:
ORA-15130: diskgroup "" is being dismounted
WARNING: Read Failed. group:2 disk:2 AU:1 offset:0 size:4096
WARNING: Read Failed. group:2 disk:1 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:2 disk:1 AU:1 offset:0 size:4096
WARNING: Read Failed. group:2 disk:0 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:2 disk:0 AU:1 offset:0 size:4096
ERROR: no PST quorum in group: required 2, found 0
ERROR: Could not heartbeat PST for grp 2. Force dismounting the disk group.
NOTE: Deferred communication with ASM instance
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_pmon_13735.trc:
ORA-15130: diskgroup "" is being dismounted
Sat May 14 06:03:36 2011
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_b004_14440.trc:
ORA-15130: diskgroup "" is being dismounted
WARNING: Read Failed. group:3 disk:1 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:3 disk:1 AU:1 offset:0 size:4096
NOTE: Deferred communication with ASM instance
WARNING: Read Failed. group:3 disk:0 AU:1 offset:4096 size:4096
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_pmon_13735.trc:
ORA-15130: diskgroup "" is being dismounted
WARNING: Read Failed. group:3 disk:0 AU:1 offset:0 size:4096
ERROR: no PST quorum in group: required 1, found 0
ERROR: Could not heartbeat PST for grp 3. Force dismounting the disk group.
NOTE: Deferred communication with ASM instance
Errors in file /oracle/gridbase/diag/asm/+asm/+ASM1/trace/+ASM1_pmon_13735.trc:
.
.
.
SQL> alter diskgroup DG_FLSH dismount force /* ASM SERVER */
GMON dismounting group 4 at 26 for pid 39, osid 14397
NOTE: Disk in mode 0x8 marked for de-assignment
SUCCESS: diskgroup DG_FLSH was dismounted
SUCCESS: alter diskgroup DG_FLSH dismount force /* ASM SERVER */
ERROR: PST-initiated MANDATORY DISMOUNT of group DG_FLSH

可以看到,虽然数据库实例报错时报出了ORA-600错误,但是问题根源并非这个ORA-600错误,根据数据库和ASM实例的错误信息分析,问题是IO问题导致的。

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-697197/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1954
  • 访问量
    10651167