删除asmlib磁盘导致磁盘组故障恢复---惜分飞

Tue Nov 26 16:44:04 2024

SQL> alter diskgroup data drop disk DATA_0008

NOTE: GroupBlock outside rolling migration privileged region

Tue Nov 26 08:44:05 2024

NOTE: stopping process ARB0

NOTE: rebalance interrupted for group 2/0x28dec0d5 (DATA)

NOTE: requesting all-instance membership refresh for group=2

NOTE: membership refresh pending for group 2/0x28dec0d5 (DATA)

Tue Nov 26 08:44:14 2024

GMON querying group 2 at 48 for pid 18, osid 27385

SUCCESS: refreshed membership for 2/0x28dec0d5 (DATA)

SUCCESS: alter diskgroup data drop disk DATA_0008

NOTE: starting rebalance of group 2/0x28dec0d5 (DATA) at power 2

Starting background process ARB0

Tue Nov 26 08:44:14 2024

ARB0 started with pid=38, OS id=56987

NOTE: assigning ARB0 to group 2/0x28dec0d5 (DATA) with 2 parallel I/Os

Tue Nov 26 08:44:17 2024

NOTE: Attempting voting file refresh on diskgroup DATA

NOTE: Refresh completed on diskgroup DATA. No voting file found.

Tue Nov 26 08:44:57 2024

cellip.ora not found.

Tue Nov 26 17:08:46 2024

SQL> alter diskgroup data drop disk DATA_0008

ORA-15032: not all alterations performed

ORA-15071: ASM disk "DATA_0008" is already being dropped

ERROR: alter diskgroup data drop disk DATA_0008

Tue Nov 26 17:10:30 2024

SQL> alter diskgroup data drop disk DATA_0008

ORA-15032: not all alterations performed

ORA-15071: ASM disk "DATA_0008" is already being dropped

ERROR: alter diskgroup data drop disk DATA_0008

Tue Nov 26 09:34:38 2024

WARNING: cache read  a corrupt block:group=2(DATA) dsk=8 blk=98 disk=8 (DATA_0008) incarn=3911069755 au=0 blk=98 count=1

Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_56987.trc:

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

NOTE: a corrupted block from group DATA was dumped to /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_56987.trc

WARNING:cache read (retry) a corrupt block:group=2(DATA) dsk=8 blk=98 disk=8(DATA_0008)incarn=3911069755 au=0 blk=98 count=1

Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_56987.trc:

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

ERROR: cache failed to read group=2(DATA) dsk=8 blk=98 from disk(s): 8(DATA_0008)

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

NOTE: cache initiating offline of disk 8 group DATA

NOTE: process _arb0_+asm1(56987)initiating offline of disk 8.3911069755 (DATA_0008) with mask 0x7e in group 2

NOTE: initiating PST update: grp = 2, dsk = 8/0xe91e303b, mask = 0x6a, op = clear

Tue Nov 26 09:34:38 2024

GMON updating disk modes for group 2 at 49 for pid 38, osid 56987

ERROR: Disk 8 cannot be offlined, since diskgroup has external redundancy.

ERROR: too many offline disks in PST (grp 2)

Tue Nov 26 09:34:38 2024

NOTE: cache dismounting (not clean) group 2/0x28DEC0D5 (DATA)

WARNING: Offline for disk DATA_0008 in mode 0x7f failed.

NOTE: messaging CKPT to quiesce pins Unix process pid: 89645, image: oracle@ahptdb5 (B000)

Tue Nov 26 09:34:38 2024

NOTE: halting all I/Os to diskgroup 2 (DATA)

Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_56987.trc  (incident=413105):

ORA-15335: ASM metadata corruption detected in disk group 'DATA'

ORA-15130: diskgroup "DATA" is being dismounted

ORA-15066: offlining disk "DATA_0008" in group "DATA" may result in a data loss

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

Tue Nov 26 09:34:39 2024

ERROR: ORA-15130 in COD recovery for diskgroup 2/0x28dec0d5 (DATA)

ERROR: ORA-15130 thrown in RBAL for group number 2

Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_rbal_27385.trc:

ORA-15130: diskgroup "DATA" is being dismounted

ERROR: ORA-15335 thrown in ARB0 for group number 2

Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_56987.trc:

ORA-15335: ASM metadata corruption detected in disk group 'DATA'

ORA-15130: diskgroup "DATA" is being dismounted

ORA-15066: offlining disk "DATA_0008" in group "DATA" may result in a data loss

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [98] [0 != 1]

NOTE: stopping process ARB0

Tue Nov 26 09:34:40 2024

NOTE: LGWR doing non-clean dismount of group 2 (DATA)

NOTE: LGWR sync ABA=716.2684 last written ABA 716.2684

SQL> alter diskgroup data mount

NOTE: cache registered group DATA number=2 incarn=0x73bec220

NOTE: cache began mount (first) of group DATA number=2 incarn=0x73bec220

NOTE: Assigning number (2,16) to disk (/dev/oracleasm/disks/DATA208)

NOTE: Assigning number (2,15) to disk (/dev/oracleasm/disks/DATA207)

NOTE: Assigning number (2,14) to disk (/dev/oracleasm/disks/DATA206)

NOTE: Assigning number (2,13) to disk (/dev/oracleasm/disks/DATA205)

NOTE: Assigning number (2,12) to disk (/dev/oracleasm/disks/DATA204)

NOTE: Assigning number (2,11) to disk (/dev/oracleasm/disks/DATA203)

NOTE: Assigning number (2,10) to disk (/dev/oracleasm/disks/DATA202)

NOTE: Assigning number (2,9) to disk (/dev/oracleasm/disks/DATA201)

NOTE: Assigning number (2,6) to disk (/dev/oracleasm/disks/DATA07)

NOTE: Assigning number (2,5) to disk (/dev/oracleasm/disks/DATA06)

NOTE: Assigning number (2,4) to disk (/dev/oracleasm/disks/DATA05)

NOTE: Assigning number (2,0) to disk (/dev/oracleasm/disks/DATA01)

NOTE: Assigning number (2,3) to disk (/dev/oracleasm/disks/DATA04)

NOTE: Assigning number (2,2) to disk (/dev/oracleasm/disks/DATA03)

NOTE: Assigning number (2,1) to disk (/dev/oracleasm/disks/DATA02)

NOTE: Assigning number (2,8) to disk (/dev/oracleasm/disks/DATA101)

Tue Nov 26 11:48:22 2024

NOTE: GMON heartbeating for grp 2

GMON querying group 2 at 83 for pid 27, osid 15781

NOTE: cache opening disk 0 of grp 2: DATA_0000 path:/dev/oracleasm/disks/DATA01

NOTE: F1X0 found on disk 0 au 2 fcn 0.127835487

NOTE: cache opening disk 1 of grp 2: DATA_0001 path:/dev/oracleasm/disks/DATA02

NOTE: cache opening disk 2 of grp 2: DATA_0002 path:/dev/oracleasm/disks/DATA03

NOTE: cache opening disk 3 of grp 2: DATA_0003 path:/dev/oracleasm/disks/DATA04

NOTE: cache opening disk 4 of grp 2: DATA_0004 path:/dev/oracleasm/disks/DATA05

NOTE: cache opening disk 5 of grp 2: DATA_0005 path:/dev/oracleasm/disks/DATA06

NOTE: cache opening disk 6 of grp 2: DATA_0006 path:/dev/oracleasm/disks/DATA07

NOTE: cache opening disk 8 of grp 2: DATA_0008 path:/dev/oracleasm/disks/DATA101

NOTE: cache opening disk 9 of grp 2: DATA_0009 path:/dev/oracleasm/disks/DATA201

NOTE: cache opening disk 10 of grp 2: DATA_0010 path:/dev/oracleasm/disks/DATA202

NOTE: cache opening disk 11 of grp 2: DATA_0011 path:/dev/oracleasm/disks/DATA203

NOTE: cache opening disk 12 of grp 2: DATA_0012 path:/dev/oracleasm/disks/DATA204

NOTE: cache opening disk 13 of grp 2: DATA_0013 path:/dev/oracleasm/disks/DATA205

NOTE: cache opening disk 14 of grp 2: DATA_0014 path:/dev/oracleasm/disks/DATA206

NOTE: cache opening disk 15 of grp 2: DATA_0015 path:/dev/oracleasm/disks/DATA207

NOTE: cache opening disk 16 of grp 2: DATA_0016 path:/dev/oracleasm/disks/DATA208

NOTE: cache mounting (first) external redundancy group 2/0x73BEC220 (DATA)

Tue Nov 26 11:48:22 2024

* allocate domain 2, invalid = TRUE

kjbdomatt send to inst 2

Tue Nov 26 11:48:22 2024

NOTE: attached to recovery domain 2

NOTE: starting recovery of thread=1 ckpt=716.1536 group=2 (DATA)

NOTE: starting recovery of thread=2 ckpt=763.6248 group=2 (DATA)

NOTE: recovery initiating offline of disk 8 group 2 (*)

NOTE: cache initiating offline of disk 8 group DATA

NOTE: process _user15781_+asm1 (15781) initiating offline of disk 8.3911069996 (DATA_0008) with mask 0x7e in group 2

NOTE: initiating PST update: grp = 2, dsk = 8/0xe91e312c, mask = 0x6a, op = clear

GMON updating disk modes for group 2 at 84 for pid 27, osid 15781

ERROR: Disk 8 cannot be offlined, since diskgroup has external redundancy.

ERROR: too many offline disks in PST (grp 2)

WARNING: Offline for disk DATA_0008 in mode 0x7f failed.

Tue Nov 26 11:48:23 2024

NOTE: halting all I/Os to diskgroup 2 (DATA)

NOTE: recovery (pass 2) of diskgroup 2 (DATA) caught error ORA-15130

Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_15781.trc:

ORA-15130: diskgroup "DATA" is being dismounted

ORA-15066: offlining disk "DATA_0008" in group "DATA" may result in a data loss

ORA-15131: block 97 of file 8 in diskgroup 2 could not be read

ORA-15196: invalid ASM block header [kfc.c:7600] [endian_kfbh] [2147483656] [97] [0 != 1]