Post date: 22-May-2009 14:25:20
Disk Group Configuration Before Start of the change :
ASMCMD> lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED NORMAL N N 1024 4096 1048576 511920 511634 102384 204625 0 DGNEW/
select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,REDUNDANCY,TOTAL_MB,NAME,PATH from v$asm_disk
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS MODE_STATUS STATE REDUNDANCY TOTAL_MB NAME
------------ ----------- --------------------- ------------------------------------ --------------------- ------------------------ --------------------- ---------- ------------------------------------------------------------------------------------------
PATH
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0 0 CLOSED MEMBER ONLINE NORMAL UNKNOWN 102384
/dev/raw/raw_asm7
1 1 CACHED MEMBER ONLINE NORMAL UNKNOWN 102384 DGNEW_0001
/dev/raw/raw_asm8
1 2 CACHED MEMBER ONLINE NORMAL UNKNOWN 102384 DGNEW_0002
/dev/raw/raw_asm9
1 3 CACHED MEMBER ONLINE NORMAL UNKNOWN 102384 DGNEW_0003
/dev/raw/raw_asm14
1 4 CACHED MEMBER ONLINE NORMAL UNKNOWN 102384 DGNEW_0004
/dev/raw/raw_asm15
1 5 CACHED MEMBER ONLINE NORMAL UNKNOWN 102384 DGNEW_0005
/dev/raw/raw_asm16
SQL> drop diskgroup DGNEW including contents;
Diskgroup dropped.
. asmtier
sqlplus "/ as sysdba"
startup nomount
sqlplus > select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,REDUNDANCY,TOTAL_MB,NAME,PATH from v$asm_disk
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS MODE_STATUS STATE REDUNDANCY TOTAL_MB NAME
------------ ----------- --------------------- ------------------------------------ --------------------- ------------------------ --------------------- ---------- ------------------------------------------------------------------------------------------
PATH
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0 0 CLOSED MEMBER ONLINE NORMAL UNKNOWN 102384
/dev/raw/raw_asm7
0 1 CLOSED FORMER ONLINE NORMAL UNKNOWN 102384
/dev/raw/raw_asm8
0 5 CLOSED FORMER ONLINE NORMAL UNKNOWN 102384
/dev/raw/raw_asm16
0 3 CLOSED FORMER ONLINE NORMAL UNKNOWN 102384
/dev/raw/raw_asm14
0 4 CLOSED FORMER ONLINE NORMAL UNKNOWN 102384
/dev/raw/raw_asm15
0 2 CLOSED FORMER ONLINE NORMAL UNKNOWN 102384
/dev/raw/raw_asm9
6 rows selected.
Normally the above select should not return any rows as the diskgroup was dropped.
sqlplus > create diskgroup DGNEW external redundancy disk '/dev/raw/raw_asm7','/dev/raw/raw_asm8','/dev/raw/raw_asm9','/dev/raw/raw_asm14','/dev/raw/raw_asm15','/dev/raw/raw_asm16';
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15033: disk '/dev/raw/raw_asm7' belongs to diskgroup "DGNEW"
create diskgroup DGNEW external redundancy disk '/dev/raw/raw_asm8','/dev/raw/raw_asm9','/dev/raw/raw_asm14','/dev/raw/raw_asm15','/dev/raw/raw_asm16';
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
At this point it was not possible to even drop this rouge diskgroup and disks forcibly as they were not mounted. Attempt to mount was failed
with following error:
sqlplus > alter diskgroup DGNEW mount;
*
Error at line 1:
ORA-15017: diskgroup cannot be mounted
sqlplus > create diskgroup TEST_DG external redundancy disk '/dev/raw/raw_asm7' FORCE;
Diskgroup created.
sqlplus > shutdown immediate;
sqlplus > startup nomount;
sqlplus > alter diskgroup TEST_DG mount;
sqlplus > drop diskgroup TEST_DG including contents;
sqlplus > shutdown immediate;
sqlplus > startup nomount;
sqlplus > create diskgroup DGNEW external redundancy disk '/dev/raw/raw_asm7','/dev/raw/raw_asm8','/dev/raw/raw_asm9','/dev/raw/raw_asm14','/dev/raw/raw_asm15','/dev/raw/raw_asm16';
Diskgroup created.
:)