ORACLE 10G +Solaris 10
在增加磁盘组后出现。无法mount。而且无法删除。提示disk 重复。但是在asm_STRING中没有发现重复的连接;
那位给出个解决方案啊。。多谢!!
SQL> /
NAME VALUE
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
asm_diskstring /dev/rdsk/c0d1s*
asm_diskgroups
asm_power_limit 1
SQL> select * from v$asm_disk;
GROUP_NUMBER DISK_NUMBER COMPOUND_INDEX INCARNATION MOUNT_STATUS HEADER_STATUS MODE_STATUS STATE REDUNDANCY LIBRARY TOTAL_MB FREE_MB NAME FAILGROUP LABEL PATH UDID PRODUCT CREATE_DATE MOUNT_DATE REPAIR_TIMER READS WRITES READ_ERRS WRITE_ERRS READ_TIME WRITE_TIME BYTES_READ BYTES_WRITTEN
------------ ----------- -------------- ----------- ------------ ------------- ----------- -------- ---------- ---------------------------------------------------------------- ---------- ---------- ------------------------------ ------------------------------ ------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- -------------------------------- ----------- ----------- ------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------
0 0 0 0 CLOSED MEMBER ONLINE NORMAL UNKNOWN System 900 0 /dev/rdsk/c0d1s0 2008-8-30 2 2008-8-30 2 0
0 3 3 0 CLOSED MEMBER ONLINE NORMAL UNKNOWN System 900 0 /dev/rdsk/c0d1s4 2008-8-30 2 2008-8-30 2 0
0 2 2 0 CLOSED MEMBER ONLINE NORMAL UNKNOWN System 900 0 /dev/rdsk/c0d1s3 2008-8-30 2 2008-8-30 2 0
0 1 1 0 CLOSED MEMBER ONLINE NORMAL UNKNOWN System 900 0 /dev/rdsk/c0d1s1 2008-8-30 2 2008-8-30 2 0
SQL> select * from v$asm_diskgroup;
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS UNBALANCED COMPATIBILITY DATABASE_COMPATIBILITY
------------ ------------------------------ ----------- ---------- -------------------- ----------- ------ ---------- ---------- ----------------------- -------------- ------------- ---------- ------------------------------------------------------------ ------------------------------------------------------------
0 DATA1 512 4096 1048576 DISMOUNTED 0 0 0 0 0 N 0.0.0.0.0 0.0.0.0.0
SQL> alter diskgroup data1 mount;
alter diskgroup data1 mount
ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 2
SQL> drop diskgroup data1;
drop diskgroup data1
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "DATA1" does not exist or is not mounted
=======================
# cd /dev/rdsk/
# pwd
/dev/rdsk
# ls -l c0d1s0 c0d1s1 c0d1s3 c0d1s4
lrwxrwxrwx 1 oracle dba 54 Aug 26 22:15 c0d1s0 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:a,raw
lrwxrwxrwx 1 oracle dba 54 Aug 26 22:15 c0d1s1 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:b,raw
lrwxrwxrwx 1 oracle dba 54 Aug 26 22:15 c0d1s3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:d,raw
lrwxrwxrwx 1 oracle dba 54 Aug 26 22:15 c0d1s4 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:e,raw
# ls -l ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:a,raw
crw-rw---- 1 oracle dba 102, 64 Aug 30 21:56 ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:a,raw
# ls -l ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:b,raw
crw-rw---- 1 oracle dba 102, 65 Aug 30 21:57 ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:b,raw
# ls -l ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:d,raw
crw-rw---- 1 oracle dba 102, 67 Aug 30 21:57 ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:d,raw
# ls -l ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:e,raw
crw-rw---- 1 oracle dba 102, 68 Aug 30 21:57 ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:e,raw