資料庫版本：11.2.0.4.0
主機配置資訊
hosts檔案配置：
[grid@prod01 ~]$ cat /etc/hosts
#127.0.0.1 localhost.localdomain localhost.localdomain localhost4 localhost4.localdomain4
#::1 localhost.localdomain localhost.localdomain localhost6 localhost6.localdomain6
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.230 prod01
192.168.0.232 prod01-vip
192.168.0.231 prod02
192.168.0.233 prod02-vip
192.168.0.234 scan PROD01 ip配置：
[grid@prod01 ~]$ ip a s
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:1e:dd:db brd ff:ff:ff:ff:ff:ff
inet 192.168.0.230/24 brd 192.168.0.255 scope global eth0
inet 192.168.0.232/24 brd 192.168.0.255 scope global secondary eth0:1
inet6 fe80::20c:29ff:fe1e:dddb/64 scope link
valid_lft forever preferred_lft forever
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:1e:dd:e5 brd ff:ff:ff:ff:ff:ff
inet 12.168.0.230/24 brd 12.168.0.255 scope global eth1
inet 169.254.43.21/16 brd 169.254.255.255 scope global eth1:1
inet6 fe80::20c:29ff:fe1e:dde5/64 scope link
valid_lft forever preferred_lft forever PROD02 ip配置：
[oracle@prod02 ~]$ ip a s
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:97:6c:de brd ff:ff:ff:ff:ff:ff
inet 192.168.0.231/24 brd 192.168.0.255 scope global eth0
inet 192.168.0.233/24 brd 192.168.0.255 scope global secondary eth0:1
inet6 fe80::20c:29ff:fe97:6cde/64 scope link
valid_lft forever preferred_lft forever
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:1e:dd:e5 brd ff:ff:ff:ff:ff:ff
inet 12.168.0.231/24 brd 12.168.0.255 scope global eth1
inet 169.254.70.199/16 brd 169.254.255.255 scope global eth1:1
inet6 fe80::20c:29ff:fe1e:dde5/64 scope link
valid_lft forever preferred_lft forever 心跳ip位址變更資訊
prod01 eth1
12.168.0.230/24 =====> 17.17.0.1/24
prod02 eth1
12.168.0.230/24 =====> 17.17.0.2/24
備份ocr，olr，gpnp profile
(2個節點都需要備份)
olr備份：
/u01/app/11.2.0/grid/bin/ocrconfig -local -manualbackup
ocr備份：
/u01/app/11.2.0/grid/bin/ocrconfig -manualbackup
[grid@prod01 ~]$ cd /u01/app/11.2.0/grid/gpnp/profiles/peer/
[grid@prod01 peer]$ pwd
/u01/app/11.2.0/grid/gpnp/profiles/peer
[grid@prod01 peer]$ ls -l
total 8
-rw-r--r-- 1 grid oinstall 1823 Oct 26 09:49 profile_orig.xml
-rw-r--r-- 1 grid oinstall 1886 Oct 26 09:56 profile.xml
[grid@prod01 peer]$ cp profile.xml profile.xml.bak
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/ocrconfig -manualbackup
prod02 2018/11/21 09:18:49 /u01/app/11.2.0/grid/cdata/prod-cluster/backup_20181121_091849.ocr
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/ocrconfig -showbackup
prod02 2018/11/21 09:00:45 /u01/app/11.2.0/grid/cdata/prod-cluster/backup00.ocr
prod02 2018/11/21 05:00:45 /u01/app/11.2.0/grid/cdata/prod-cluster/backup01.ocr
prod02 2018/11/21 01:00:44 /u01/app/11.2.0/grid/cdata/prod-cluster/backup02.ocr
prod02 2018/11/20 01:00:42 /u01/app/11.2.0/grid/cdata/prod-cluster/day.ocr
prod02 2018/11/12 21:00:25 /u01/app/11.2.0/grid/cdata/prod-cluster/week.ocr
prod02 2018/11/21 09:18:49 /u01/app/11.2.0/grid/cdata/prod-cluster/backup_20181121_091849.ocr 更改grid ip位址資訊：
保持所有節點處于運作狀态，隻要在一個節點操作既可以，用root使用者執行操作。
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/oifcfg iflist
eth0 192.168.0.0
eth1 12.168.0.0
eth1 169.254.0.0
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/oifcfg getif
eth0 192.168.0.0 global public
eth1 12.168.0.0 global cluster_interconnect
[root@prod01 ~]# ipcalc -bnm 17.17.0.1 255.255.255.0
NETMASK=255.255.255.0
BROADCAST=17.17.0.255
NETWORK=17.17.0.0
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/oifcfg setif -global eth1/17.17.0.0:cluster_interconnect
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/oifcfg getif
eth0 192.168.0.0 global public
eth1 12.168.0.0 global cluster_interconnect
eth1 17.17.0.0 global cluster_interconnect
關閉資料庫叢集軟體
/u01/app/11.2.0/grid/bin/crsctl stop has 更改主機心跳ip位址，啟動資料庫叢集軟體
[root@prod01 ~]# ip a s eth1
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:1e:dd:e5 brd ff:ff:ff:ff:ff:ff
inet 17.17.0.1/24 brd 17.17.0.255 scope global eth1
inet6 fe80::20c:29ff:fe1e:dde5/64 scope link
valid_lft forever preferred_lft forever
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/crsctl start has
[root@prod02 network-scripts]# ip a s eth1
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:97:6c:e8 brd ff:ff:ff:ff:ff:ff
inet 17.17.0.2/24 brd 17.17.0.255 scope global eth1
inet6 fe80::20c:29ff:fe97:6ce8/64 scope link
valid_lft forever preferred_lft forever
[root@prod02 ~]# /u01/app/11.2.0/grid/bin/crsctl start has 檢查叢集軟體狀态和删除之前資訊網絡資訊：
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
# 确認所有叢集啟動之後，執行如下操作。
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/oifcfg getif
eth0 192.168.0.0 global public
eth1 12.168.0.0 global cluster_interconnect
eth1 17.17.0.0 global cluster_interconnect
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/oifcfg delif -global eth1/12.168.0.0
[root@prod01 ~]# /u01/app/11.2.0/grid/bin/oifcfg getif
eth0 192.168.0.0 global public
eth1 17.17.0.0 global cluster_interconnect subnet計算指令：
這是按照子網路遮罩252計算的網絡配置，一會打算使用這個值模拟錯誤：
[root@prod01 ~]# ipcalc -bnm 17.17.0.1 255.255.255.0
NETMASK=255.255.255.0
BROADCAST=17.17.0.255
NETWORK=17.17.0.0
參考手冊：
如何修改叢集的公網資訊（包括 VIP） (文檔 ID 1674442.1)
如何在 oracle 叢集環境下修改私網資訊 (文檔 ID 2103317.1)
![【MySQL資料庫】資料庫索引事務1.索引2.事務[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)