ORACLE ASM 磁盘组找不到 ora-15032 15050 15042
ERROR at line 1:ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "8" is missing
1* select group_number,name,path from v$asm_disk
SQL> /
GROUP_NUMBER NAME PATH
------------ --------------- ---------------
0 /dev/raw/raw6
0 /dev/raw/raw4
0 ORCLISKB1
0 ORCLISKA7
0 ORCLISKA6
0 ORCLISKA5
0 ORCLISKA4
0 ORCLISKA3
0 /dev/raw/raw1
0 /dev/raw/raw5
0 /dev/raw/raw3
GROUP_NUMBER NAME PATH
------------ --------------- ---------------
0 /dev/raw/raw2
0 ORCLISKA1
0 ORCLISKA2
3 DISKB2 ORCLISKB2
3 DISKB3 ORCLISKB3
3 DISKB4 ORCL:DISKB4
3 DISKB5 ORCL:DISKB5
3 DISKB6 ORCL:DISKB6
3 DISKB7 ORCL:DISKB7
2 EBSTEST ORCL:EBSTEST
21 rows selected.
SQL> select group_number, name from v$asm_diskgroup;
GROUP_NUMBER NAME
------------ ------------------------------------------------------------
0 DATA_DG
2 EBSTEST
3 LOG_DG
查看的时候，又有，但是在ASM里面查找的时候，却显示不出来
# /etc/init.d/oracleasm listdisks
DISKA1
DISKA2
DISKA3
DISKA4
DISKA5
DISKA6
DISKA7
DISKB1
DISKB2
DISKB3
DISKB4
DISKB5
DISKB6
DISKB7
EBSTEST
DISK_NUMBER PATH NAME
----------- --------------- ---------------
0 /dev/raw/raw6
1 /dev/raw/raw4
13 ORCLISKB1
12 ORCLISKA7
11 ORCLISKA6
10 ORCLISKA5
9 ORCLISKA4
8 ORCLISKA3
2 /dev/raw/raw1
3 /dev/raw/raw5
4 /dev/raw/raw3
DISK_NUMBER PATH NAME
----------- --------------- ---------------
5 /dev/raw/raw2
6 ORCLISKA1
7 ORCLISKA2
0 ORCLISKB2 DISKB2
1 ORCLISKB3 DISKB3
2 ORCL:DISKB4 DISKB4
3 ORCL:DISKB5 DISKB5
4 ORCL:DISKB6 DISKB6
5 ORCL:DISKB7 DISKB7
0 ORCL:EBSTEST EBSTEST
$ kfed read /dev/oracleasm/disks/DISKA3
kfbh.endian: 1 ; 0x000: 0x01
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: 2147483650 ; 0x008: TYPE=0x8 NUMB=0x2
kfbh.check: 2115766098 ; 0x00c: 0x7e1c0752
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKDISKA3 ; 0x000: length=14
kfdhdb.driver.reserved: 1263749444 ; 0x008: 0x4b534944
kfdhdb.driver.reserved: 13121 ; 0x00c: 0x00003341
kfdhdb.driver.reserved: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 168820736 ; 0x020: 0x0a100000
kfdhdb.dsknum: 2 ; 0x024: 0x0002
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: DISKA3 ; 0x028: length=6
kfdhdb.grpname: DATA_DG ; 0x048: length=7
kfdhdb.fgname: DISKA3 ; 0x068: length=6
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32951153 ; 0x0a8: HOUR=0x11 DAYS=0x1b MNTH=0x2 YEAR=0x7db
kfdhdb.crestmp.lo: 3603957760 ; 0x0ac: USEC=0x0 MSEC=0x2 SECS=0x2d MINS=0x35
kfdhdb.mntstmp.hi: 32958795 ; 0x0b0: HOUR=0xb DAYS=0xa MNTH=0xa YEAR=0x7db
kfdhdb.mntstmp.lo: 3770122240 ; 0x0b4: USEC=0x0 MSEC=0x1e0 SECS=0xb MINS=0x38
kfdhdb.secsize: 512 ; 0x0b8: 0x0200
kfdhdb.blksize: 4096 ; 0x0ba: 0x1000
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize: 7820 ; 0x0c4: 0x00001e8c
kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002
kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001
kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn: 0 ; 0x0d4: 0x00000000
kfdhdb.redomirrors: 0 ; 0x0d8: 0x0000
kfdhdb.redomirrors: 0 ; 0x0da: 0x0000
kfdhdb.redomirrors: 0 ; 0x0dc: 0x0000
kfdhdb.redomirrors: 0 ; 0x0de: 0x0000
kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000
kfdhdb.grpstmp.hi: 32951153 ; 0x0e4: HOUR=0x11 DAYS=0x1b MNTH=0x2 YEAR=0x7db
kfdhdb.grpstmp.lo: 3603701760 ; 0x0e8: USEC=0x0 MSEC=0x308 SECS=0x2c MINS=0x35
kfdhdb.ub4spare: 0 ; 0x0ec: 0x00000000
kfdhdb.ub4spare: 0 ; 0x0f0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x0f4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x0f8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x0fc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x100: 0x00000000
kfdhdb.ub4spare: 0 ; 0x104: 0x00000000
SQL> alter diskgroup data_dg mount
Mon Jul 02 14:42:11 CST 2012
NOTE: cache registered group DATA_DG number=1 incarn=0xff986037
Mon Jul 02 14:42:11 CST 2012
NOTE: Hbeat: instance first (grp 1)
Mon Jul 02 14:42:16 CST 2012
NOTE: start heartbeating (grp 1)
Mon Jul 02 14:42:16 CST 2012
NOTE: cache dismounting group 1/0xFF986037 (DATA_DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup DATA_DG was not mounted
但是挂载的时候挂不上啊
页:
[1]