关于磁盘组扩容问题的咨询吗

linloosen

我在做上述实验时因敲错了个单词，造成无法完成磁盘组扩容，烦请帮忙解决！
SQL> alter diskgroup data add failgroup fg1 disk
  2  '/dev/oracleasm/disks/DISK6' name fg1d1,
  3  '/dev/oracleasm/disks/DISK7' name fg1d2
  4  failgroup fg2 disk
  5  '/dev/oracleasm/disks/DISK8' name fg2d1,
  6  '/dev/oracleasm/disks/DIKS9' name fg2d2 rebalance power 11;
alter diskgroup data add failgroup fg1 disk
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15031: disk specification '/dev/oracleasm/disks/DIKS9' matches no disks

在/dev/oracleasm/disks/里标签是DISK9，我敲成DIKS9报错，重新输入如下：
SQL> alter diskgroup data add failgroup fg1 disk
  2  '/dev/oracleasm/disks/DISK6' name fg1d1,
  3  '/dev/oracleasm/disks/DISK7' name fg1d2
  4   failgroup fg2 disk
  5  '/dev/oracleasm/disks/DISK8' name fg2d1,
  6  '/dev/oracleasm/disks/DISK9' name fg2d2 rebalance power 11;
alter diskgroup data add failgroup fg1 disk
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15020: discovered duplicate ASM disk "FG2D2"



已度娘找不到解决方法，机器 重启过了执行上面命令还是报同样错。想不到解决办法特来此求教！

botang

dd掉重新添加

linloosen

botang 发表于 2015-7-23 08:58
dd掉重新添加

报错了还是不行！详见如下附件！
[root@station69 ~]# dd if=/dev/zero of=DISK6.img bs=1G count=3  
3+0 records in
3+0 records out
3221225472 bytes (3.2 GB) copied, 109.514 seconds, 29.4 MB/s
[root@station69 ~]# losetup /dev/loop0 DISK6.img
[root@station69 ~]# losetup /dev/loop0
/dev/loop0: [fd00]:13566061 (DISK6.img)
[root@station69 ~]# oracleasm createdisk DISK6 /dev/loop0
Writing disk header: done
Instantiating disk: done
[root@station69 ~]# oracleasm createdisk DISK6 /dev/loop0
Device "/dev/loop0" is already labeled for ASM disk "DISK6"
[root@station69 ~]# dd if=/dev/zero of=DISK7.img bs=1G count=3;
losetup /dev/loop1 DISK7.img;
losetup /dev/loop1;3+0 records in
3+0 records out
3221225472 bytes (3.2 GB) copied, 43.5148 seconds, 74.0 MB/s
[root@station69 ~]# losetup /dev/loop1 DISK7.img;
[root@station69 ~]# losetup /dev/loop1;
/dev/loop1: [fd00]:3309569 (DISK7.img)
[root@station69 ~]# oracleasm createdisk DISK7 /dev/loop1
Writing disk header: done
Instantiating disk: done
[root@station69 ~]# dd if=/dev/zero of=DISK8.img bs=1G count=3;
losetup /dev/loop2 DISK8.img;
losetup /dev/loop2;
oracleasm createdisk DISK8 /dev/loop23+0 records in
3+0 records out
3221225472 bytes (3.2 GB) copied, 40.7093 seconds, 79.1 MB/s
[root@station69 ~]# losetup /dev/loop2 DISK8.img;
[root@station69 ~]# losetup /dev/loop2;
/dev/loop2: [fd00]:3309570 (DISK8.img)
[root@station69 ~]# oracleasm createdisk DISK8 /dev/loop2
Writing disk header: done
Instantiating disk: done
[root@station69 ~]# dd if=/dev/zero of=DISK9.img bs=1G count=3;
losetup /dev/loop3 DISK9.img;
losetup /dev/loop3;
oracleasm createdisk DISK9 /dev/loop3;

dd if=/dev/zero of=DISK10.img bs=1G count=6;
losetup /dev/loop4 DISK10.img;
losetup /dev/loop4;
oracleasm createdisk DISK10 /dev/loop43+0 records in
3+0 records out
3221225472 bytes (3.2 GB) copied, 41.0667 seconds, 78.4 MB/s
[root@station69 ~]# losetup /dev/loop3 DISK9.img;
[root@station69 ~]# losetup /dev/loop3;
/dev/loop3: [fd00]:3309571 (DISK9.img)
[root@station69 ~]# oracleasm createdisk DISK9 /dev/loop3;
Writing disk header: done
Instantiating disk: done
[root@station69 ~]#
[root@station69 ~]# dd if=/dev/zero of=DISK10.img bs=1G count=6;
6+0 records in
6+0 records out
6442450944 bytes (6.4 GB) copied, 172.798 seconds, 37.3 MB/s
[root@station69 ~]# losetup /dev/loop4 DISK10.img;
[root@station69 ~]# losetup /dev/loop4;
/dev/loop4: [fd00]:3309572 (DISK10.img)
[root@station69 ~]# oracleasm createdisk DISK10 /dev/loop4
Writing disk header: done
Instantiating disk: done

[oracle@station69 ~]$ . oraenv
ORACLE_SID = [orcl] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
[oracle@station69 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 23 10:45:17 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysasm
Connected.
SQL> alter diskgroup data add failgroup fg1 disk
  2  '/dev/oracleasm/disks/DISK6' name fg1d1,
  3  '/dev/oracleasm/disks/DISK7' name fg1d2
  4  failgroup fg2 disk
  5  '/dev/oracleasm/disks/DISK8' name fg2d1,
  6  '/dev/oracleasm/disks/DISK9' name fg2d2 rebalance power 11;
alter diskgroup data add failgroup fg1 disk
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15020: discovered duplicate ASM disk "FG2D2"