This content has been marked as final. Show 5 replies
And wait finish the ASM operation
SQL> select group_number,name from v$asm_diskgroup; GROUP_NUMBER NAME -------------------------- ---------- 1 DATA SQL> select path,name from v$asm_disk where group_number=1; PATH NAME — /dev/raw/raw5 DATA_01 /dev/raw/raw6 DATA_02 SQL> alter diskgroup DATA drop disk DATA_01; Diskgroup altered.
To do this, your diskgroup need be external type redundancy.
SQL> select * from v$asm_operation; GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ------------ ----- ---- ----- ----- ------ ------- ---------- ---------- 1 REBAL RUN 1 1 100 42234 1007 41
Edited by: Flávio Soares on Jan 8, 2013 10:33 AM
Thanks for reply.
Shall I do it in one node or both node?
Since I am using two node RAC ASM and external redundancy.
you need to drop it from one node only.1 person found this helpful
during drop disk oracle will move all data from this disk into 1st available disk if it can't then you will not able to drop this disk.
Yes .1 person found this helpful
you can do that at one node , but pls ensure remain disks have enough space for all contents of database.
What type of redundancy do you have configured for your disks? There is a difference with how Oracle places files on the disks if the diskgroup is configured with normal/high redundancy or if it is configured with external redundancy? You can find that out by using the script below:
select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB,USABLE_FILE_MB,OFFLINE_DISKS,DATABASE_COMPATIBILITY from V$ASM_DISKGROUP order by 1
or you can use the following to get the disks associated with a particular diskgroup
set verify off
set verify off
set line 950
col GRP_NUM format a5
col DSK_NUM format a5
col PATH format a50
col NAME format a22
col TOTAL_MB heading 'TOTAL(MB)' format 9,999,999
col FREE_MB heading 'FREE(MB)' format 9,999,999
set pagesize 999
select to_char(GROUP_NUMBER) GRP_NUM,to_char(disk_number) DSK_NUM,MOUNT_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH from V$ASM_DISK
where GROUP_NUMBER in(select GROUP_NUMBER from V$ASM_DISKGROUP
where NAME = upper('&Disk_Group_Name'))
order by 1,2;