Describe désert/work/QH-TADB-Restore here.
multipath
[root@newrac1 ~]# cat powerstore-lun-aliasWWN.csv "Name","Alerts","WWN","Logical Used","Provisioned","Host Mappings","Storage Protocol","Protection Policy","Performance Policy","Volume Group" "DB-TZDB-ARCH","","naa.68ccf09800e40e2d19ad2f0188dafc2d","0 GB","200.0 GB","2","SCSI","","Medium","" "DB-TZDB-DATA01","","naa.68ccf09800ece2d13d6c64c6023f99c4","0 GB","300.0 GB","2","SCSI","","Medium","" "DB-TZDB-DATA02","","naa.68ccf09800ffa4584b496cc5374556bd","0 GB","300.0 GB","2","SCSI","","Medium","" "DB-TZDB-DATA03","","naa.68ccf098007b746aa70e8da04fbd81be","0 GB","300.0 GB","2","SCSI","","Medium","" "DB-TZDB-DATA04","","naa.68ccf09800282c053ebd032a057f2b08","0 GB","300.0 GB","2","SCSI","","Medium","" "DB-TZDB-OCR01","","naa.68ccf0980020aed3261a4f6cc035373c","0 GB","5.0 GB","2","SCSI","","Medium","" "DB-TZDB-OCR02","","naa.68ccf09800cf9aa0af3d7236ff98592d","0 GB","5.0 GB","2","SCSI","","Medium","" "DB-TZDB-OCR03","","naa.68ccf098007f7e9873ef80e33516eaef","0 GB","5.0 GB","2","SCSI","","Medium","" [root@newrac1 ~]#
cat powerstore-lun-aliasWWN.csv | grep -v Alert | awk -F"," '{ print "multipath { \n wwid",$3, "\n alias",$1,"\n }" }'
[root@newrac1 ~]# multipath -l | grep 3600 | tr 'a-z' 'A-Z' 36006016062303B0036D387EAD237EC11 DM-12 DGC ,VRAID 36006016062303B00799B430ED337EC11 DM-22 DGC ,VRAID 36006016062303B001134831FD337EC11 DM-14 DGC ,VRAID 36006016062303B00739B430ED337EC11 DM-19 DGC ,VRAID 36006016062303B00B2688B2BD337EC11 DM-15 DGC ,VRAID 36006016062303B003AD387EAD237EC11 DM-18 DGC ,VRAID 36006016062303B007D9B430ED337EC11 DM-24 DGC ,VRAID 36006016062303B000F34831FD337EC11 DM-25 DGC ,VRAID 36006016062303B00779B430ED337EC11 DM-21 DGC ,VRAID 36006016062303B0038D387EAD237EC11 DM-13 DGC ,VRAID 36006016062303B007B9B430ED337EC11 DM-23 DGC ,VRAID 36006016062303B00B1C64CCA50FFEB11 DM-16 DGC ,VRAID 36006016062303B00759B430ED337EC11 DM-20 DGC ,VRAID [root@newrac1 ~]# cat vnx-powerpath-lun-wwnAlias.txt Pseudo name=emcpowera VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B0036D387EAD237EC11 [LUN 63] -- Pseudo name=emcpowerb VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B0038D387EAD237EC11 [LUN 64] -- Pseudo name=emcpowerc VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B003AD387EAD237EC11 [LUN 65] -- Pseudo name=emcpowerd VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B00739B430ED337EC11 [LUN 66] -- Pseudo name=emcpowere VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B00759B430ED337EC11 [LUN 67] -- Pseudo name=emcpowerf VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B00779B430ED337EC11 [LUN 68] -- Pseudo name=emcpowerg VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B00799B430ED337EC11 [LUN 69] -- Pseudo name=emcpowerh VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B007B9B430ED337EC11 [LUN 70] -- Pseudo name=emcpoweri VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B007D9B430ED337EC11 [LUN 71] -- Pseudo name=emcpowerj VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B000F34831FD337EC11 [LUN 72] -- Pseudo name=emcpowerk VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B001134831FD337EC11 [LUN 73] -- Pseudo name=emcpowerl VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B00B2688B2BD337EC11 [LUN 74] -- Pseudo name=emcpowerm VNX ID=CETV2150200065 [NEWRAC] Logical device ID=6006016062303B00B1C64CCA50FFEB11 [LUN 61]
[root@newrac1 ~]# cat vnx-powerpath-lun-wwnAlias.txt | grep -v -- "--" | grep -v CETV | awk -F"=" '{ print $2} ' | awk '{ print $1 }' | fmt
/usr/bin/rescan-scsi-bus.sh
asm replace
SQL> select GROUP_NUMBER,DISK_NUMBER,HEADER_STATUS,MODE_STATUS,MOUNT_STATUS,STATE,total_mb,free_mb,NAME,PATH from v$asm_disk;
GROUP_NUMBER DISK_NUMBER HEADER_STATUS MODE_STATUS MOUNT_STATUS STATE TOTAL_MB FREE_MB NAME PATH
------------ ----------- ------------------------ -------------- -------------- ---------------- ---------- ---------- --------------- --------------------------------------------------
0 0 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/dm-11
0 1 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/dm-10
0 11 FORMER ONLINE CLOSED NORMAL 0 0 /dev/emcpowerj
0 10 FORMER ONLINE CLOSED NORMAL 0 0 /dev/emcpowerk
0 7 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/dm-4
0 6 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/dm-5
0 5 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/dm-6
0 4 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/dm-7
0 3 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/dm-8
0 2 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/dm-9
2 0 MEMBER ONLINE CACHED NORMAL 153600 20852 TZ_RECO_0000 /dev/emcpowerl
GROUP_NUMBER DISK_NUMBER HEADER_STATUS MODE_STATUS MOUNT_STATUS STATE TOTAL_MB FREE_MB NAME PATH
------------ ----------- ------------------------ -------------- -------------- ---------------- ---------- ---------- --------------- --------------------------------------------------
1 5 MEMBER ONLINE CACHED NORMAL 204800 202876 DATA_0005 /dev/emcpoweri
1 4 MEMBER ONLINE CACHED NORMAL 204800 202880 DATA_0004 /dev/emcpowerh
1 3 MEMBER ONLINE CACHED NORMAL 204800 202876 DATA_0003 /dev/emcpowerg
1 2 MEMBER ONLINE CACHED NORMAL 204800 202875 DATA_0002 /dev/emcpowerf
1 1 MEMBER ONLINE CACHED NORMAL 204800 202877 DATA_0001 /dev/emcpowere
1 0 MEMBER ONLINE CACHED NORMAL 204800 202877 DATA_0000 /dev/emcpowerd
3 2 MEMBER ONLINE CACHED NORMAL 2048 1741 VOTE_0002 /dev/emcpowerc
3 1 MEMBER ONLINE CACHED NORMAL 2048 1738 VOTE_0001 /dev/emcpowerb
3 0 MEMBER ONLINE CACHED NORMAL 2048 1739 VOTE_0000 /dev/emcpowera
20 rows selected.
SQL> !asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 1228800 1217261 0 1217261 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 153600 20852 0 20852 0 N TZ_RECO/
MOUNTED NORMAL N 512 4096 1048576 6144 5218 2048 1585 0 Y VOTE/
SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/DB-TZDB-DATA01' rebalance power 6;
alter diskgroup DATA add disk '/dev/oracleasm/disks/DB-TZDB-DATA01' rebalance power 6
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15031: disk specification '/dev/oracleasm/disks/DB-TZDB-DATA01' matches no disks
ORA-15014: path '/dev/oracleasm/disks/DB-TZDB-DATA01' is not in the discovery set
SQL> show parameter asm_diskstring
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
asm_diskstring string /dev/*
SQL> alter system set asm_diskstring='/dev/emc*','/dev/oracleasm/disks/*';
System altered.
SQL> select GROUP_NUMBER,DISK_NUMBER,HEADER_STATUS,MODE_STATUS,MOUNT_STATUS,STATE,total_mb,free_mb,NAME,PATH from v$asm_disk;
GROUP_NUMBER DISK_NUMBER HEADER_STATUS MODE_STATUS MOUNT_STATUS STATE TOTAL_MB FREE_MB NAME PATH
------------ ----------- ------------------------ -------------- -------------- ---------------- ---------- ---------- --------------- --------------------------------------------------
0 8 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/DB-TZDB-OCR01
0 9 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/DB-TZDB-OCR03
0 17 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/DB-TZDB-DATA04
0 16 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/DB-TZDB-DATA03
0 15 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/DB-TZDB-ARCH
0 14 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/DB-TZDB-DATA01
0 13 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/DB-TZDB-DATA02
0 12 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/DB-TZDB-OCR02
0 11 FORMER ONLINE CLOSED NORMAL 0 0 /dev/emcpowerj
0 10 FORMER ONLINE CLOSED NORMAL 0 0 /dev/emcpowerk
2 0 MEMBER ONLINE CACHED NORMAL 153600 20852 TZ_RECO_0000 /dev/emcpowerl
GROUP_NUMBER DISK_NUMBER HEADER_STATUS MODE_STATUS MOUNT_STATUS STATE TOTAL_MB FREE_MB NAME PATH
------------ ----------- ------------------------ -------------- -------------- ---------------- ---------- ---------- --------------- --------------------------------------------------
1 5 MEMBER ONLINE CACHED NORMAL 204800 202876 DATA_0005 /dev/emcpoweri
1 4 MEMBER ONLINE CACHED NORMAL 204800 202880 DATA_0004 /dev/emcpowerh
1 3 MEMBER ONLINE CACHED NORMAL 204800 202876 DATA_0003 /dev/emcpowerg
1 2 MEMBER ONLINE CACHED NORMAL 204800 202875 DATA_0002 /dev/emcpowerf
1 1 MEMBER ONLINE CACHED NORMAL 204800 202877 DATA_0001 /dev/emcpowere
1 0 MEMBER ONLINE CACHED NORMAL 204800 202877 DATA_0000 /dev/emcpowerd
3 2 MEMBER ONLINE CACHED NORMAL 2048 1741 VOTE_0002 /dev/emcpowerc
3 1 MEMBER ONLINE CACHED NORMAL 2048 1738 VOTE_0001 /dev/emcpowerb
3 0 MEMBER ONLINE CACHED NORMAL 2048 1739 VOTE_0000 /dev/emcpowera
20 rows selected.
SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/DB-TZDB-DATA01' rebalance power 6;
Diskgroup altered.alter diskgroup DATA add disk '/dev/oracleasm/disks/DB-TZDB-DATA02','/dev/oracleasm/disks/DB-TZDB-DATA03','/dev/oracleasm/disks/DB-TZDB-DATA04' rebalance power 6;
alter diskgroup TZ_RECO add disk '/dev/oracleasm/disks/DB-TZDB-ARCH' rebalance power 6;
alter diskgroup VOTE add disk '/dev/oracleasm/disks/DB-TZDB-OCR01','/dev/oracleasm/disks/DB-TZDB-OCR02','/dev/oracleasm/disks/DB-TZDB-OCR03' rebalance power 6;
sqlplus -s '/ as sysasm' << "EOF" alter diskgroup VOTE drop disk VOTE_0000 rebalance power 6; alter diskgroup VOTE drop disk VOTE_0001 rebalance power 6; alter diskgroup VOTE drop disk VOTE_0002 rebalance power 6; EOF sqlplus -s '/ as sysasm' << "EOF" alter diskgroup TZ_RECO drop disk TZ_RECO_0000 rebalance power 6; EOF sqlplus -s '/ as sysasm' << "EOF" alter diskgroup DATA drop disk DATA_0000 rebalance power 6; alter diskgroup DATA drop disk DATA_0001 rebalance power 6; alter diskgroup DATA drop disk DATA_0002 rebalance power 6; alter diskgroup DATA drop disk DATA_0003 rebalance power 6; alter diskgroup DATA drop disk DATA_0004 rebalance power 6; alter diskgroup DATA drop disk DATA_0005 rebalance power 6; EOF
udev
# for DISK in `find /dev/mapper/ -name "DB-*" | sed 's#/dev/mapper/##g'` ; do echo `udevadm info --query=all --name=/dev/mapper/$DISK | grep -i dm_uuid | awk -F"=" '{ print "KERNEL==\"dm-*\",ENV{DM_UUID}==\""$2"\",OWNER=\"grid\",GROUP=\"dba\",MODE=\"0660\"" }'`,SYMLINK+=\"oracleasm/disks/$DISK\"; done
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-368ccf09800282c053ebd032a057f2b08",OWNER="grid",GROUP="dba",MODE="0660",SYMLINK+="oracleasm/disks/DB-TZDB-DATA04"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-368ccf098007b746aa70e8da04fbd81be",OWNER="grid",GROUP="dba",MODE="0660",SYMLINK+="oracleasm/disks/DB-TZDB-DATA03"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-368ccf09800ffa4584b496cc5374556bd",OWNER="grid",GROUP="dba",MODE="0660",SYMLINK+="oracleasm/disks/DB-TZDB-DATA02"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-368ccf09800ece2d13d6c64c6023f99c4",OWNER="grid",GROUP="dba",MODE="0660",SYMLINK+="oracleasm/disks/DB-TZDB-DATA01"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-368ccf09800e40e2d19ad2f0188dafc2d",OWNER="grid",GROUP="dba",MODE="0660",SYMLINK+="oracleasm/disks/DB-TZDB-ARCH"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-368ccf098007f7e9873ef80e33516eaef",OWNER="grid",GROUP="dba",MODE="0660",SYMLINK+="oracleasm/disks/DB-TZDB-OCR03"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-368ccf09800cf9aa0af3d7236ff98592d",OWNER="grid",GROUP="dba",MODE="0660",SYMLINK+="oracleasm/disks/DB-TZDB-OCR02"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-368ccf0980020aed3261a4f6cc035373c",OWNER="grid",GROUP="dba",MODE="0660",SYMLINK+="oracleasm/disks/DB-TZDB-OCR01"