A question when adding ASM disk to diskgroup?
s9225Apr 12 2008 — edited Apr 13 2008Hi,
1. when I
alter diskgroup DATA add failgroup FG3 disk 'ORCL:VOL3' name VOL3;
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15010: name is already used by an existing ASM disk
so.
when I run this query in the ASM instance, I saw that name (VOL3) is already existed and mount_status is missing.
0 1 CACHED D1A FG1 ORCL:VOL
DISK_NUMBER GROUP_NUMBER MOUNT_S NAME FAILGROUP PATH
----------- ------------ ------- ------ ------------------------------ --------
1
1 1 CACHED D1B FG2 ORCL:VOL
2
3 1 MISSING VOL3
2 1 MISSING VOL4
then I want to drop it....
SQL> ALTER DISKGROUP DATA DROP DISK VOL3;
ALTER DISKGROUP DATA DROP DISK VOL3
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15071: ASM disk "VOL3" is already being dropped
so How can I do???
OR
even I don't drop it, and just change name, like
SQL> alter diskgroup DATA add failgroup FG3 disk 'ORCL:VOL3' name V3;
alter diskgroup DATA add failgroup FG3 disk 'ORCL:VOL3' name V3
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15033: disk 'ORCL:VOL3' belongs to diskgroup "DATA"
I still can not pass through?
can you help me a solution?
thank you very much in advance.