Hi Guy's,
Please find below steps to label the raw LUNS in Solaris environment by using AFD utility and below scenario is where you have storage level replication not dataguard.
- Query the present LUN's from both Nodes.
Node1:-
oracle@kdbracc1:/dev/capexhalaASM> ls -ltr capexhaladata*
lrwxrwxrwx 1 root root 67 Aug 23 2022 capexhaladata1 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030443741:g,raw
lrwxrwxrwx 1 root root 67 Aug 23 2022 capexhaladata2 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030443742:g,raw
lrwxrwxrwx 1 root root 67 Dec 12 2022 capexhaladata3 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030444443:g,raw
lrwxrwxrwx 1 root root 67 Jun 22 2023 capexhaladata4 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030463246:g,raw
lrwxrwxrwx 1 root root 67 Feb 14 12:41 capexhaladata5 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030354343:g,raw
lrwxrwxrwx 1 root root 67 Feb 14 12:42 capexhaladata6 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030354344:g,raw
Node2:-
oracle@kdbracc2:/dev/capexhalaASM> ls -ltr capexhaladata*
lrwxrwxrwx 1 root root 67 Aug 23 2022 capexhaladata1 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030443741:g,raw
lrwxrwxrwx 1 root root 67 Aug 23 2022 capexhaladata2 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030443742:g,raw
lrwxrwxrwx 1 root root 67 Dec 12 2022 capexhaladata3 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030444443:g,raw
lrwxrwxrwx 1 root root 67 Jun 22 2023 capexhaladata4 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030463246:g,raw
lrwxrwxrwx 1 root root 67 Feb 14 12:42 capexhaladata5 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030354343:g,raw
lrwxrwxrwx 1 root root 67 Feb 14 12:42 capexhaladata6 -> ../../devices/scsi_vhci/ssd@XXX0000970000297000221533030354344:g,raw
- Query the existing labels.
oracle@kdbracc2:/dev/capexhalaASM> cd /var/opt/oracle/oracleafd/disks
oracle@kdbracc2:/var/opt/oracle/oracleafd/disks> ls -ltr capexhaladata*
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata4
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata3
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata2
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata1
- Label the raw LUN's using AFD_LABEL utility.
oracle@kdbracc1:/dev/capexhalaASM> /u01/app/19.0.0/grid/bin/asmcmd afd_label 'capexhaladata5' '/dev/capexhalaASM/capexhaladata5'
oracle@kdbracc1:/dev/capexhalaASM> /u01/app/19.0.0/grid/bin/asmcmd afd_label 'capexhaladata6' '/dev/capexhalaASM/capexhaladata6'
oracle@kdbracc1:/dev/capexhalaASM> cd /var/opt/oracle/oracleafd/disks
oracle@kdbracc1:/var/opt/oracle/oracleafd/disks> ls -ltr capexhaladata*
-rw-rw-r-- 1 oracle dba 31 Jan 19 04:43 capexhaladata4
-rw-rw-r-- 1 oracle dba 31 Jan 19 04:43 capexhaladata3
-rw-rw-r-- 1 oracle dba 31 Jan 19 04:43 capexhaladata2
-rw-rw-r-- 1 oracle dba 31 Jan 19 04:43 capexhaladata1
-rw-rw-r-- 1 oracle dba 31 Feb 15 13:02 capexhaladata5
-rw-rw-r-- 1 oracle dba 31 Feb 15 13:03 capexhaladata6
- Add the Labeled LUN's to the diskgroup.
SQL> alter diskgroup capexhaladata_DG rebalance power 8;
Diskgroup altered.
SQL> ALTER DISKGROUP capexhaladata_DG ADD DISK 'AFD:capexhaladata5';
Diskgroup altered.
SQL> ALTER DISKGROUP capexhaladata_DG ADD DISK 'AFD:capexhaladata6';
Diskgroup altered.
SQL> select dg.name dg_name, round(sum(d.total_mb)/1024,0) total_gb, round(sum(d.free_mb)/1024,0) free_gb from v$asm_diskgroup dg, v$asm_disk d where dg.group_number=d.group_number and dg.name like '%AP%' group by dg.name order by dg_name;
DG_NAME TOTAL_GB FREE_GB
CAPEXHALA_DG 1798 676
CAPEXHALA_FLASHBACK_DG 399 194
CAPEXHALA_REDO01_DG 79 63
CAPEXHALA_REDO02_DG 79 63
- EXECUTE AFD_SCAN ON NODE2
- New labels not available before SCAN.
oracle@kdbracc2:/var/opt/oracle/oracleafd/disks> ls -ltr capexhaladata*
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata4
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata3
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata2
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata1
- After executing AFD_SCAN ON NODE2
oracle@kdbracc2:~> /u01/app/19.0.0/grid/bin/asmcmd afd_scan
oracle@kdbracc2:~> cd /var/opt/oracle/oracleafd/disks
oracle@kdbracc2:/var/opt/oracle/oracleafd/disks> ls -ltr capexhaladata*
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata4
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata3
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata2
-rw-rw-r-- 1 oracle dba 31 Jan 19 05:33 capexhaladata1
-rw-rw-r-- 1 oracle dba 31 Feb 15 13:02 capexhaladata5 <<<<<--- After scan
-rw-rw-r-- 1 oracle dba 31 Feb 15 13:03 capexhaladata6 <<<<<--- After scan
- Email OS team to stop replication.
- Login to DRC and below output is before running AFD_SCAN
- Setting Environment for GRID 19c
oracle@drckdbracc1:~] cd /var/opt/oracle/oracleafd/disks
oracle@drckdbracc1:/var/opt/oracle/oracleafd/disks] ls -ltr capexhaladata*
-rw-rw-r-- 1 oracle dba 31 Jan 19 06:38 capexhaladata4
-rw-rw-r-- 1 oracle dba 31 Jan 19 06:38 capexhaladata3
-rw-rw-r-- 1 oracle dba 31 Jan 19 06:38 capexhaladata2
-rw-rw-r-- 1 oracle dba 31 Jan 19 06:38 capexhaladata1
- Execute scan and see the nee labels.
oracle@drckdbracc1:/u01/app/19.0.0/grid] asmcmd afd_scan
oracle@drckdbracc1:/u01/app/19.0.0/grid] cd /var/opt/oracle/oracleafd/disks
oracle@drckdbracc1:/var/opt/oracle/oracleafd/disks] ls -ltr capexhaladata*
-rw-rw-r-- 1 oracle dba 31 Jan 19 06:38 capexhaladata4
-rw-rw-r-- 1 oracle dba 31 Jan 19 06:38 capexhaladata3
-rw-rw-r-- 1 oracle dba 31 Jan 19 06:38 capexhaladata2
-rw-rw-r-- 1 oracle dba 31 Jan 19 06:38 capexhaladata1
-rw-r--r-- 1 oracle dba 31 Feb 15 14:00 capexhaladata6 <<<<<<<< New Labels Visible
-rw-r--r-- 1 oracle dba 31 Feb 15 14:00 capexhaladata5 <<<<<<< New Labels Visible
******** Happy Learning **********
No comments:
Post a Comment