Sunday, 5 October 2025

Oracle 19c RAC Database Drop LUN from Liunx OS (2 Node RAC)

 

---Drop Disk From ASM----

ALTER DISKGROUP RECO DROP DISK
RECO_0006
REBALANCE POWER 11;


ALTER DISKGROUP RECO DROP DISK
RECO_0005
REBALANCE POWER 11;


ALTER DISKGROUP RECO DROP DISK
RECO_0004
REBALANCE POWER 11


--------Check ASM and Disks--------

SQL> set linesize 132

set pagesize 100

col OS_DISK for a60SQL> SQL> 

SQL> select path "OS_DISK", OS_MB, total_mb, create_date, mount_date, mount_status, header_status "DISK TYPE" from v$asm_disk;


OS_DISK   OS_MB   TOTAL_MB CREATE_DA MOUNT_DAT MOUNT_S DISK TYPE

------------------------------------------------------------ ---------- ---------- --------- --------- ------- ------------

/dev/oracleasm/disks/RECO07 512000 0 04-JUL-24 10-MAR-25 CLOSED  FORMER

/dev/oracleasm/disks/RECO06 512000 0 04-JUL-24 10-MAR-25 CLOSED  FORMER

/dev/oracleasm/disks/RECO05 512000 0 04-JUL-24 10-MAR-25 CLOSED  FORMER

/dev/oracleasm/disks/DATA20 512000     512000 10-FEB-25 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA19 512000     512000 06-FEB-25 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA16 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/RECO04 512000     512000 04-JUL-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA13 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA04 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA03 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA15 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA05 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA06 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA14 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA11 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA17 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA08 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA10 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA02 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA07 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA18 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA09 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA01 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA12 512000     512000 18-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/RECO02 512000     512000 13-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/OCRVOTING 204800     204800 12-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/RECO03 512000     512000 13-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/RECO01 512000     512000 13-FEB-24 10-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA21 512000     512000 15-MAR-25 15-MAR-25 CACHED  MEMBER

/dev/oracleasm/disks/DATA22 512000     512000 26-MAY-25 26-MAY-25 CACHED  MEMBER


30 rows selected.


SQL> /


[grid@baprdg01 ~]$ asmcmd lsdsk -p -G RECO

Group_Num  Disk_Num      Incarn  Mount_Stat  Header_Stat  Mode_Stat  State   Path

        3         0  4041325915  CACHED      MEMBER       ONLINE     NORMAL  /dev/oracleasm/disks/RECO01

        3         1  4041325914  CACHED      MEMBER       ONLINE     NORMAL  /dev/oracleasm/disks/RECO02

        3         2  4041325913  CACHED      MEMBER       ONLINE     NORMAL  /dev/oracleasm/disks/RECO03

        3         3  4041325912  CACHED      MEMBER       ONLINE     NORMAL  /dev/oracleasm/disks/RECO04

[grid@baprdg01 ~]$ 


[grid@baprdg02 ~]$ asmcmd lsdsk -p -G RECO

Group_Num  Disk_Num      Incarn  Mount_Stat  Header_Stat  Mode_Stat  State   Path

        3         0  4042146510  CACHED      MEMBER       ONLINE     NORMAL  /dev/oracleasm/disks/RECO01

        3         1  4042146508  CACHED      MEMBER       ONLINE     NORMAL  /dev/oracleasm/disks/RECO02

        3         2  4042146509  CACHED      MEMBER       ONLINE     NORMAL  /dev/oracleasm/disks/RECO03

        3         3  4042146507  CACHED      MEMBER       ONLINE     NORMAL  /dev/oracleasm/disks/RECO04

[grid@baprdg02 ~]$ 


[root@baprdg02 ~]# blkid | grep RECO07

/dev/sdav: LABEL="RECO07" TYPE="oracleasm"

/dev/sdba: LABEL="RECO07" TYPE="oracleasm"

/dev/mapper/mpathy: LABEL="RECO07" TYPE="oracleasm"

/dev/sdcg: LABEL="RECO07" TYPE="oracleasm"

/dev/sddi: LABEL="RECO07" TYPE="oracleasm"

[root@baprdg02 ~]# 



[root@baprdg02 ~]# blkid | grep RECO07

/dev/sdav: LABEL="RECO07" TYPE="oracleasm"

/dev/sdba: LABEL="RECO07" TYPE="oracleasm"

/dev/mapper/mpathy: LABEL="RECO07" TYPE="oracleasm"

/dev/sdcg: LABEL="RECO07" TYPE="oracleasm"

/dev/sddi: LABEL="RECO07" TYPE="oracleasm"

[root@baprdg02 ~]# multipath -ll | grep mpathy

mpathy (36006016082734d006b398666a7a5f433) dm-19 DGC,VRAID

[root@baprdg02 ~]# blkid | grep RECO06

/dev/sdax: LABEL="RECO06" TYPE="oracleasm"

/dev/sdbc: LABEL="RECO06" TYPE="oracleasm"

/dev/mapper/mpathz: LABEL="RECO06" TYPE="oracleasm"

/dev/sdci: LABEL="RECO06" TYPE="oracleasm"

/dev/sddj: LABEL="RECO06" TYPE="oracleasm"

[root@baprdg02 ~]# multipath -ll | grep mpathz

mpathz (36006016082734d006b398666b750b455) dm-23 DGC,VRAID

[root@baprdg02 ~]# blkid | grep RECO05

/dev/sdaz: LABEL="RECO05" TYPE="oracleasm"

/dev/sdbe: LABEL="RECO05" TYPE="oracleasm"

/dev/mapper/mpathaa: LABEL="RECO05" TYPE="oracleasm"

/dev/sdck: LABEL="RECO05" TYPE="oracleasm"

/dev/sddk: LABEL="RECO05" TYPE="oracleasm"

[root@baprdg02 ~]# multipath -ll | grep mpathaa

mpathaa (36006016082734d006c398666fb34c371) dm-18 DGC,VRAID

[root@baprdg02 ~]# 


-----------------------------


[root@baprdg02 ~]# blkid | grep RECO07

/dev/sdav: LABEL="RECO07" TYPE="oracleasm"

/dev/sdba: LABEL="RECO07" TYPE="oracleasm"

/dev/mapper/mpathy: LABEL="RECO07" TYPE="oracleasm"

/dev/sdcg: LABEL="RECO07" TYPE="oracleasm"

/dev/sddi: LABEL="RECO07" TYPE="oracleasm"

[root@baprdg02 ~]# 




[root@baprdg01 ~]# dd if=/dev/zero of=/dev/mapper/mpathcz bs=1024 count=100

100+0 records in

100+0 records out

102400 bytes (102 kB, 100 KiB) copied, 0.00628071 s, 16.3 MB/s


[root@baprdg01 ~]# partprobe /dev/mapper/mpathcz


[root@baprdg01 ~]# oracleasm deletedisk -v RECO07

Disk "RECO07" defines an unmarked device

Dropping disk: done

[root@baprdg01 ~]# 



[root@baprdg01 ~]# blkid | grep RECO07

/dev/sdax: LABEL="RECO07" TYPE="oracleasm"

/dev/sday: LABEL="RECO07" TYPE="oracleasm"

/dev/sdci: LABEL="RECO07" TYPE="oracleasm"

/dev/sddi: LABEL="RECO07" TYPE="oracleasm"

[root@baprdg01 ~]# 


---------Node-2----------


[grid@baprdg02 ~]$ blkid | grep RECO07

/dev/sdav: LABEL="RECO07" TYPE="oracleasm"

/dev/sdba: LABEL="RECO07" TYPE="oracleasm"

/dev/mapper/mpathy: LABEL="RECO07" TYPE="oracleasm"

/dev/sdcg: LABEL="RECO07" TYPE="oracleasm"

/dev/sddi: LABEL="RECO07" TYPE="oracleasm"

[grid@baprdg02 ~]$ 


[root@baprdg02 ~]# blkid | grep RECO06

/dev/sdax: LABEL="RECO06" TYPE="oracleasm"

/dev/sdbc: LABEL="RECO06" TYPE="oracleasm"

/dev/mapper/mpathz: LABEL="RECO06" TYPE="oracleasm"

/dev/sdci: LABEL="RECO06" TYPE="oracleasm"

/dev/sddj: LABEL="RECO06" TYPE="oracleasm"

[root@baprdg02 ~]# 


[root@baprdg02 ~]# multipath -ll | grep mpathz

mpathz (36006016082734d006b398666b750b455) dm-23 DGC,VRAID

[root@baprdg02 ~]# 


dd if=/dev/zero of=/dev/mapper/mpathz bs=1024 count=100


[root@baprdg02 ~]# dd if=/dev/zero of=/dev/mapper/mpathz bs=1024 count=100

100+0 records in

100+0 records out

102400 bytes (102 kB, 100 KiB) copied, 0.00748744 s, 13.7 MB/s

[root@baprdg02 ~]# 


partprobe /dev/mapper/mpathz


[root@baprdg02 ~]# partprobe /dev/mapper/mpathz

[root@baprdg02 ~]# 


oracleasm deletedisk -v RECO07

[root@baprdg02 ~]# oracleasm deletedisk -v RECO07

Disk "RECO07" defines an unmarked device

Dropping disk: done

[root@baprdg02 ~]# 


[root@baprdg02 ~]# oracleasm deletedisk -v RECO06

Disk "RECO06" defines an unmarked device

Dropping disk: done

[root@baprdg02 ~]# 


[root@baprdg02 ~]# blkid | grep RECO06

/dev/sdax: LABEL="RECO06" TYPE="oracleasm"

/dev/sdbc: LABEL="RECO06" TYPE="oracleasm"

/dev/sdci: LABEL="RECO06" TYPE="oracleasm"

/dev/sddj: LABEL="RECO06" TYPE="oracleasm"

[root@baprdg02 ~]



[root@baprdg02 ~]# blkid | grep RECO05

/dev/sdaz: LABEL="RECO05" TYPE="oracleasm"

/dev/sdbe: LABEL="RECO05" TYPE="oracleasm"

/dev/mapper/mpathaa: LABEL="RECO05" TYPE="oracleasm"

/dev/sdck: LABEL="RECO05" TYPE="oracleasm"

/dev/sddk: LABEL="RECO05" TYPE="oracleasm"

[root@baprdg02 ~]# 


[root@baprdg02 ~]# multipath -ll | grep mpathaa

mpathaa (36006016082734d006c398666fb34c371) dm-18 DGC,VRAID

[root@baprdg02 ~]# 


dd if=/dev/zero of=/dev/mapper/mpathaa bs=1024 count=100

partprobe /dev/mapper/mpathaa

oracleasm deletedisk -v RECO05


[root@baprdg02 ~]# dd if=/dev/zero of=/dev/mapper/mpathaa bs=1024 count=100

100+0 records in

100+0 records out

102400 bytes (102 kB, 100 KiB) copied, 0.00554351 s, 18.5 MB/s

[root@baprdg02 ~]# partprobe /dev/mapper/mpathaa

[root@baprdg02 ~]# oracleasm deletedisk -v RECO05

Disk "RECO05" defines an unmarked device

Dropping disk: done

[root@baprdg02 ~]# 



No comments:

Post a Comment