Sunday, 5 October 2025

Move OCR , Vote File , ASM SPILE to new Diskgroup (Oracle 19c RAC)

 
root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   9501fcc2dc854f80bff978f053afd973 (/dev/rdsk/c0t6006016084734D00B615DA687385B576d0s0) [OCRVOTE]
Located 1 voting disk(s).
root@misdg:/d01/soft#

----Alert log-----
CREATE DISKGROUP OCRVOTE1 EXTERNAL REDUNDANCY  DISK '/dev/rdsk/c0t6006016084734D00116EDB6817C70198d0s0' SIZE 511829M
 ATTRIBUTE 'compatible.asm'='19.0.0.0','compatible.advm'='19.0.0.0','au_size'='4M'


/d01/app/19c/grid/bin/crsctl replace votedisk +OCRVOTE1

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl replace votedisk +OCRVOTE1
Successful addition of voting disk 2e091a5ac02d4f4ebfb44511c10221ec.
Successful deletion of voting disk 9501fcc2dc854f80bff978f053afd973.
Successfully replaced voting disk group with +OCRVOTE1.
CRS-4266: Voting file(s) successfully replaced

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   2e091a5ac02d4f4ebfb44511c10221ec (/dev/rdsk/c0t6006016084734D00116EDB6817C70198d0s0) [OCRVOTE1]
Located 1 voting disk(s).

root@misdg:/d01/soft#
root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'misdg'
CRS-2673: Attempting to stop 'ora.crsd' on 'misdg'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'misdg'
CRS-2673: Attempting to stop 'ora.qosmserver' on 'misdg'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'misdg'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'misdg'
CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'misdg'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.OCRVOTE1.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.REDO01.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.REDO02.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.REDO03.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.cvu' on 'misdg'
CRS-2677: Stop of 'ora.cvu' on 'misdg' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.REDO01.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.OCRVOTE1.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.REDO03.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.REDO02.dg' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'misdg'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'misdg'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.misdg.vip' on 'misdg'
CRS-2677: Stop of 'ora.scan1.vip' on 'misdg' succeeded
CRS-2677: Stop of 'ora.asm' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'misdg'
CRS-2677: Stop of 'ora.misdg.vip' on 'misdg' succeeded
CRS-2677: Stop of 'ora.qosmserver' on 'misdg' succeeded
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'misdg'
CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'misdg' succeeded
CRS-33677: Stop of resource group 'ora.asmgroup' on server 'misdg' succeeded.
CRS-2673: Attempting to stop 'ora.ons' on 'misdg'
CRS-2677: Stop of 'ora.ons' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'misdg'
CRS-2677: Stop of 'ora.net1.network' on 'misdg' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'misdg' has completed
CRS-2677: Stop of 'ora.crsd' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'misdg'
CRS-2673: Attempting to stop 'ora.crf' on 'misdg'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'misdg'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'misdg'
CRS-2677: Stop of 'ora.drivers.acfs' on 'misdg' succeeded
CRS-2677: Stop of 'ora.crf' on 'misdg' succeeded
CRS-2677: Stop of 'ora.storage' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'misdg'
CRS-2677: Stop of 'ora.mdnsd' on 'misdg' succeeded
CRS-2677: Stop of 'ora.asm' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'misdg'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'misdg'
CRS-2673: Attempting to stop 'ora.evmd' on 'misdg'
CRS-2677: Stop of 'ora.ctssd' on 'misdg' succeeded
CRS-2677: Stop of 'ora.evmd' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'misdg'
CRS-2677: Stop of 'ora.cssd' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'misdg'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'misdg'
CRS-2677: Stop of 'ora.gipcd' on 'misdg' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'misdg' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'misdg' has completed
CRS-4133: Oracle High Availability Services has been stopped.

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
root@misdg:/d01/soft#

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   2e091a5ac02d4f4ebfb44511c10221ec (/dev/rdsk/c0t6006016084734D00116EDB6817C70198d0s0) [OCRVOTE1]
Located 1 voting disk(s).
root@misdg:/d01/soft#

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl check cluster -all
**************************************************************
misdg:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
root@misdg:/d01/soft#

root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84292
         Available space (kbytes) :     407392
         ID                       : 1626978053
         Device/File Name         :   +OCRVOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
root@misdg:/d01/soft#

----------Move the OCR to new diskgroup.
/d01/soft# /d01/app/19c/grid/bin/ocrconfig -add +OCRVOTE1
root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrconfig -add +OCRVOTE1
root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84292
         Available space (kbytes) :     407392
         ID                       : 1626978053
         Device/File Name         :   +OCRVOTE
                                    Device/File integrity check succeeded
         Device/File Name         :  +OCRVOTE1
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
root@misdg:/d01/soft#
--Connect with SQLPLUS ASM instance
col path for a30
col name for a20
col header_status for a20
SQL> show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +OCRVOTE/misdg-cluster/ASMPARAMETERFILE/registry.253.1213202967
SQL>

asmcmd spmove '+OCRVOTE/misdg-cluster/ASMPARAMETERFILE/registry.253.1213202967' '+OCRVOTE1/misdg-cluster/spfileASM.ora'
-bash-5.2$ asmcmd spmove '+OCRVOTE/misdg-cluster/ASMPARAMETERFILE/registry.253.1213202967' '+OCRVOTE1/misdg-cluster/spfileASM.ora'
ORA-15032: not all alterations performed
ORA-15028: ASM file '+OCRVOTE/misdg-cluster/ASMPARAMETERFILE/registry.253.1213202967' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
-bash-5.2$
--Delete the old diskgroup
/d01/soft# /d01/app/19c/grid/bin/ocrconfig -delete +OCRVOTE
root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrconfig -delete +OCRVOTE
root@misdg:/d01/soft#
root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84292
         Available space (kbytes) :     407392
         ID                       : 1626978053
         Device/File Name         :  +OCRVOTE1
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
root@misdg:/d01/soft#
---- Verify Move the SPFILE to newdiskgroup.
-bash-5.2$ asmcmd spget
+OCRVOTE1/misdg-cluster/spfileASM.ora
-bash-5.2$
reboot server
root@misdg:~# /d01/app/19c/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       misdg                    STABLE
ora.net1.network
               ONLINE  ONLINE       misdg                    STABLE
ora.ons
               ONLINE  ONLINE       misdg                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      misdg                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       misdg                    STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.FRA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       misdg                    STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       misdg                    STABLE
ora.OCRVOTE1.dg(ora.asmgroup)
      1        ONLINE  ONLINE       misdg                    STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.REDO01.dg(ora.asmgroup)
      1        ONLINE  ONLINE       misdg                    STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.REDO02.dg(ora.asmgroup)
      1        ONLINE  ONLINE       misdg                    STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.REDO03.dg(ora.asmgroup)
      1        ONLINE  ONLINE       misdg                    STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       misdg                    Started,STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       misdg                    STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       misdg                    STABLE
ora.misdg.vip
      1        ONLINE  ONLINE       misdg                    STABLE
ora.qosmserver
      1        ONLINE  ONLINE       misdg                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       misdg                    STABLE
--------------------------------------------------------------------------------
root@misdg:~#


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



Wednesday, 9 October 2024

step by step Oracle 12c Data Guard Switchover

 

 Step:1 In Primary database check the database role and open_mode

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE           DATABASE_ROLE
--------- -------------------- ----------------
BACHDB      READ WRITE           PRIMARY

SQL>

 Step:2 In standby database check the database role and open_mode

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE           DATABASE_ROLE
--------- -------------------- ----------------
BACHDB      READ ONLY WITH APPLY PHYSICAL STANDBY

 

Step:2 Check archive log gap sequence

ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';
SELECT sequence#, first_time, next_time, applied FROM v$archived_log ORDER BY sequence#; 

 SQL> SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;

no rows selected

Step 3: Check switchover status in primary database

 SQL>  select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO STANDBY

SQL> 

 The switchover_status column of v$database can have the following values:

Not Allowed:-Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases
Session Active:- Indicates that there are active SQL sessions attached to the primary or standby database that need to be disconnected before the switchover operation is permitted
Switchover Pending:- This is a standby database and the primary database switchover request has been received but not processed.
Switchover Latent:- The switchover was in pending mode, but did not complete and went back to the primary database
To Primary:- This is a standby database, with no active sessions, that is allowed to switch over to a primary database
To Standby:- This is a primary database, with no active sessions, that is allowed to switch over to a standby database
Recovery Needed:- This is a standby database that has not received the switchover request

 

Step 4: On Primary database:-

SQL> alter database commit to switchover to standby;

 

Step 5 On old Primary database will become now standby
 

shutdown immediate

startup nomount

alter database mount standby database 

Step 6:-select name,open_mode,database_role from v$database;