方案概述

需求: 原数据库主机需要迁移到新的机房。更换机房后也需要更换所有IP 地址。

避免涉及敏感信息，文档中主机名与实际IP已更换

环境现状

OS：Red Hat 6.4

DB: 11.2.0.4 RAC 三节点 ASM存储管理方式

实施步骤

环境当前信息记录：

原IP地址： 10.10.10.1 crm1 10.10.10.2 crm2 10.10.10.3 crm3 10.10.10.4 crm1-vip 10.10.10.5 crm2-vip 10.10.10.6 crm3-vip 192.168.1.1 crm1-priv 192.168.1.2 crm2-priv 192.168.1.3 crm3-priv 10.10.10.8 crm-scan

预计更换地址： 10.5.10.1 crm1 10.5.10.2 crm2 10.5.10.3 crm3 10.5.10.4 crm1-vip 10.5.10.5 crm2-vip 10.5.10.6 crm3-vip 192.168.10.1 crm1-priv 192.168.10.2 crm2-priv 192.168.10.3 crm3-priv 10.5.10.8 crm-scan

目前CRS状态及记录信息：

[grid@crm1 ~]$ crsctl status res -t NAME TARGET STATE SERVER STATE_DETAILS Local Resources ora.gsd OFFLINE OFFLINE crm1
OFFLINE OFFLINE crm2
OFFLINE OFFLINE crm3
ora.net1.network ONLINE ONLINE crm1
ONLINE ONLINE crm2
ONLINE ONLINE crm3
ora.ons ONLINE ONLINE crm1
ONLINE ONLINE crm2
ONLINE ONLINE crm3

ora.DATADG.dg ONLINE ONLINE crm1
ONLINE ONLINE crm2
ONLINE ONLINE crm3
ora.FRADG.dg ONLINE ONLINE crm1
ONLINE ONLINE crm2
ONLINE ONLINE crm3
ora.LISTENER.lsnr ONLINE ONLINE crm1
ONLINE ONLINE crm2
ONLINE ONLINE crm3
ora.OCRDG.dg ONLINE ONLINE crm1
ONLINE ONLINE crm2
ONLINE ONLINE crm3
ora.asm ONLINE ONLINE crm1 Started
ONLINE ONLINE crm2 Started
ONLINE ONLINE crm3 Started
ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE crm2
ora.bizdb.db 1 ONLINE ONLINE crm1 Open
2 ONLINE ONLINE crm2 Open
3 ONLINE ONLINE crm3 Open
ora.bizdb.srvbiz1.svc 1 ONLINE ONLINE crm1
ora.bizdb.srvbiz2.svc 1 ONLINE ONLINE crm2
ora.crm1.vip 1 ONLINE ONLINE crm1
ora.crm2.vip 1 ONLINE ONLINE crm2
ora.crm3.vip 1 ONLINE ONLINE crm3
ora.cvu 1 ONLINE ONLINE crm2
ora.oc4j 1 OFFLINE OFFLINE
ora.scan1.vip 1 ONLINE ONLINE crm2

[grid@crm1 ~]$ ifconfig -a bond0 Link encap:Ethernet HWaddr ----------------
inet addr:10.10.10.1 Bcast:10.10.10.255 Mask:255.255.255.0 inet6 addr: --------------------/64 Scope:Link UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1 RX packets:182202993482 errors:0 dropped:0 overruns:0 frame:0 TX packets:192712758590 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:61248800880778 (55.7 TiB) TX bytes:92009117511369 (83.6 TiB)

bond0:1 Link encap:Ethernet HWaddr -----------------
inet addr:10.10.10.4 Bcast:10.10.10.255 Mask:255.255.255.0 UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

bond1 Link encap:Ethernet HWaddr ------------------------
inet addr:192.168.1.1 Bcast:192.168.1.255 Mask:255.255.255.0 inet6 addr: --------------------/64 Scope:Link UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1 RX packets:299633059576 errors:0 dropped:0 overruns:0 frame:0 TX packets:233593365233 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:222373072757324 (202.2 TiB) TX bytes:169961894463346 (154.5 TiB)

bond1:1 Link encap:Ethernet HWaddr ------------------
inet addr:169.254.20.171 Bcast:169.254.255.255 Mask:255.255.0.0 UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

eth0 Link encap:Ethernet HWaddr --------------------
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) Interrupt:63

eth1 Link encap:Ethernet HWaddr 2C:59:E5:35:9E:D1
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) Interrupt:67

eth2 Link encap:Ethernet HWaddr ------------------------
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) Interrupt:71

eth3 Link encap:Ethernet HWaddr ---------------------
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) Interrupt:75

eth4 Link encap:Ethernet HWaddr ----------------------
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1 RX packets:299633034601 errors:0 dropped:0 overruns:0 frame:0 TX packets:233593365261 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:222373064493446 (202.2 TiB) TX bytes:169961894480202 (154.5 TiB)

eth5 Link encap:Ethernet HWaddr -------------------------
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1 RX packets:181382708114 errors:0 dropped:0 overruns:0 frame:0 TX packets:192712758624 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:60988947559828 (55.4 TiB) TX bytes:92009117527796 (83.6 TiB)

eth6 Link encap:Ethernet HWaddr --------------------
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1 RX packets:25412 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:8849512 (8.4 MiB) TX bytes:0 (0.0 b)

eth7 Link encap:Ethernet HWaddr -----------------
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1 RX packets:820285394 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:259853324267 (242.0 GiB) TX bytes:0 (0.0 b)

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:30119027542 errors:0 dropped:0 overruns:0 frame:0 TX packets:30119027542 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:14903233765867 (13.5 TiB) TX bytes:14903233765867 (13.5 TiB)

[[root@crm3 bin]#./oifcfg getif bond0 10.10.10.0 global public bond1 192.168.1.0 global cluster_interconnect

[root@crm3 bin]#./oifcfg iflist bond0 10.10.10.0 bond1 192.168.1.0 bond1 169.254.0.0

[root@crm3 bin]# ./srvctl config nodeapps Network exists: 1/10.10.10.0/255.255.255.0/bond0, type static VIP exists: /crm1-vip/10.10.10.4/10.10.10.0/255.255.255.0/bond0, hosting node crm1 VIP exists: /crm2-vip/10.10.10.5/10.10.10.0/255.255.255.0/bond0, hosting node crm2 VIP exists: /crm3-vip/10.10.10.6/10.10.10.0/255.255.255.0/bond0, hosting node crm3 GSD exists ONS exists: Local port 6100, remote port 6200, EM port 2016 [root@crm3 bin]#

CRS配置

禁止CRS自动启动服务：

[root@crm1 bin]# cd /grid/app/11.2.0/grid/bin/ [root@crm1 bin]# ./srvctl disable listener [root@crm1 bin]# ./srvctl disable database -d qiudb [root@crm1 bin]# ./srvctl disable vip -i crm1-vip [root@crm1 bin]# ./srvctl disable vip -i crm2-vip [root@crm1 bin]# ./srvctl disable vip -i crm3-vip [root@crm1 bin]# ./srvctl disable scan_listener [root@crm1 bin]# ./srvctl disable scan

停掉3个节点的CRS：

[root@crm1 ~]# cd /grid/app/11.2.0/grid/bin/ [root@crm1 bin]# ./crsctl stop crs

......