- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 23:07:26
|
查看: 1813 |
回复: 1
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里面查找的时候,却显示不出来
[root@rac1 ~]# /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
[crsora@rac1 lib]$ 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[0]: 1263749444 ; 0x008: 0x4b534944
kfdhdb.driver.reserved[1]: 13121 ; 0x00c: 0x00003341
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]: 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]: 0 ; 0x0d8: 0x0000
kfdhdb.redomirrors[1]: 0 ; 0x0da: 0x0000
kfdhdb.redomirrors[2]: 0 ; 0x0dc: 0x0000
kfdhdb.redomirrors[3]: 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]: 0 ; 0x0ec: 0x00000000
kfdhdb.ub4spare[1]: 0 ; 0x0f0: 0x00000000
kfdhdb.ub4spare[2]: 0 ; 0x0f4: 0x00000000
kfdhdb.ub4spare[3]: 0 ; 0x0f8: 0x00000000
kfdhdb.ub4spare[4]: 0 ; 0x0fc: 0x00000000
kfdhdb.ub4spare[5]: 0 ; 0x100: 0x00000000
kfdhdb.ub4spare[6]: 0 ; 0x104: 0x00000000 |
|