- 论坛徽章:
- 1
|
我的ASM实例有两个diskgroup是diskmount状态。在删除时报错。
SQL> select group_number,name,type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ --------------- ------------ ---------- ----------
1 A1 EXTERN 4096 3213
2 A2 EXTERN 8192 7947
0 DGROUP2 0 0
0 DGROUP1 0 0
SQL> select a.name,b.group_number,b.path from v$asm_disk b,v$asm_diskgroup a
2 where a.group_number=b.group_number
3 order by 1
4 /
NAME GROUP_NUMBER PATH
--------------- ------------ ------------------------------
A1 1 /dev/rasm11
A1 1 /dev/rasm12
A2 2 /dev/rasm1
A2 2 /dev/rasm2
DGROUP1 0 /dev/rasm6
DGROUP1 0 /dev/rasm10
DGROUP1 0 /dev/rasm9
DGROUP1 0 /dev/rasm5
DGROUP1 0 /dev/rasm4
DGROUP1 0 /dev/rasm3
DGROUP1 0 /dev/rasm8
NAME GROUP_NUMBER PATH
--------------- ------------ ------------------------------
DGROUP1 0 /dev/rasm7
DGROUP2 0 /dev/rasm7
DGROUP2 0 /dev/rasm3
DGROUP2 0 /dev/rasm4
DGROUP2 0 /dev/rasm5
DGROUP2 0 /dev/rasm6
DGROUP2 0 /dev/rasm10
DGROUP2 0 /dev/rasm9
DGROUP2 0 /dev/rasm8
20 rows selected.
SQL> select GROUP_NUMBER,NAME,TOTAL_MB,STATE from v$asm_diskgroup;
GROUP_NUMBER NAME TOTAL_MB STATE
------------ --------------- ---------- ----------------------
1 A1 4096 MOUNTED
2 A2 8192 MOUNTED
0 DGROUP2 0 DISMOUNTED
0 DGROUP1 0 DISMOUNTED
SQL> alter diskgroup DGROUP1 mount;
alter diskgroup DGROUP1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 1
SQL> drop diskgroup DGROUP1;
drop diskgroup DGROUP1
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "DGROUP1" does not exist or is not mounted
使用dd清除后,还报如下错误:
SQL> alter diskgroup DGROUP1 add disk '/dev/rasm4' name a1;
alter diskgroup DGROUP1 add disk '/dev/rasm4' name a1
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15001: diskgroup "DGROUP1" does not exist or is not mounted
SQL> drop diskgroup dgroup1;
drop diskgroup dgroup1
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "DGROUP1" does not exist or is not mounted
SQL> alter diskgroup dgroup1 mount;
alter diskgroup dgroup1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DGROUP1" |
|