How to Drop disk from existing ASM disk group
Dropping Disks from an existing DISK group :
When a disk is dropped. The disk group is re balanced by moving all the file extents from the dropped disk to other disks in the disk group .A drop disk operation will fail if not enough space is available on the other disk.Data will not be lost by dropping a disk . By default the alter disk group …. Drop disk statement returns before the drop and re balances operations are complete.Do not reuse,remove or disconnect the dropped disk until the HEADER_STATUS column for this disk in the v$ASM_DISK view changes to FORMER.You can query the v$ASM_OPERATION view to determine the amount of the time remaining for the drop/rebalance operation to complete .
DISK_GROUP_NAME DISK_FILE_PATH DISK_FILE_NAME DISK_FILE_FAIL_GROUP HEADER_STATU
-------------------- ------------------------- ------------------------------ ------------------------------ ------------
DATA ORCL:DATA1 DATA1 DATA1 MEMBER
DATA ORCL:DATA3 DATA3 DATA3 MEMBER
DATA ORCL:DATA2 DATA2 DATA2 MEMBER
OCRVOTE ORCL:OCR_VOTE3 OCR_VOTE3 OCR_VOTE3 MEMBER
OCRVOTE ORCL:OCR_VOTE1 OCR_VOTE1 OCR_VOTE1 MEMBER
OCRVOTE ORCL:OCR_VOTE2 OCR_VOTE2 OCR_VOTE2 MEMBER
[CANDIDATE] ORCL:OCR_VOTE4 PROVISIONED
[CANDIDATE] ORCL:OCR_VOTE5 PROVISIONED
[CANDIDATE] ORCL:FRA3 PROVISIONED
[CANDIDATE] ORCL:FRA2 PROVISIONED
[CANDIDATE] ORCL:FRA1 FORMER
1) Drop the disk from existing disk group
Log-in to ASM instance
# sqlplus "/ as sysasm "
Use this commad to drop disk
alter diskgroup DATA drop disk FRA1 rebalance power 4;
2) Monitoring the Re-balancing operation
SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;
INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES
---------- ----- ---- ---------- ---------- ---------- ---------- -----------
2 REBAL RUN 4 3 1208 240 5
1 REBAL WAIT 4
3) Once disk it dropped then HEADER_STATUS cloumn it show FORMER status
set linesize 200
col DISK_GROUP_NAME format a20;
col DISK_FILE_PATH format a25;
SELECT
NVL(a.name, '[CANDIDATE]') disk_group_name
, b.path disk_file_path
, b.name disk_file_name
, b.failgroup disk_file_fail_group
,b.header_status
FROM
v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)
ORDER BY a.name;
DISK_GROUP_NAME DISK_FILE_PATH DISK_FILE_NAME DISK_FILE_FAIL_GROUP HEADER_STATU
-------------------- ------------------------- ------------------------------ ------------------------------ ------------
DATA ORCL:DATA1 DATA1 DATA1 MEMBER
DATA ORCL:DATA3 DATA3 DATA3 MEMBER
DATA ORCL:DATA2 DATA2 DATA2 MEMBER
OCRVOTE ORCL:OCR_VOTE3 OCR_VOTE3 OCR_VOTE3 MEMBER
OCRVOTE ORCL:OCR_VOTE1 OCR_VOTE1 OCR_VOTE1 MEMBER
OCRVOTE ORCL:OCR_VOTE2 OCR_VOTE2 OCR_VOTE2 MEMBER
[CANDIDATE] ORCL:OCR_VOTE4 PROVISIONED
[CANDIDATE] ORCL:OCR_VOTE5 PROVISIONED
[CANDIDATE] ORCL:FRA3 PROVISIONED
[CANDIDATE] ORCL:FRA2 PROVISIONED
[CANDIDATE] ORCL:FRA1 FORMER
Once Re-balancing is completed the gv$asm_operation shows no record found and also monitoring ASM alert log file .
==================================================================
dropping the disk in the diskgroup and asm instance alert output
Asm alert logfile location --- /u01/app/oracle/diag/asm/+asm/+ASM1/trace
alter diskgroup DATA drop disk FRA1 rebalance power 4
=========================================================================
Sat Mar 25 08:44:54 2017
SQL> alter diskgroup DATA drop disk FRA1 rebalance power 4
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=1
Sat Mar 25 08:44:56 2017
GMON updating for reconfiguration, group 1 at 12 for pid 28, osid 19375
NOTE: group 1 PST updated.
Sat Mar 25 08:44:56 2017
NOTE: membership refresh pending for group 1/0x34570003 (DATA)
GMON querying group 1 at 13 for pid 18, osid 8853
SUCCESS: refreshed membership for 1/0x34570003 (DATA)
SUCCESS: alter diskgroup DATA drop disk FRA1 rebalance power 4
NOTE: starting rebalance of group 1/0x34570003 (DATA) at power 4
Starting background process ARB0
Sat Mar 25 08:44:59 2017
ARB0 started with pid=34, OS id=24440
NOTE: assigning ARB0 to group 1/0x34570003 (DATA) with 4 parallel I/Os
cellip.ora not found.
Sat Mar 25 08:45:32 2017
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA. No voting file found.
Sat Mar 25 08:49:33 2017
NOTE: GroupBlock outside rolling migration privileged region
Sat Mar 25 08:49:33 2017
NOTE: stopping process ARB0
NOTE: requesting all-instance membership refresh for group=1
SUCCESS: rebalance completed for group 1/0x34570003 (DATA)
Sat Mar 25 08:49:36 2017
GMON updating for reconfiguration, group 1 at 14 for pid 29, osid 25054
NOTE: group 1 PST updated.
SUCCESS: grp 1 disk FRA1 emptied
NOTE: erasing header on grp 1 disk FRA1
NOTE: process _x000_+asm1 (25054) initiating offline of disk 3.3941069060 (FRA1) with mask 0x7e in group 1
NOTE: initiating PST update: grp = 1, dsk = 3/0xeae7f104, mask = 0x6a, op = clear
GMON updating disk modes for group 1 at 15 for pid 29, osid 25054
NOTE: PST update grp = 1 completed successfully
NOTE: initiating PST update: grp = 1, dsk = 3/0xeae7f104, mask = 0x7e, op = clear
GMON updating disk modes for group 1 at 16 for pid 29, osid 25054
NOTE: cache closing disk 3 of grp 1: FRA1
NOTE: PST update grp = 1 completed successfully
GMON updating for reconfiguration, group 1 at 17 for pid 29, osid 25054
NOTE: cache closing disk 3 of grp 1: (not open) FRA1
NOTE: group 1 PST updated.
NOTE: membership refresh pending for group 1/0x34570003 (DATA)
GMON querying group 1 at 18 for pid 18, osid 8853
GMON querying group 1 at 19 for pid 18, osid 8853
NOTE: Disk FRA1 in mode 0x0 marked for de-assignment
SUCCESS: refreshed membership for 1/0x34570003 (DATA)
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA. No voting file found.
=========================================================================
Thanks
Rajan
Comments
Post a Comment