博客
关于我
强烈建议你试试无所不能的chatGPT，快点击我
exadata磁盘组无法mount恢复---惜分飞
阅读量：6198 次
发布时间：2019-06-21

本文共 17266 字，大约阅读时间需要 57 分钟。

标题：

作者：©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

接到朋友求救有客户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
mount
force
NOTE: cache registered group DATA_XFF number=1 incarn=0x5fe882cb
NOTE: cache began
mount
(first) of group DATA_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 at 103
for
pid 27, osid 62541
ERROR: Disk 0 cannot be offlined, since all 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 1 and 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 group DATA_XFF number=1 incarn=0x5fe882cb
NOTE: cache deleting context
for
group DATA_XFF 1
/0x5fe882cb
GMON dismounting group 1 at 104
for
pid 27, osid 62541
ERROR: diskgroup DATA_XFF was not mounted
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"
is missing from group number
"1"
ERROR: alter diskgroup DATA_XFF
mount
force

检查底层损坏情况

CellCLI>   list physicaldisk
         
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          Size Path                                     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之后

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          Size Path                                     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:59 2018
SQL> alter diskgroup DATA_XFF
mount
NOTE: cache registered group DATA_XFF number=1 incarn=0x78a886e7
NOTE: cache began
mount
(not first) of group DATA_XFF number=1 incarn=0x78a886e7
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
)
NOTE: Assigning number (1,0) to disk (o
/192
.168.10.3
/DATA_XFF_CD_02_XFFCEL01
)
Fri Dec 14 14:04:59 2018
GMON querying group 1 at 78
for
pid 28, osid 76016
NOTE: Assigning number (1,24) to disk ()
NOTE: Assigning number (1,25) to disk ()
NOTE: Assigning number (1,26) to disk ()
NOTE: Assigning number (1,27) to disk ()
NOTE: Assigning number (1,28) to disk ()
NOTE: Assigning number (1,29) to disk ()
NOTE: Assigning number (1,30) to disk ()
NOTE: Assigning number (1,31) to disk ()
NOTE: Assigning number (1,32) to disk ()
NOTE: Assigning number (1,33) to disk ()
NOTE: Assigning number (1,35) to disk ()
GMON querying group 1 at 79
for
pid 28, osid 76016
NOTE: cache opening disk 0 of grp 1: DATA_XFF_CD_02_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_02_XFFCEL01
NOTE: cache opening disk 1 of grp 1: DATA_XFF_CD_05_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_05_XFFCEL01
NOTE: cache opening disk 2 of grp 1: DATA_XFF_CD_03_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_03_XFFCEL01
NOTE: F1X0 found on disk 2 au 5 fcn 0.15948262
NOTE: cache opening disk 3 of grp 1: DATA_XFF_CD_06_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_06_XFFCEL01
NOTE: cache opening disk 4 of grp 1: DATA_XFF_CD_09_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_09_XFFCEL01
NOTE: cache opening disk 5 of grp 1: DATA_XFF_CD_04_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_04_XFFCEL01
NOTE: cache opening disk 6 of grp 1: DATA_XFF_CD_07_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_07_XFFCEL01
NOTE: cache opening disk 7 of grp 1: DATA_XFF_CD_11_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_11_XFFCEL01
NOTE: cache opening disk 8 of grp 1: DATA_XFF_CD_01_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_01_XFFCEL01
NOTE: cache opening disk 9 of grp 1: DATA_XFF_CD_00_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_00_XFFCEL01
NOTE: cache opening disk 10 of grp 1: DATA_XFF_CD_10_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_10_XFFCEL01
NOTE: cache opening disk 11 of grp 1: DATA_XFF_CD_08_XFFCEL01 path:o
/192
.168.10.3
/DATA_XFF_CD_08_XFFCEL01
NOTE: cache opening disk 12 of grp 1: DATA_XFF_CD_00_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_00_XFFCEL02
NOTE: cache opening disk 13 of grp 1: DATA_XFF_CD_01_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_01_XFFCEL02
NOTE: cache opening disk 14 of grp 1: DATA_XFF_CD_02_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_02_XFFCEL02
NOTE: cache opening disk 15 of grp 1: DATA_XFF_CD_03_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_03_XFFCEL02
NOTE: cache opening disk 16 of grp 1: DATA_XFF_CD_04_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_04_XFFCEL02
NOTE: cache opening disk 17 of grp 1: DATA_XFF_CD_05_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_05_XFFCEL02
NOTE: cache opening disk 18 of grp 1: DATA_XFF_CD_06_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_06_XFFCEL02
NOTE: cache opening disk 19 of grp 1: DATA_XFF_CD_07_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_07_XFFCEL02
NOTE: cache opening disk 20 of grp 1: DATA_XFF_CD_08_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_08_XFFCEL02
NOTE: cache opening disk 21 of grp 1: DATA_XFF_CD_09_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_09_XFFCEL02
NOTE: F1X0 found on disk 21 au 2 fcn 0.15948262
NOTE: cache opening disk 22 of grp 1: DATA_XFF_CD_10_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_10_XFFCEL02
NOTE: cache opening disk 23 of grp 1: DATA_XFF_CD_11_XFFCEL02 path:o
/192
.168.10.4
/DATA_XFF_CD_11_XFFCEL02
NOTE: cache opening disk 36 of grp 1: DATA_XFF_CD_11_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_11_XFFCEL03
NOTE: cache opening disk 37 of grp 1: DATA_XFF_CD_04_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_04_XFFCEL03
NOTE: cache opening disk 38 of grp 1: DATA_XFF_CD_00_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_00_XFFCEL03
NOTE: cache opening disk 39 of grp 1: DATA_XFF_CD_03_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_03_XFFCEL03
NOTE: cache opening disk 40 of grp 1: DATA_XFF_CD_05_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_05_XFFCEL03
NOTE: cache opening disk 41 of grp 1: DATA_XFF_CD_08_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_08_XFFCEL03
NOTE: cache opening disk 42 of grp 1: DATA_XFF_CD_01_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_01_XFFCEL03
NOTE: cache opening disk 43 of grp 1: DATA_XFF_CD_09_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_09_XFFCEL03
NOTE: cache opening disk 44 of grp 1: DATA_XFF_CD_06_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_06_XFFCEL03
NOTE: F1X0 found on disk 44 au 2 fcn 0.15948262
NOTE: cache opening disk 45 of grp 1: DATA_XFF_CD_07_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_07_XFFCEL03
NOTE: cache opening disk 46 of grp 1: DATA_XFF_CD_02_XFFCEL03 path:o
/192
.168.10.5
/DATA_XFF_CD_02_XFFCEL03
NOTE: cache mounting (not first) normal redundancy group 1
/0x78A886E7
(DATA_XFF)
Fri Dec 14 14:04:59 2018
kjbdomatt send to inst 2
Fri Dec 14 14:04:59 2018
NOTE: attached to recovery domain 1
NOTE: redo buffer size is 512 blocks (2101760 bytes)
Fri Dec 14 14:04:59 2018
NOTE: LGWR attempting to
mount
thread 2
for
diskgroup 1 (DATA_XFF)
NOTE: LGWR found thread 2 closed at ABA 98.4672
NOTE: LGWR mounted thread 2
for
diskgroup 1 (DATA_XFF)
NOTE: LGWR opening thread 2 at fcn 0.18931129 ABA 99.4673
NOTE: cache mounting group 1
/0x78A886E7
(DATA_XFF) succeeded
NOTE: cache ending
mount
(success) of group DATA_XFF number=1 incarn=0x78a886e7
GMON querying group 1 at 80
for
pid 19, osid 9805
Fri Dec 14 14:04:59 2018
NOTE: Instance updated compatible.asm to 11.2.0.3.0
for
grp 1
SUCCESS: diskgroup DATA_XFF was mounted
SUCCESS: alter diskgroup 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故障恢复,无法自行解决，可以和我们进行沟通解决

你可能感兴趣的文章
我的友情链接
查看>>
Linux系统安装后的基础优化-基于CentOS（5.8/6.4）
查看>>
Device eth0 does not seem to be present, delaying initialization
查看>>
android创建文件夹
查看>>
JUC——线程池技术相关内容
查看>>
我的友情链接
查看>>
shell编程——if语句
查看>>
Linux上文件的特殊权限SUID,SGID,SBIT详解
查看>>
js实例学习 -- onload标签
查看>>
cisco AP1131 配置DHCP自动获取
查看>>
ERP对部门经理的好处有哪些
查看>>
IT十八掌作业_java基础第四天_复习运算符、进制转化和数组
查看>>
移动端自定义美观的滑动条
查看>>
Spring AOP
查看>>
100层跳板游戏源码项目
查看>>
模拟彩票中奖（没弄明白）
查看>>
「Rancher社区技术支持计划」全面启动
查看>>
1.c#-Convert 类型转换
查看>>
修改this指向（bind、call 和 apply）
查看>>
使用硬盘，安装双系统，Win7+CentOS
查看>>
喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！-- 愿君每日到此一游！
当前时间: 2025-01-08 02:37:25   当前IP: 3.146.178.220   联系邮箱:javaeecc@qq.com     Copyright © 2020 - 2022 baihongyu.com 京ICP备2021015314号-2
强烈建议你试试无所不能的CHAT-GPT，快点击我
强烈建议你试试无所不能的CHAT-GPT，快点击我