ORACLE SOS

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 3228|回复: 0

exadata磁盘组不能mount恢复

[复制链接]

95

主题

266

帖子

1719

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1719
发表于 2018-12-23 11:37:12 | 显示全部楼层 |阅读模式
接到朋友求救有客户oracle exadata一体机 的 asm磁盘组无法mount,希望我们提供恢复支持服务
经过分析和了解,大致问题是:磁盘空间已经超容量使用(部分数据不能完成ASM镜像),最近又损坏一块盘,导致asm 磁盘组无法mount。我们分析后,通过重构exadata celldisk数据,将asm 磁盘组 mount成功后,实现五套数据库全部open成功(由于底层磁盘部分数据损坏,导致部分数据访问报错,需要在oracle层面进行处理)。

本次问题的具体分析和处理如下:
存放数据库文件的磁盘组不能mount
Wed Dec 12 21:29:04 2018
SQL> alter diskgroup DATA_XFF mountforce
NOTE: cache registered group DATA_XFFnumber=1 incarn=0x5fe882cb
NOTE: cache began mount (first) of groupDATA_XFF number=1 incarn=0x5fe882cb
NOTE: Assigning number (1,36) to disk(o/192.168.10.5/DATA_XFF_CD_11_XFFCEL03)
NOTE: Assigning number (1,34) to disk(o/192.168.10.5/DATA_XFF_CD_10_XFFCEL03)
NOTE: Assigning number (1,37) to disk(o/192.168.10.5/DATA_XFF_CD_04_XFFCEL03)
NOTE: Assigning number (1,38) to disk(o/192.168.10.5/DATA_XFF_CD_00_XFFCEL03)
NOTE: Assigning number (1,39) to disk(o/192.168.10.5/DATA_XFF_CD_03_XFFCEL03)
NOTE: Assigning number (1,40) to disk(o/192.168.10.5/DATA_XFF_CD_05_XFFCEL03)
NOTE: Assigning number (1,41) to disk(o/192.168.10.5/DATA_XFF_CD_08_XFFCEL03)
NOTE: Assigning number (1,42) to disk(o/192.168.10.5/DATA_XFF_CD_01_XFFCEL03)
NOTE: Assigning number (1,43) to disk(o/192.168.10.5/DATA_XFF_CD_09_XFFCEL03)
NOTE: Assigning number (1,44) to disk(o/192.168.10.5/DATA_XFF_CD_06_XFFCEL03)
NOTE: Assigning number (1,45) to disk (o/192.168.10.5/DATA_XFF_CD_07_XFFCEL03)
NOTE: Assigning number (1,46) to disk(o/192.168.10.5/DATA_XFF_CD_02_XFFCEL03)
NOTE: Assigning number (1,22) to disk(o/192.168.10.4/DATA_XFF_CD_10_XFFCEL02)
NOTE: Assigning number (1,18) to disk(o/192.168.10.4/DATA_XFF_CD_06_XFFCEL02)
NOTE: Assigning number (1,19) to disk(o/192.168.10.4/DATA_XFF_CD_07_XFFCEL02)
NOTE: Assigning number (1,15) to disk(o/192.168.10.4/DATA_XFF_CD_03_XFFCEL02)
NOTE: Assigning number (1,20) to disk(o/192.168.10.4/DATA_XFF_CD_08_XFFCEL02)
NOTE: Assigning number (1,17) to disk(o/192.168.10.4/DATA_XFF_CD_05_XFFCEL02)
NOTE: Assigning number (1,16) to disk(o/192.168.10.4/DATA_XFF_CD_04_XFFCEL02)
NOTE: Assigning number (1,23) to disk(o/192.168.10.4/DATA_XFF_CD_11_XFFCEL02)
NOTE: Assigning number (1,12) to disk(o/192.168.10.4/DATA_XFF_CD_00_XFFCEL02)
NOTE: Assigning number (1,21) to disk(o/192.168.10.4/DATA_XFF_CD_09_XFFCEL02)
NOTE: Assigning number (1,13) to disk(o/192.168.10.4/DATA_XFF_CD_01_XFFCEL02)
NOTE: Assigning number (1,14) to disk(o/192.168.10.4/DATA_XFF_CD_02_XFFCEL02)
NOTE: Assigning number (1,1) to disk(o/192.168.10.3/DATA_XFF_CD_05_XFFCEL01)
NOTE: Assigning number (1,2) to disk(o/192.168.10.3/DATA_XFF_CD_03_XFFCEL01)
NOTE: Assigning number (1,3) to disk(o/192.168.10.3/DATA_XFF_CD_06_XFFCEL01)
NOTE: Assigning number (1,4) to disk(o/192.168.10.3/DATA_XFF_CD_09_XFFCEL01)
NOTE: Assigning number (1,5) to disk(o/192.168.10.3/DATA_XFF_CD_04_XFFCEL01)
NOTE: Assigning number (1,6) to disk(o/192.168.10.3/DATA_XFF_CD_07_XFFCEL01)
NOTE: Assigning number (1,7) to disk(o/192.168.10.3/DATA_XFF_CD_11_XFFCEL01)
NOTE: Assigning number (1,8) to disk(o/192.168.10.3/DATA_XFF_CD_01_XFFCEL01)
NOTE: Assigning number (1,9) to disk(o/192.168.10.3/DATA_XFF_CD_00_XFFCEL01)
NOTE: Assigning number (1,10) to disk(o/192.168.10.3/DATA_XFF_CD_10_XFFCEL01)
NOTE: Assigning number (1,11) to disk(o/192.168.10.3/DATA_XFF_CD_08_XFFCEL01)
Wed Dec 12 21:29:10 2018
NOTE: GMON heartbeating for grp 1
GMON querying group 1 at 101 for pid 27,osid 62541
NOTE: Assigning number (1,0) to disk ()
GMON querying group 1 at 102 for pid 27,osid 62541
NOTE: process _user62541_+asm2 (62541)initiating offline of disk 0.3915937355 () with mask 0x7e[0x7f] in group 1
NOTE: initiating PST update: grp = 1,dsk = 0/0xe968764b, mask = 0x6a, op = clear
GMON updating disk modes for group 1 at103 for pid 27, osid 62541
ERROR: Disk 0 cannot be offlined, sinceall the disks [0, 25] with mirrored data would be offline.
ERROR: too many offline disks in PST(grp 1)
WARNING: Offline of disk 0 () in group 1and mode 0x7f failed on ASM inst 2
NOTE: cache dismounting (not clean)group 1/0x5FE882CB (DATA_XFF)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0x5FE882CB(DATA_XFF)
NOTE: cache ending mount (fail) of groupDATA_XFF number=1 incarn=0x5fe882cb
NOTE: cache deleting context for groupDATA_XFF 1/0x5fe882cb
GMON dismounting group 1 at 104 for pid27, osid 62541
ERROR: diskgroup DATA_XFF was notmounted
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15066: offlining disk "0"in group "DATA_XFF" may result in a data loss
ORA-15042: ASM disk "0" ismissing from group number "1"
ERROR: alter diskgroup DATA_XFF mountforce
检查底层损坏情况
CellCLI>   listphysicaldisk
         20:0           KN3VZL          normal
         20:1           KNAWLL          normal
         20:2           KN4E4L          warning -predictive failure, poor performance
         20:3           KNAN5L          normal
         20:4           KMJKYL          normal
         20:5           KN5DGL          normal
         20:6           KMDLWL          normal
         20:7           KMDKPL          normal
         20:8           KMDA7L          normal
         20:9           KN1YJL          normal
         20:10          KMH1YL          normal
         20:11          KMVHAL          normal
CellCLI>   list griddisk
         DATA_XFF_CD_00_XFFCEL01      active
         DATA_XFF_CD_01_XFFCEL01      active
         DATA_XFF_CD_02_XFFCEL01      proactive failure
         DATA_XFF_CD_03_XFFCEL01      active
         DATA_XFF_CD_04_XFFCEL01      active
         DATA_XFF_CD_05_XFFCEL01      active
         DATA_XFF_CD_06_XFFCEL01      active
         DATA_XFF_CD_07_XFFCEL01      active
         DATA_XFF_CD_08_XFFCEL01      active
         DATA_XFF_CD_09_XFFCEL01      active
         DATA_XFF_CD_10_XFFCEL01      active
         DATA_XFF_CD_11_XFFCEL01      active
在db节点无法发现异常磁盘的asm disk
[grid@ycdwdb01 grid]$ kfod disk=all
--------------------------------------------------------------------------------
Disk         SizePath                                    User     Group   
============================================================
   1:    433152 Mb o/192.168.10.3/DATA_XFF_CD_00_XFFCEL01 <unknown><unknown>
   2:    433152 Mb o/192.168.10.3/DATA_XFF_CD_01_XFFCEL01 <unknown><unknown>
   3:    433152 Mb o/192.168.10.3/DATA_XFF_CD_03_XFFCEL01 <unknown><unknown>
   4:    433152 Mb o/192.168.10.3/DATA_XFF_CD_04_XFFCEL01 <unknown><unknown>
   5:    433152 Mb o/192.168.10.3/DATA_XFF_CD_05_XFFCEL01 <unknown><unknown>
   6:    433152 Mb o/192.168.10.3/DATA_XFF_CD_06_XFFCEL01 <unknown><unknown>
   7:    433152 Mb o/192.168.10.3/DATA_XFF_CD_07_XFFCEL01 <unknown><unknown>
   8:    433152 Mb o/192.168.10.3/DATA_XFF_CD_08_XFFCEL01 <unknown><unknown>
   9:    433152 Mb o/192.168.10.3/DATA_XFF_CD_09_XFFCEL01 <unknown><unknown>
  10:    433152 Mb o/192.168.10.3/DATA_XFF_CD_10_XFFCEL01 <unknown><unknown>
  11:    433152 Mb o/192.168.10.3/DATA_XFF_CD_11_XFFCEL01 <unknown><unknown>
根据客户的反馈该磁盘组几乎全部被使用,asmcmd lsdg看到Usable_file_MB已经出现负值.证明该磁盘组本身的normal没有完全存储两份数据,在这样的情况下,继续坏盘会导致部分数据只有一份,因此也就出现了这里的磁盘组无法正常mount成功.

通过底层修复celldisk之后
data磁盘组直接mount成功
CellCLI>  list griddisk
         DATA_XFF_CD_00_XFFCEL01      active
         DATA_XFF_CD_01_XFFCEL01      active
         DATA_XFF_CD_02_XFFCEL01      active
         DATA_XFF_CD_03_XFFCEL01      active
         DATA_XFF_CD_04_XFFCEL01      active
         DATA_XFF_CD_05_XFFCEL01      active
         DATA_XFF_CD_06_XFFCEL01      active
         DATA_XFF_CD_07_XFFCEL01      active
         DATA_XFF_CD_08_XFFCEL01      active
         DATA_XFF_CD_09_XFFCEL01      active
         DATA_XFF_CD_10_XFFCEL01      active
         DATA_XFF_CD_11_XFFCEL01      active
[grid@ycdwdb01 grid]$ kfod disk=all
--------------------------------------------------------------------------------
Disk         SizePath                                    User     Group   
============================================================
   1:    433152 Mb o/192.168.10.3/DATA_XFF_CD_00_XFFCEL01 <unknown> <unknown>
   2:    433152 Mb o/192.168.10.3/DATA_XFF_CD_01_XFFCEL01 <unknown><unknown>
   3:    433152 Mb o/192.168.10.3/DATA_XFF_CD_02_XFFCEL01 <unknown><unknown>
   4:    433152 Mb o/192.168.10.3/DATA_XFF_CD_03_XFFCEL01 <unknown><unknown>
   5:    433152 Mb o/192.168.10.3/DATA_XFF_CD_04_XFFCEL01 <unknown><unknown>
   6:    433152 Mb o/192.168.10.3/DATA_XFF_CD_05_XFFCEL01 <unknown><unknown>
   7:    433152 Mb o/192.168.10.3/DATA_XFF_CD_06_XFFCEL01 <unknown><unknown>
   8:    433152 Mb o/192.168.10.3/DATA_XFF_CD_07_XFFCEL01 <unknown><unknown>
   9:    433152 Mb o/192.168.10.3/DATA_XFF_CD_08_XFFCEL01 <unknown><unknown>
  10:    433152 Mb o/192.168.10.3/DATA_XFF_CD_09_XFFCEL01 <unknown><unknown>
  11:    433152 Mb o/192.168.10.3/DATA_XFF_CD_10_XFFCEL01 <unknown><unknown>
  12:    433152 Mb o/192.168.10.3/DATA_XFF_CD_11_XFFCEL01 <unknown><unknown>
data磁盘组直接mount成功
Fri Dec 14 14:04:592018
SQL> alterdiskgroup DATA_XFF mount
NOTE: cacheregistered group DATA_XFF number=1 incarn=0x78a886e7
NOTE: cache beganmount (not first) of group DATA_XFF number=1 incarn=0x78a886e7
NOTE: Assigningnumber (1,36) to disk (o/192.168.10.5/DATA_XFF_CD_11_XFFCEL03)
NOTE: Assigningnumber (1,34) to disk (o/192.168.10.5/DATA_XFF_CD_10_XFFCEL03)
NOTE: Assigning number(1,37) to disk (o/192.168.10.5/DATA_XFF_CD_04_XFFCEL03)
NOTE: Assigningnumber (1,38) to disk (o/192.168.10.5/DATA_XFF_CD_00_XFFCEL03)
NOTE: Assigningnumber (1,39) to disk (o/192.168.10.5/DATA_XFF_CD_03_XFFCEL03)
NOTE: Assigningnumber (1,40) to disk (o/192.168.10.5/DATA_XFF_CD_05_XFFCEL03)
NOTE: Assigningnumber (1,41) to disk (o/192.168.10.5/DATA_XFF_CD_08_XFFCEL03)
NOTE: Assigningnumber (1,42) to disk (o/192.168.10.5/DATA_XFF_CD_01_XFFCEL03)
NOTE: Assigningnumber (1,43) to disk (o/192.168.10.5/DATA_XFF_CD_09_XFFCEL03)
NOTE: Assigningnumber (1,44) to disk (o/192.168.10.5/DATA_XFF_CD_06_XFFCEL03)
NOTE: Assigningnumber (1,45) to disk (o/192.168.10.5/DATA_XFF_CD_07_XFFCEL03)
NOTE: Assigningnumber (1,46) to disk (o/192.168.10.5/DATA_XFF_CD_02_XFFCEL03)
NOTE: Assigningnumber (1,22) to disk (o/192.168.10.4/DATA_XFF_CD_10_XFFCEL02)
NOTE: Assigningnumber (1,18) to disk (o/192.168.10.4/DATA_XFF_CD_06_XFFCEL02)
NOTE: Assigningnumber (1,19) to disk (o/192.168.10.4/DATA_XFF_CD_07_XFFCEL02)
NOTE: Assigningnumber (1,15) to disk (o/192.168.10.4/DATA_XFF_CD_03_XFFCEL02)
NOTE: Assigningnumber (1,20) to disk (o/192.168.10.4/DATA_XFF_CD_08_XFFCEL02)
NOTE: Assigningnumber (1,17) to disk (o/192.168.10.4/DATA_XFF_CD_05_XFFCEL02)
NOTE: Assigningnumber (1,16) to disk (o/192.168.10.4/DATA_XFF_CD_04_XFFCEL02)
NOTE: Assigningnumber (1,23) to disk (o/192.168.10.4/DATA_XFF_CD_11_XFFCEL02)
NOTE: Assigningnumber (1,12) to disk (o/192.168.10.4/DATA_XFF_CD_00_XFFCEL02)
NOTE: Assigningnumber (1,21) to disk (o/192.168.10.4/DATA_XFF_CD_09_XFFCEL02)
NOTE: Assigningnumber (1,13) to disk (o/192.168.10.4/DATA_XFF_CD_01_XFFCEL02)
NOTE: Assigningnumber (1,14) to disk (o/192.168.10.4/DATA_XFF_CD_02_XFFCEL02)
NOTE: Assigningnumber (1,1) to disk (o/192.168.10.3/DATA_XFF_CD_05_XFFCEL01)
NOTE: Assigningnumber (1,2) to disk (o/192.168.10.3/DATA_XFF_CD_03_XFFCEL01)
NOTE: Assigningnumber (1,3) to disk (o/192.168.10.3/DATA_XFF_CD_06_XFFCEL01)
NOTE: Assigningnumber (1,4) to disk (o/192.168.10.3/DATA_XFF_CD_09_XFFCEL01)
NOTE: Assigningnumber (1,5) to disk (o/192.168.10.3/DATA_XFF_CD_04_XFFCEL01)
NOTE: Assigningnumber (1,6) to disk (o/192.168.10.3/DATA_XFF_CD_07_XFFCEL01)
NOTE: Assigningnumber (1,7) to disk (o/192.168.10.3/DATA_XFF_CD_11_XFFCEL01)
NOTE: Assigningnumber (1,8) to disk (o/192.168.10.3/DATA_XFF_CD_01_XFFCEL01)
NOTE: Assigningnumber (1,9) to disk (o/192.168.10.3/DATA_XFF_CD_00_XFFCEL01)
NOTE: Assigningnumber (1,10) to disk (o/192.168.10.3/DATA_XFF_CD_10_XFFCEL01)
NOTE: Assigningnumber (1,11) to disk (o/192.168.10.3/DATA_XFF_CD_08_XFFCEL01)
NOTE: Assigningnumber (1,0) to disk (o/192.168.10.3/DATA_XFF_CD_02_XFFCEL01)
Fri Dec 14 14:04:592018
GMON querying group1 at 78 for pid 28, osid 76016
NOTE: Assigningnumber (1,24) to disk ()
NOTE: Assigningnumber (1,25) to disk ()
NOTE: Assigningnumber (1,26) to disk ()
NOTE: Assigningnumber (1,27) to disk ()
NOTE: Assigningnumber (1,28) to disk ()
NOTE: Assigningnumber (1,29) to disk ()
NOTE: Assigningnumber (1,30) to disk ()
NOTE: Assigningnumber (1,31) to disk ()
NOTE: Assigningnumber (1,32) to disk ()
NOTE: Assigningnumber (1,33) to disk ()
NOTE: Assigningnumber (1,35) to disk ()
GMON querying group1 at 79 for pid 28, osid 76016
NOTE: cache openingdisk 0 of grp 1: DATA_XFF_CD_02_XFFCEL01path/192.168.10.3/DATA_XFF_CD_02_XFFCEL01
NOTE: cache openingdisk 1 of grp 1: DATA_XFF_CD_05_XFFCEL01path/192.168.10.3/DATA_XFF_CD_05_XFFCEL01
NOTE: cache openingdisk 2 of grp 1: DATA_XFF_CD_03_XFFCEL01 path/192.168.10.3/DATA_XFF_CD_03_XFFCEL01
NOTE: F1X0 found ondisk 2 au 5 fcn 0.15948262
NOTE: cache openingdisk 3 of grp 1: DATA_XFF_CD_06_XFFCEL01path/192.168.10.3/DATA_XFF_CD_06_XFFCEL01
NOTE: cache openingdisk 4 of grp 1: DATA_XFF_CD_09_XFFCEL01path/192.168.10.3/DATA_XFF_CD_09_XFFCEL01
NOTE: cache openingdisk 5 of grp 1: DATA_XFF_CD_04_XFFCEL01path/192.168.10.3/DATA_XFF_CD_04_XFFCEL01
NOTE: cache openingdisk 6 of grp 1: DATA_XFF_CD_07_XFFCEL01path/192.168.10.3/DATA_XFF_CD_07_XFFCEL01
NOTE: cache openingdisk 7 of grp 1: DATA_XFF_CD_11_XFFCEL01path/192.168.10.3/DATA_XFF_CD_11_XFFCEL01
NOTE: cache openingdisk 8 of grp 1: DATA_XFF_CD_01_XFFCEL01 path/192.168.10.3/DATA_XFF_CD_01_XFFCEL01
NOTE: cache openingdisk 9 of grp 1: DATA_XFF_CD_00_XFFCEL01path/192.168.10.3/DATA_XFF_CD_00_XFFCEL01
NOTE: cache openingdisk 10 of grp 1: DATA_XFF_CD_10_XFFCEL01path:o/192.168.10.3/DATA_XFF_CD_10_XFFCEL01
NOTE: cache openingdisk 11 of grp 1: DATA_XFF_CD_08_XFFCEL01path:o/192.168.10.3/DATA_XFF_CD_08_XFFCEL01
NOTE: cache openingdisk 12 of grp 1: DATA_XFF_CD_00_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_00_XFFCEL02
NOTE: cache openingdisk 13 of grp 1: DATA_XFF_CD_01_XFFCEL02 path:o/192.168.10.4/DATA_XFF_CD_01_XFFCEL02
NOTE: cache openingdisk 14 of grp 1: DATA_XFF_CD_02_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_02_XFFCEL02
NOTE: cache openingdisk 15 of grp 1: DATA_XFF_CD_03_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_03_XFFCEL02
NOTE: cache openingdisk 16 of grp 1: DATA_XFF_CD_04_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_04_XFFCEL02
NOTE: cache openingdisk 17 of grp 1: DATA_XFF_CD_05_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_05_XFFCEL02
NOTE: cache openingdisk 18 of grp 1: DATA_XFF_CD_06_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_06_XFFCEL02
NOTE: cache openingdisk 19 of grp 1: DATA_XFF_CD_07_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_07_XFFCEL02
NOTE: cache openingdisk 20 of grp 1: DATA_XFF_CD_08_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_08_XFFCEL02
NOTE: cache openingdisk 21 of grp 1: DATA_XFF_CD_09_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_09_XFFCEL02
NOTE: F1X0 found ondisk 21 au 2 fcn 0.15948262
NOTE: cache openingdisk 22 of grp 1: DATA_XFF_CD_10_XFFCEL02 path:o/192.168.10.4/DATA_XFF_CD_10_XFFCEL02
NOTE: cache openingdisk 23 of grp 1: DATA_XFF_CD_11_XFFCEL02path:o/192.168.10.4/DATA_XFF_CD_11_XFFCEL02
NOTE: cache openingdisk 36 of grp 1: DATA_XFF_CD_11_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_11_XFFCEL03
NOTE: cache openingdisk 37 of grp 1: DATA_XFF_CD_04_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_04_XFFCEL03
NOTE: cache openingdisk 38 of grp 1: DATA_XFF_CD_00_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_00_XFFCEL03
NOTE: cache openingdisk 39 of grp 1: DATA_XFF_CD_03_XFFCEL03 path:o/192.168.10.5/DATA_XFF_CD_03_XFFCEL03
NOTE: cache openingdisk 40 of grp 1: DATA_XFF_CD_05_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_05_XFFCEL03
NOTE: cache openingdisk 41 of grp 1: DATA_XFF_CD_08_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_08_XFFCEL03
NOTE: cache openingdisk 42 of grp 1: DATA_XFF_CD_01_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_01_XFFCEL03
NOTE: cache openingdisk 43 of grp 1: DATA_XFF_CD_09_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_09_XFFCEL03
NOTE: cache openingdisk 44 of grp 1: DATA_XFF_CD_06_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_06_XFFCEL03
NOTE: F1X0 found ondisk 44 au 2 fcn 0.15948262
NOTE: cache openingdisk 45 of grp 1: DATA_XFF_CD_07_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_07_XFFCEL03
NOTE: cache openingdisk 46 of grp 1: DATA_XFF_CD_02_XFFCEL03path:o/192.168.10.5/DATA_XFF_CD_02_XFFCEL03
NOTE: cachemounting (not first) normal redundancy group 1/0x78A886E7 (DATA_XFF)
Fri Dec 14 14:04:592018
kjbdomatt send toinst 2
Fri Dec 14 14:04:592018
NOTE: attached torecovery domain 1
NOTE: redo buffersize is 512 blocks (2101760 bytes)
Fri Dec 14 14:04:592018
NOTE: LGWRattempting to mount thread 2 for diskgroup 1 (DATA_XFF)
NOTE: LGWR foundthread 2 closed at ABA 98.4672
NOTE: LGWR mountedthread 2 for diskgroup 1 (DATA_XFF)
NOTE: LGWR openingthread 2 at fcn 0.18931129 ABA 99.4673
NOTE: cachemounting group 1/0x78A886E7 (DATA_XFF) succeeded
NOTE: cache endingmount (success) of group DATA_XFF number=1 incarn=0x78a886e7
GMON querying group1 at 80 for pid 19, osid 9805
Fri Dec 14 14:04:592018
NOTE: Instanceupdated compatible.asm to 11.2.0.3.0 for grp 1
SUCCESS: diskgroupDATA_XFF was mounted
SUCCESS: alterdiskgroup DATA_XFF mount
恢复后的asm磁盘状态
ASMCMD> lsdg
State   Type    Rebal  Sector Block       AU  Total_MB  Free_MB Req_mir_free_MB  Usable_file_MB  Offline_disks Voting_files  Name
MOUNTED NORMAL  Y         512  4096  4194304  15160320 4776184         5197824         -210820            12            N  DATA_XFF/
MOUNTED NORMAL  N         512  4096  4194304    864896  863400          298240         282580             0            Y  DBFS_DG/
MOUNTED NORMAL  N         512  4096  4194304   3787840 2157232         1298688         429272             0            N  RECO_XFF/
后续数据库open成功,有部分坏块通过技术手段进行二次处理,至此数据库恢复完成,成功抢救了客户Oracle Exadata中的绝大部分数据.如果有类似xd故障恢复,无法自行解决,需要恢复支持请联系我们
Phone:13429648788   Q Q:107644445file:///C:\Users\ADMINI~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg   E-Mail:dba@xifenfei.com

Q Q:107644445
Tel:13429648788
Email:dba@xifenfei.com
个人Blog(惜分飞)
提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|ORACLE SOS 技术论坛

GMT+8, 2024-12-5 10:17 , Processed in 0.021907 second(s), 21 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表