惜分飞oracle,惜分飞 - 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 13429648788...

于 2021-04-04 05:28:50 发布
阅读量241 收藏
点赞数
文章标签： 惜分飞oracle

接到朋友求救有客户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

2: 433152 Mb o/192.168.10.3/DATA_XFF_CD_01_XFFCEL01

3: 433152 Mb o/192.168.10.3/DATA_XFF_CD_03_XFFCEL01

4: 433152 Mb o/192.168.10.3/DATA_XFF_CD_04_XFFCEL01

5: 433152 Mb o/192.168.10.3/DATA_XFF_CD_05_XFFCEL01

6: 433152 Mb o/192.168.10.3/DATA_XFF_CD_06_XFFCEL01

7: 433152 Mb o/192.168.10.3/DATA_XFF_CD_07_XFFCEL01

8: 433152 Mb o/192.168.10.3/DATA_XFF_CD_08_XFFCEL01

9: 433152 Mb o/192.168.10.3/DATA_XFF_CD_09_XFFCEL01

10: 433152 Mb o/192.168.10.3/DATA_XFF_CD_10_XFFCEL01

11: 433152 Mb o/192.168.10.3/DATA_XFF_CD_11_XFFCEL01

根据客户的反馈该磁盘组几乎全部被使用,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

2: 433152 Mb o/192.168.10.3/DATA_XFF_CD_01_XFFCEL01

3: 433152 Mb o/192.168.10.3/DATA_XFF_CD_02_XFFCEL01

4: 433152 Mb o/192.168.10.3/DATA_XFF_CD_03_XFFCEL01

5: 433152 Mb o/192.168.10.3/DATA_XFF_CD_04_XFFCEL01

6: 433152 Mb o/192.168.10.3/DATA_XFF_CD_05_XFFCEL01

7: 433152 Mb o/192.168.10.3/DATA_XFF_CD_06_XFFCEL01

8: 433152 Mb o/192.168.10.3/DATA_XFF_CD_07_XFFCEL01

9: 433152 Mb o/192.168.10.3/DATA_XFF_CD_08_XFFCEL01

10: 433152 Mb o/192.168.10.3/DATA_XFF_CD_09_XFFCEL01

11: 433152 Mb o/192.168.10.3/DATA_XFF_CD_10_XFFCEL01

12: 433152 Mb o/192.168.10.3/DATA_XFF_CD_11_XFFCEL01

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故障恢复,无法自行解决,需要恢复支持请联系我们

Phone:13429648788    Q Q:107644445070b0066bacfd9eecef93af3f89813bc.png    E-Mail:dba@xifenfei.com

码字仙子
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值