ORA-600(kfdds:badaddr)错误

最新推荐文章于 2021-04-14 11:01:29 发布
最新推荐文章于 2021-04-14 11:01:29 发布
阅读量361 收藏
点赞数
文章标签： 数据库

客户数据库出现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::badaddr的ORA-600错误，不过在另外一个和ASM的IO错误有关的文档中，找到了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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-697197/

ckawt40802
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
ORA-12518 TNS:监听程序无法分发客户机连接
01-12
ORA-12518 TNS:监听程序无法分发客户机连接，在您安装好数据库后配置连接数据库的过程中遇到这类问题应该很头疼吧，不过，当您还是四处查资料来解决您遇到的另你头疼的问题时，如果不经意间看到了这则贴子，那请您升...
DBCA+ASM遭遇ORA-00600 [kfioTranslateIO03]
OS is DB,DB is OS
02-15 1567
在一台AIX+ASM但实例环境上使用DBCA创建数据库时，遭遇了ORA-00600 [kfioTranslateIO03]的错误。 alert 告警日志内容如下： NOTE: Loaded library: System  ORA-15025: could not open disk "/dev/rhdisk1" ORA-27041: unable to open file IBM AI
oracle数据库asm坏块,虚拟机RAC的ASM磁盘组坏块导致重建DB
weixin_29589063的博客
04-11 363
CRS-0215: Could not start resource 'ora.RAC.RAC1.inst'.检查相关的日志：首先查看了下asm的日志：alert_+ASM1.loged Nov 23 15:14:12 2011Starting Oracle instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0In...
ORA-00600 [kfioTranslateIO03] ORA-00600 [17090]
xionglang7的专栏
11-04 1529
[grid@cnsh281060 bin]$ ./setasmgidwrap o=/paic/stg/oracle/11g/app/oracle/product/11.2.0.3.9/bin/oracle [grid@cnsh281060 bin]$ ls -l /paic/stg/oracle/11g/app/oracle/product/11.2.0.3.9/bin/oracle -rwx
oracle at sq sql sw,可怕的ORA-600
weixin_42361796的博客
04-12 326
Dump file /u01/app/oracle/diag/rdbms/ncrac/ncrac12/incident/incdir_107485/ncrac12_j002_706_i107485.trcOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning,...
oracle asm 存储故障,守得云开见月明:一次ASM存储高可用故障解决过程分析
weixin_42534103的博客
04-03 508
2018-08-16T14:56:04.957199+08:00 -->差不多和DB同时检测到IO错误WARNING: Write Failed. group:1 disk:1 AU:1 offset:4190208 size:4096path:/dev/rdisk/MES1_p4_moddb_ocrvoteincarnation:0xf0996d00 asynchronous resul...
Oracle dbca时报：ORA-12547: TNS:lost contact错误的解决
12-16
最近在工作中遇到了一个问题，错误是Oracle dbca时报错：ORA-12547: TNS:lost contact，通过查找相关的资料终于找到了解决的方法，下面分享给大家，话不多说了，来一起看看详细的介绍吧。 环境： OS:RHEL6.5 x86-...
连接Oracle数据库时报ORA-12541:TNS:无监听程序的图文解决教程
09-10
主要介绍了连接Oracle数据库时报ORA-12541:TNS:无监听程序的图文解决教程,非常不错，具有参考借鉴价值，需要的朋友可以参考下
oracle远程连接服务器出现 ORA-12170 TNS:连接超时 解决办法
09-10
oracle远程连接服务器出现 ORA-12170 TNS:连接超时 解决办法，需要的朋友可以参考一下
查看mysql宕机原因_数据库宕机原因 - 墨天轮问答
weixin_34369597的博客
02-12 911
数据库版本：oracle rac 11.2.0.4系统版本：red hat 6.7症状：数据库集群宕机，重启服务器后恢复正常。alert.Log内容如下：Auto-tuning: Starting background process GTXaStarting background process GTXaSat Mar 28 21:54:46 2020GTXa started with pid=...
ASM实例报04031错误
ckklxjdw531374的博客
03-25 590
环境：oracle 11.2.0.3 rac ，AIX6.1第一节点ASM实例报04031，赶到单位检查日志：ORA-04031: unable to allocate 3896 bytes of shared memory (...
ORA-600(kfioTranslateIO03)和ORA-600(17090)错误
ckawt40802的专栏
11-23 360
客户的11.2 RAC环境出现这两个ORA-600错误。 [@more@] 详细的错误信息为： Mon Nov 19 19:32:56 2012 ALTER SYSTEM SET ...
oracle -15064,由 BUG 引发 ORA-15064 进而导致数据库实例意外中止
weixin_42604188的博客
04-04 1385
Mon Jan 05 01:40:50 2015WARNING: ASM communication error: op 18 state 0x50 (3113)ERROR: slave communication error with ASMNOTE: Deferred communication with ASM instanceErrors in file /u01/app/oracle/d...
tb级别oracle数据库,记一次TB级别的Oracle Exadata数据库恢复
weixin_36244678的博客
04-14 371
现在它还提供了新的低成本1/8机架配置。 借助Oracle Exadata，客户可通过整合降低IT成本，使存储能力增加10倍，提升所有应用的性能，因消除系统集成的试错过程而加快上市速度，以及实时做出更好的业务决策某客户的exadata环境，由于大量硬件故障，导致数据库宕机。经过分析确认是由于某个cell节点的某个disk出现异常，导致部分cell节点的disk 离线后无法进行asm reblanc...
一次asm dg 迁移后的坑
Lixora's DB Home
12-21 1390
ASM  alert： WARNING: Read Failed. group:0 disk:3 AU:0 offset:0 size:4096 Errors in file /oracle/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_27525184.trc: ORA-27063: number of bytes read/written is inc
oracle重启root,案例:Oracle报错ORA-15025 ORA-27041 root用户操作rac导致节点宕机
weixin_35703897的博客
04-07 867
天萃荷净运维DBA反映Oracle RAC环境中节点宕机，alert发现报错ORA-15025 ORA-27041，分析原因为使用root用户操作rac导致节点宕机接到同事请求,说客户的linux redhat 5.8平台部署的11.2.0.3 RAC 节点2挂掉了,报磁盘IO异常,数据库hang住Fri Jun 14 12:01:22 2013Thread 2 advanced to log s...
ORACLE RAC 11.2.0.4 for RHEL6.8 集群CRS异常导致集群命令无法使用
www_xue_xi的博客
07-24 8290
经查看集群相关日志可以确定，由于存储磁盘出现IO问题（或光线闪断、或IO延迟），导致集群CRS异常宕机。但是，比较奇怪的是，虽然CSR掉线了，ASM实例 和DB实例却好好的，还可以正常使用。查询oracle support发现一篇文章1581684.1 提到ASM CRS仲裁盘访问超时与隐藏参数_asm_hbeatiowait有关系，而ASM的 隐藏参数_asm_hbeatiowait由于操作系统多路径Multipath配置的polling_interval有关，具体的故障原因是操作系统盘的判断访问超时远大
ASM无法启动的问题分析(一）
congbao6525的博客
01-23 1640
最近碰到了一个关于ASM无法启动的案例，当然这个案例比较长，准备分两篇来写。 问题的背景如下： 目前存在一套standalone的环境，采用了ASM作为存储管理，业务属于实时统计，在某一天下班的时候...
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
jade 的专栏
10-21 4726
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent -bash-3.2$ cat /etc/release                    Oracle Solaris 10 8/11 s10s_u10wos_17b SPARC   Copyright (c) 1983, 2011, Or
ORA-00904: : ?????
最新发布
09-06
引用: ORA-00904错误是Oracle数据库中常见的错误，它表示标识符无效。这个错误通常出现在SQL语句中，可能是字段名、表名或者其他标识符写错了。要解决这个问题，你需要仔细检查SQL语句中的标识符是否正确拼写，包括大小写和特殊字符等。另外，还需要确保你正在访问的对象（表、视图等）存在，并且你具有足够的权限来访问它们。 根据你的问题，你提到了ORA-00904: : ?????，这里的?????应该是指具体的标识符。要解决这个问题，你需要确定这个标识符是哪个，并检查它的拼写和是否存在。如果你无法确定具体的标识符是什么，你可以尝试检查SQL语句中的字段名、表名等标识符，看看是否有拼写错误或者缺失。此外，还可以通过查询数据库的元数据（如数据字典）来查找具体的标识符信息。希望这些提示对你有帮助。<span class="em">1</span> #### 引用[.reference_title] - *1* [Oracle数据库报错ORA-00904 标识符无效问题解决办法.txt](https://download.csdn.net/download/ulitimateangle/11456593)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 100%"] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值