Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ora 问题处理
发新帖
ALLSTARS_ORACLE

999

积分

1

好友

942

主题

[物理/逻辑坏块] ora 问题处理

1#
发表于 2017-4-14 15:43:31 | 查看: 2036| 回复: 2

环境：
RAC p740 p550
-bash-3.2$ srvctl status database -d kmis

Instance kmis1 is running on node p550
Instance kmis2 is not running on node p740


AIX
-bash-3.2$ oslevel -r
6100-08

数据库 oracle 11.2.2


$ srvctl start database -d kmis
PRCR-1079 : Failed to start resource ora.kmis.db
CRS-5017: The resource action "ora.ARCHDG.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "ARCHDG" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ARCHDG"
ORA-15080: synchronous I/O operation to a disk failed
CRS-2674: Start of 'ora.ARCHDG.dg' on 'p740' failed
CRS-2632: There are no more servers to try to place resource 'ora.kmis.db' on that would satisfy its placement policy
$
$ srvctl start instance -d kmis -i kmis2 -o open;
PRCR-1013 : Failed to start resource ora.kmis.db
PRCR-1064 : Failed to start resource ora.kmis.db on node p740
CRS-5017: The resource action "ora.ARCHDG.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "ARCHDG" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ARCHDG"
ORA-15080: synchronous I/O operation to a disk failed
1
p550
ASMCMD> ls -lState    Type    Rebal  NameMOUNTED  EXTERN  N      ARCHDG/MOUNTED  NORMAL  N      CRS/MOUNTED  EXTERN  N      DATADG/ASMCMD> host
p740上
MOUNTED  NORMAL  N      CRS/MOUNTED  EXTERN  N      DATADG/挂载不上 ARCDG
一挂载就报错。

还需要提供什么信息，需要keod的么，
磁盘路径
SQL> select path from v$asm_disk;
PATH--------------------------------------------------------------------------------/dev/rhdisk11/dev/rhdisk12/dev/rhdisk2/dev/rhdisk3/dev/rhdisk4/dev/rhdisk5/dev/rhdisk6/dev/rhdiskpower0
你看需要提供什么信息来排错？

下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638  QQ: 47079569     邮箱：service@parnassusdata.com
2#
发表于 2017-4-14 15:45:03
刚刚发表了，这篇文章我们机房就掉电了，还有ups背到，下去开窗户，搞了多久会来就有人，回复了，真快谢谢

强制挂载 不行啊



ASMCMD> mount archdg
ORA-15032: not all alterations performed
ORA-15017: diskgroup "ARCHDG" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ARCHDG"
ORA-15080: synchronous I/O operation to a disk failed (DBD ERROR: OCIStmtExecute)
ASMCMD>




asm日志 p740

<msg time='2014-01-15T08:32:04.946+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492' version='1'>
<txt>WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 268 in group [3.3898871312] from disk DATADG_0008  allocation unit 1119 reason error; if possible,will try another mirror side
</txt>
</msg>
<msg time='2014-01-15T08:32:04.946+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module=''
pid='7405848' version='1'>
<txt>ERROR: ORA-15130 thrown in RBAL for group number 3
</txt>
</msg>
<msg time='2014-01-15T08:32:04.965+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>Errors in file /oracle/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_13697492.trc:
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 19: No such device
Additional information: 7
Additional information: 2291712
Additional information: -1
</txt>
</msg>
<msg time='2014-01-15T08:32:04.965+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>WARNING: Read Failed. group:3 disk:8 AU:1119 offset:0 size:512
</txt>
</msg>
<msg time='2014-01-15T08:32:04.965+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 268 in group [3.3898871312] from disk DATADG_0008  allocation unit 1119 reason error; if possible,will try another mirror side
</txt>
</msg>
<msg time='2014-01-15T08:32:04.965+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>Errors in file /oracle/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_13697492.trc:
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 19: No such device
Additional information: 7
Additional information: 2291712
Additional information: -1
</txt>
</msg>
<msg time='2014-01-15T08:32:04.965+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>WARNING: Read Failed. group:3 disk:8 AU:1119 offset:0 size:512
</txt>
</msg>
<msg time='2014-01-15T08:32:04.965+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 268 in group [3.3898871312] from disk DATADG_0008  allocation unit 1119 reason error; if possible,will try another mirror side
</txt>
</msg>
<msg time='2014-01-15T08:32:04.966+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>Errors in file /oracle/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_13697492.trc:
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 19: No such device
Additional information: 7
Additional information: 2291712
Additional information: -1
</txt>
</msg>
<msg time='2014-01-15T08:32:04.966+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>WARNING: Read Failed. group:3 disk:8 AU:1119 offset:0 size:512
</txt>
</msg>
<msg time='2014-01-15T08:32:04.966+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 268 in group [3.3898871312] from disk DATADG_0008  allocation unit 1119 reason error; if possible,will try another mirror side
</txt>
</msg>
<msg time='2014-01-15T08:32:04.966+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>Errors in file /oracle/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_13697492.trc:
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 19: No such device
Additional information: 7
Additional information: 2291712
Additional information: -1
</txt>
</msg>
<msg time='2014-01-15T08:32:04.966+08:00' org_id='oracle' comp_id='asm'
client_id='' type='UNKNOWN' level='16'
host_id='P740' host_addr='172.16.15.82' module='oracle@P740 (TNS V1-V3)'
pid='13697492'>
<txt>WARNING: Read Failed. group:3 disk:8 AU:1119 offset:0 size:512
</txt>
</msg>

回复 只看该作者 道具 举报

3#
发表于 2017-4-14 15:45:37

           0           7 CLOSED  UNKNOWN      NORMAL              /dev/rhdiskpower0
                                                                  

           0           0 CLOSED  MEMBER       NORMAL              /dev/rhdis


SELECT GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,STATE,NAME,PATH FROM V$ASM_DISK;


10422126         Misleading "WARNING: IO Failed" alert log messages in ASM alert log

哥  你说的是这个，这就是上面的log一部分啊，它的意思是说在alert里查看告警，都完全给出了了，你有什么好的解决方法没有

-bash-3.2$ kfed read /dev/rhdiskpower0
kfbh.endian:                          0 ; 0x000: 0x00
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt:                          1 ; 0x003: 0x01
kfbh.block.blk:                       0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj:              2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check:                  3598407900 ; 0x00c: 0xd67b58dc
kfbh.fcn.base:                      265 ; 0x010: 0x00000109
kfbh.fcn.wrap:                        0 ; 0x014: 0x00000000
kfbh.spare1:                          0 ; 0x018: 0x00000000
kfbh.spare2:                          0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr:         ORCLDISK ; 0x000: length=8
kfdhdb.driver.reserved[0]:            0 ; 0x008: 0x00000000
kfdhdb.driver.reserved[1]:            0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved[2]:            0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]:            0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]:            0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]:            0 ; 0x01c: 0x00000000
kfdhdb.compat:                186646528 ; 0x020: 0x0b200000
kfdhdb.dsknum:                        0 ; 0x024: 0x0000
kfdhdb.grptyp:                        1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts:                        3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname:             ARCHDG_0000 ; 0x028: length=11
kfdhdb.grpname:                  ARCHDG ; 0x048: length=6
kfdhdb.fgname:              ARCHDG_0000 ; 0x068: length=11
kfdhdb.capname:                         ; 0x088: length=0
kfdhdb.crestmp.hi:             32989162 ; 0x0a8: HOUR=0xa DAYS=0x1f MNTH=0x7 YEAR=0x7dd
kfdhdb.crestmp.lo:           1493865472 ; 0x0ac: USEC=0x0 MSEC=0x2a5 SECS=0x10 MINS=0x16
kfdhdb.mntstmp.hi:             32999180 ; 0x0b0: HOUR=0xc DAYS=0x18 MNTH=0x1 YEAR=0x7de
kfdhdb.mntstmp.lo:            821526528 ; 0x0b4: USEC=0x0 MSEC=0x1e0 SECS=0xf MINS=0xc
kfdhdb.secsize:                     512 ; 0x0b8: 0x0200
kfdhdb.blksize:                    4096 ; 0x0ba: 0x1000
kfdhdb.ausize:                  1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact:                    113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize:                  204800 ; 0x0c4: 0x00032000
kfdhdb.pmcnt:                         3 ; 0x0c8: 0x00000003
kfdhdb.fstlocn:                       1 ; 0x0cc: 0x00000001
kfdhdb.altlocn:                       2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn:                      2 ; 0x0d4: 0x00000002
kfdhdb.redomirrors[0]:                0 ; 0x0d8: 0x0000
kfdhdb.redomirrors[1]:            65535 ; 0x0da: 0xffff
kfdhdb.redomirrors[2]:            65535 ; 0x0dc: 0xffff
kfdhdb.redomirrors[3]:            65535 ; 0x0de: 0xffff
kfdhdb.dbcompat:              168820736 ; 0x0e0: 0x0a100000
kfdhdb.grpstmp.hi:             32989162 ; 0x0e4: HOUR=0xa DAYS=0x1f MNTH=0x7 YEAR=0x7dd
kfdhdb.grpstmp.lo:           1493560320 ; 0x0e8: USEC=0x0 MSEC=0x17b SECS=0x10 MINS=0x16
kfdhdb.vfstart:                       0 ; 0x0ec: 0x00000000
kfdhdb.vfend:                         0 ; 0x0f0: 0x00000000
kfdhdb.spfile:                        0 ; 0x0f4: 0x00000000
kfdhdb.spfflg:                        0 ; 0x0f8: 0x00000000
kfdhdb.ub4spare[0]:                   0 ; 0x0fc: 0x00000000
kfdhdb.ub4spare[1]:                   0 ; 0x100: 0x00000000
kfdhdb.ub4spare[2]:                   0 ; 0x104: 0x00000000
kfdhdb.ub4spare[3]:                   0 ; 0x108: 0x00000000
kfdhdb.ub4spare[4]:                   0 ; 0x10c: 0x00000000
kfdhdb.ub4spare[5]:                   0 ; 0x110: 0x00000000
kfdhdb.ub4spare[6]:                   0 ; 0x114: 0x00000000
kfdhdb.ub4spare[7]:                   0 ; 0x118: 0x00000000
kfdhdb.ub4spare[8]:                   0 ; 0x11c: 0x00000000
kfdhdb.ub4spare[9]:                   0 ; 0x120: 0x00000000
kfdhdb.ub4spare[10]:                  0 ; 0x124: 0x00000000
kfdhdb.ub4spare[11]:                  0 ; 0x128: 0x00000000
kfdhdb.ub4spare[12]:                  0 ; 0x12c: 0x00000000
kfdhdb.ub4spare[13]:                  0 ; 0x130: 0x00000000
kfdhdb.ub4spare[14]:                  0 ; 0x134: 0x00000000
kfdhdb.ub4spare[15]:                  0 ; 0x138: 0x00000000
kfdhdb.ub4spare[16]:                  0 ; 0x13c: 0x00000000
kfdhdb.ub4spare[17]:                  0 ; 0x140: 0x00000000
kfdhdb.ub4spare[18]:                  0 ; 0x144: 0x00000000
kfdhdb.ub4spare[19]:                  0 ; 0x148: 0x00000000
kfdhdb.ub4spare[20]:                  0 ; 0x14c: 0x00000000
kfdhdb.ub4spare[21]:                  0 ; 0x150: 0x00000000
kfdhdb.ub4spare[22]:                  0 ; 0x154: 0x00000000
kfdhdb.ub4spare[23]:                  0 ; 0x158: 0x00000000
kfdhdb.ub4spare[24]:                  0 ; 0x15c: 0x00000000
kfdhdb.ub4spare[25]:                  0 ; 0x160: 0x00000000
kfdhdb.ub4spare[26]:                  0 ; 0x164: 0x00000000
kfdhdb.ub4spare[27]:                  0 ; 0x168: 0x00000000
kfdhdb.ub4spare[28]:                  0 ; 0x16c: 0x00000000
kfdhdb.ub4spare[29]:                  0 ; 0x170: 0x00000000
kfdhdb.ub4spare[30]:                  0 ; 0x174: 0x00000000
kfdhdb.ub4spare[31]:                  0 ; 0x178: 0x00000000
kfdhdb.ub4spare[32]:                  0 ; 0x17c: 0x00000000
kfdhdb.ub4spare[33]:                  0 ; 0x180: 0x00000000
kfdhdb.ub4spare[34]:                  0 ; 0x184: 0x00000000
kfdhdb.ub4spare[35]:                  0 ; 0x188: 0x00000000
kfdhdb.ub4spare[36]:                  0 ; 0x18c: 0x00000000
kfdhdb.ub4spare[37]:                  0 ; 0x190: 0x00000000
kfdhdb.ub4spare[38]:                  0 ; 0x194: 0x00000000
kfdhdb.ub4spare[39]:                  0 ; 0x198: 0x00000000
kfdhdb.ub4spare[40]:                  0 ; 0x19c: 0x00000000
kfdhdb.ub4spare[41]:                  0 ; 0x1a0: 0x00000000
kfdhdb.ub4spare[42]:                  0 ; 0x1a4: 0x00000000
kfdhdb.ub4spare[43]:                  0 ; 0x1a8: 0x00000000
kfdhdb.ub4spare[44]:                  0 ; 0x1ac: 0x00000000
kfdhdb.ub4spare[45]:                  0 ; 0x1b0: 0x00000000
kfdhdb.ub4spare[46]:                  0 ; 0x1b4: 0x00000000
kfdhdb.ub4spare[47]:                  0 ; 0x1b8: 0x00000000
kfdhdb.ub4spare[48]:                  0 ; 0x1bc: 0x00000000
kfdhdb.ub4spare[49]:                  0 ; 0x1c0: 0x00000000
kfdhdb.ub4spare[50]:                  0 ; 0x1c4: 0x00000000
kfdhdb.ub4spare[51]:                  0 ; 0x1c8: 0x00000000
kfdhdb.ub4spare[52]:                  0 ; 0x1cc: 0x00000000
kfdhdb.ub4spare[53]:                  0 ; 0x1d0: 0x00000000
kfdhdb.acdb.aba.seq:                  0 ; 0x1d4: 0x00000000
kfdhdb.acdb.aba.blk:                  0 ; 0x1d8: 0x00000000
kfdhdb.acdb.ents:                     0 ; 0x1dc: 0x0000
kfdhdb.acdb.ub2spare:                 0 ; 0x1de: 0x0000

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-18 20:24 , Processed in 0.047782 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569