Showing posts with label Oracle 19c RAC Database Drop LUN from Liunx OS (2 Node RAC). Show all posts
Showing posts with label Oracle 19c RAC Database Drop LUN from Liunx OS (2 Node RAC). Show all posts

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 ~]#