Oracle集群升级迁移——存储及主机连接配置
目录
Oracle集群升级迁移——存储及主机连接配置
存储映射新LUN给Oracle新集群
新建集群的机构如图所示，前面已将备库Oracle多余的磁盘剔除，剔除后ASM磁盘组状态显示磁盘为DROPPING，但multipath和存储LUN、LUN组、主机和主机组配置还在，需要再multipath和LUN、LUN组上删除（安全起见没拔线）。
旧存储删除
multipath.conf删除相应磁盘
磁盘在conf文件的编码与存储中LUN的编码对应，删除之前剔除的编码即可
将主机和主机组里剔除磁盘，在从LUN、LUN组删除
新建磁盘映射给Oracle数据库（映射前需要划Zone）
前边已提到，光交14 15端口连接的是存储，9 10端口连接的是旧Oracle服务器备机，现准备用存储0、1端口给新Oracle服务器。
线连接完毕后需要在光交侧划Zone，供存储流量使用。
划分完Zone，记住相应的WWPN编码，在华为存储添加主机和启动器（类似通信端口），能够自动的看到相应的WWPN编码的启动器。
以下是主机启动器对应的WWPN编码
*以下为划分Zone的光交指令，及光交侧看到的端口的WWPN编码
查看Zone
swd77:admin> zoneshow
Defined configuration:
cfg: HP_CONF EMC5100_GZH; EMC5100_YYYJ; X1600_2024; IMG01_5300V3;
IMG02_5300V3; ORACLE01_5300V3; ORACLE02_5300V3
zone: EMC5100_GZH
1,0; 1,1; 1,2; 1,3
zone: EMC5100_YYYJ
1,0; 1,1; 1,4; 1,5
zone: IMG01_5300V3
1,9; 1,10; 1,12
zone: IMG02_5300V3
1,9; 1,11; 1,10
zone: ORACLE01_5300V3
1,9; 1,10; 1,14
zone: ORACLE02_5300V3
1,9; 1,10; 1,15
zone: X1600_2024
MSL2024Drv1port1; MSL2024Drv2port1; X1600HBA1
alias: MSL2024Drv1port1
1,6
alias: MSL2024Drv2port1
1,7
alias: ORACLE01_PCIE2
1,14
alias: ORACLE02_PCIE2
1,15
alias: X1600HBA1
1,8
Effective configuration:
cfg: HP_CONF
zone: EMC5100_GZH
1,0
1,1
1,2
1,3
zone: EMC5100_YYYJ
1,0
1,1
1,4
1,5
zone: IMG01_5300V3
1,9
1,10
1,12
zone: IMG02_5300V3
1,9
1,11
1,10
zone: ORACLE01_5300V3
1,9
1,10
1,14
zone: ORACLE02_5300V3
1,9
1,10
1,15
zone: X1600_2024
1,6
1,7
1,8
查看光交接口信息
swd77:admin> switchshow
switchName: swd77
switchType: 71.2
switchState: Online
switchMode: Native
switchRole: Principal
switchDomain: 1
switchId: fffc01
switchWwn: 10:00:50:eb:1a:d7:c7:f8
zoning: ON (HP_CONF)
switchBeacon: OFF
Index Port Address Media Speed State Proto
==================================================
0 0 010000 id N8 No_Light FC
1 1 010100 id N8 No_Light FC
2 2 010200 id N8 No_Light FC
3 3 010300 id N8 No_Light FC
4 4 010400 id N8 No_Light FC
5 5 010500 id N8 No_Light FC
6 6 010600 id N8 No_Light FC
7 7 010700 id N8 No_Light FC
8 8 010800 id N8 Online FC F-Port 20:11:40:ee:dd:88:2b:7c
9 9 010900 id N8 Online FC F-Port 20:00:40:ee:dd:88:2b:7c
10 10 010a00 id N8 No_Light FC
11 11 010b00 id N8 Online FC F-Port 50:01:43:80:26:68:df:6e
12 12 010c00 id N8 No_Light FC
13 13 010d00 id N8 No_Light FC
14 14 010e00 id N8 Online FC F-Port 21:00:00:24:ff:14:cc:3c
15 15 010f00 id N8 No_Light FC
16 16 011000 id N8 No_Light FC (No POD License) Disabled
17 17 011100 id N8 No_Light FC (No POD License) Disabled
18 18 011200 id N8 No_Light FC (No POD License) Disabled
19 19 011300 id N8 No_Light FC (No POD License) Disabled
20 20 011400 id N8 No_Light FC (No POD License) Disabled
21 21 011500 id N8 No_Light FC (No POD License) Disabled
22 22 011600 id N8 No_Light FC (No POD License) Disabled
23 23 011700 id N8 No_Light FC (No POD License) Disabled
swd77:admin> cfgremove .
. .. .bash_logout .inputrc .profile .ssh
swd77:admin> cfgremove timed out waiting for input: auto-logout
swd77:admin>
swd77:admin>
swd77:admin>
swd77:admin>
创建Zone并保存配置,aliceate为创建主机别名
swd77:admin> alicreate "oracleN1","1,0"
swd77:admin> alicreate "oracleN2","1,1"
swd77:admin> zonecreate "oracle_new1","1,0;1,9;1,10"
swd77:admin> zonecreate "oracle_new2","1,1;1,9;1,10"
swd77:admin> zoneshow
Defined configuration:
cfg: HP_CONF EMC5100_GZH; EMC5100_YYYJ; X1600_2024; IMG01_5300V3;
IMG02_5300V3; ORACLE01_5300V3; ORACLE02_5300V3
zone: EMC5100_GZH
1,0; 1,1; 1,2; 1,3
zone: EMC5100_YYYJ
1,0; 1,1; 1,4; 1,5
zone: IMG01_5300V3
1,9; 1,10; 1,12
zone: IMG02_5300V3
1,9; 1,11; 1,10
zone: ORACLE01_5300V3
1,9; 1,10; 1,14
zone: ORACLE02_5300V3
1,9; 1,10; 1,15
zone: X1600_2024
MSL2024Drv1port1; MSL2024Drv2port1; X1600HBA1
zone: oracle_new1
1,0; 1,9; 1,10
zone: oracle_new2
1,1; 1,9; 1,10
alias: MSL2024Drv1port1
1,6
alias: MSL2024Drv2port1
1,7
alias: ORACLE01_PCIE2
1,14
alias: ORACLE02_PCIE2
1,15
alias: X1600HBA1
1,8
alias: oracleN1
1,0
alias: oracleN2
1,1
Effective configuration:
cfg: HP_CONF
zone: EMC5100_GZH
1,0
1,1
1,2
1,3
zone: EMC5100_YYYJ
1,0
1,1
1,4
1,5
zone: IMG01_5300V3
1,9
1,10
1,12
zone: IMG02_5300V3
1,9
1,11
1,10
zone: ORACLE01_5300V3
1,9
1,10
1,14
zone: ORACLE02_5300V3
1,9
1,10
1,15
zone: X1600_2024
1,6
1,7
1,8
swd77:admin> cfgadd "HP_CONF","oracle_new1;oracle_new2"
swd77:admin> cfgsave
插线并通过Switchshow确定端口WWPN码，记住每台主机对应端口的WWPN码，并在存储创建主机和LUN映射时通过WWPN进行映射
MAPS is not Licensed. MAPS extended features are available ONLY with License
SN2248-2:FID128:admin> switchshow
switchName: SN2248-2
switchType: 109.1
switchState: Online
switchMode: Native
switchRole: Principal
switchDomain: 2
switchId: fffc02
switchWwn: 10:00:c4:f5:7c:a4:89:48
zoning: ON (cfg_1)
switchBeacon: OFF
FC Router: OFF
HIF Mode: OFF
Allow XISL Use: OFF
LS Attributes: [FID: 128, Base Switch: No, Default Switch: Yes, Ficon Switch: No, Address Mode 0]
Index Port Address Media Speed State Proto
==================================================
0 0 020000 id N16 Online FC F-Port 20:01:a0:8c:f8:1e:1a:66
1 1 020100 id N16 Online FC F-Port 20:11:a0:8c:f8:1e:1a:66
2 2 020200 id N16 Online FC F-Port 21:00:00:24:ff:14:10:3e
3 3 020300 id N16 Online FC F-Port 21:00:00:24:ff:14:0f:7e
4 4 020400 id N16 Online FC F-Port 21:00:00:24:ff:14:0f:f4
5 5 020500 id N16 Online FC F-Port 21:00:00:24:ff:14:0f:fa
6 6 020600 id N16 Online FC F-Port 10:00:00:10:9b:18:f7:06
7 7 020700 id N16 Online FC F-Port 21:00:00:24:ff:14:93:e8
8 8 020800 id N16 Online FC F-Port 21:00:00:24:ff:14:97:30
9 9 020900 id N16 Online FC F-Port 21:00:00:24:ff:14:95:d8
10 10 020a00 id N16 Online FC F-Port 10:00:00:10:9b:62:50:ea
11 11 020b00 id N16 Online FC F-Port 10:00:00:10:9b:62:50:d4
12 12 020c00 id N16 Online FC F-Port 10:00:00:10:9b:65:f2:ef
13 13 020d00 id N16 No_Light FC
14 14 020e00 id N16 No_Light FC
15 15 020f00 id N16 No_Light FC
16 16 021000 id N16 No_Light FC
17 17 021100 id N16 No_Light FC
18 18 021200 id N16 Online FC F-Port 20:01:20:28:3e:8f:6a:b4
19 19 021300 id N16 Online FC F-Port 20:11:20:28:3e:8f:6a:b4
20 20 021400 id N16 No_Light FC
21 21 021500 id N16 No_Light FC
22 22 021600 id N16 Online FC F-Port 10:00:00:90:fa:fc:e2:70
23 23 021700 id N16 Online FC F-Port 10:00:00:90:fa:fc:e1:ac
24 24 021800 id N16 Online FC F-Port 10:00:00:10:9b:7d:cc:b8
25 25 021900 id N16 Online FC F-Port 10:00:00:10:9b:7d:cc:d9
26 26 021a00 id N16 Online FC F-Port 10:00:00:10:9b:7d:cc:d3
27 27 021b00 id N16 Online FC F-Port 10:00:00:10:9b:7d:cc:af
28 28 021c00 id N16 Online FC F-Port 10:00:00:10:9b:7d:1c:94
29 29 021d00 id N16 Online FC F-Port 10:00:00:10:9b:7d:1c:9d
30 30 021e00 id N16 Online FC F-Port 10:00:00:10:9b:7d:1c:a0
31 31 021f00 id N16 Online FC F-Port 10:00:00:10:9b:7d:1c:9a
32 32 022000 id N16 Online FC F-Port 10:00:00:10:9b:7d:71:79
33 33 022100 id N16 Online FC F-Port 10:00:00:10:9b:7d:71:52
34 34 022200 id N16 No_Light FC
35 35 022300 id N16 No_Light FC
36 36 022400 id N16 Online FC F-Port 20:00:a0:08:6f:5e:f0:2b
37 37 022500 id N16 Online FC F-Port 20:10:a0:08:6f:5e:f0:2b
38 38 022600 id N16 No_Light FC
39 39 022700 id N16 No_Light FC
40 40 022800 id N16 No_Light FC
41 41 022900 id N16 No_Light FC
42 42 022a00 id N16 No_Light FC
43 43 022b00 id N16 No_Light FC
44 44 022c00 id N16 No_Light FC
45 45 022d00 id N16 No_Light FC
46 46 022e00 id N16 No_Light FC
47 47 022f00 id N16 No_Light FC
SN2248-2:FID128:admin> timed out waiting for input: auto-logout
Closing the current session
swd77:admin>
swd77:admin>
swd77:admin>
swd77:admin> switchshow
switchName: swd77
switchType: 71.2
switchState: Online
switchMode: Native
switchRole: Principal
switchDomain: 1
switchId: fffc01
switchWwn: 10:00:50:eb:1a:d7:c7:f8
zoning: ON (HP_CONF)
switchBeacon: OFF
Index Port Address Media Speed State Proto
==================================================
0 0 010000 id N8 Online FC F-Port 10:00:00:10:9b:df:77:ec
1 1 010100 id N8 Online FC F-Port 10:00:00:10:9b:df:78:66
2 2 010200 id N8 No_Light FC
3 3 010300 id N8 No_Light FC
4 4 010400 id N8 No_Light FC
5 5 010500 id N8 No_Light FC
6 6 010600 id N8 No_Light FC
7 7 010700 id N8 No_Light FC
8 8 010800 id N8 Online FC F-Port 20:11:40:ee:dd:88:2b:7c
9 9 010900 id N8 Online FC F-Port 20:00:40:ee:dd:88:2b:7c
10 10 010a00 id N8 No_Light FC
11 11 010b00 id N8 Online FC F-Port 50:01:43:80:26:68:df:6e
12 12 010c00 id N8 No_Light FC
13 13 010d00 id N8 No_Light FC
14 14 010e00 id N8 Online FC F-Port 21:00:00:24:ff:14:cc:3c
15 15 010f00 id N8 No_Light FC
16 16 011000 id N8 No_Light FC (No POD License) Disabled
17 17 011100 id N8 No_Light FC (No POD License) Disabled
18 18 011200 id N8 No_Light FC (No POD License) Disabled
19 19 011300 id N8 No_Light FC (No POD License) Disabled
20 20 011400 id N8 No_Light FC (No POD License) Disabled
21 21 011500 id N8 No_Light FC (No POD License) Disabled
22 22 011600 id N8 No_Light FC (No POD License) Disabled
23 23 011700 id N8 No_Light FC (No POD License) Disabled
映射完毕，刷新主机配置并修改multipath.conf文件
可通过重启 或者 root直接运行rescan-scsi-bus.sh 将磁盘映射给主机
磁盘映射后设备名称是错误的，可在multipath中进行修改。
检查
lsblk -ll 或者lsblk进行检查
