Oracle 11G RAC 删除添加节点（一）：删除节点

1、查看节点删除前的资源状态

用集群资源查看命令查看一下状态

1  [grid@lvmrac1 ~]$crsctl stat res ‐t
2   ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
3  NAME           TARGET  STATE        SERVER                   STATE DETAILS
4   ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
5  Local Resources
6   ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
7  ora.ARCH.dg
8                 ONLINE  ONLINE       lvmrac1
9                 ONLINE  ONLINE       lvmrac2
10 ora.DATA.dg
11                 ONLINE  ONLINE       lvmrac1
12                 ONLINE  ONLINE       lvmrac2
13 ora.LISTENER.l snr
14                 ONLINE  ONLINE       lvmrac1
15                 ONLINE  ONLINE       lvmrac2
16 ora.OCR.dg
17                 ONLINE  ONLINE       lvmrac1
18                 ONLINE  ONLINE       lvmrac2
19 ora.asm
20                 ONLINE  ONLINE       lvmrac1                  Started
21                 ONLINE  ONLINE       lvmrac2                  Started
22 ora.gsd
23                 OFFLINE OFFLINE      lvmrac1
24                 OFFLINE OFFLINE      lvmrac2
25 ora.net1.network
26                 ONLINE  ONLINE       lvmrac1
27                 ONLINE  ONLINE       lvmrac2
28 ora.ons
29                 ONLINE  ONLINE       lvmrac1
30                 ONLINE  ONLINE       lvmrac2
31 ora.registry.acfs
32                 ONLINE  ONLINE       lvmrac1
33                 ONLINE  ONLINE       lvmrac2
34  ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
35 Cluster Resources
36  ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
37 ora.LISTENER_SCAN1.l snr
38        1        ONLINE  ONLINE       lvmrac2
39 ora.cvu
40        1        ONLINE  ONLINE       lvmrac2
41 ora.lvmrac.db
42        1        ONLINE  ONLINE       lvmrac1                  Open
   		  2        ONLINE  ONLINE       1vmrac2                  Open
44 ora.1vmrac1.vip
45        1        ONLINE  ONLINE       1vmrac1
46 ora.1vmrac2.vip
47        1        ONLINE  ONLINE       1vmrac2
48 ora.oc4j
49        1        ONLINE  ONLINE       1vmrac1
5 ora.scan1.vip
51        1        ONLINE  ONLINE       1vmrac2

将节点1关机，再次查看集群资源

[grid@1vmrac2 ~]$ crsct1 stat res -t
2  --------------------------------------------------------------------------------
3  NAME           TARGET  STATE        SERVER                   STATE DETAILS
4  --------------------------------------------------------------------------------
5  Loca1 Resources
6  --------------------------------------------------------------------------------
7  ora.ARCH.dg
8                 ONLINE  ONLINE       1vmrac2
9  ora.DATA.dg
1                 ONLINE  ONLINE       1vmrac2
11 ora.LISTENER.1snr
12                 ONLINE  ONLINE       1vmrac2
13 ora.OCR.dg
14                 ONLINE  ONLINE       1vmrac2
15 ora.asm
16                 ONLINE  ONLINE       1vmrac2                  Started
17 ora.gsd
18                 OFFLINE OFFLINE      1vmrac2
19 ora.net1.network
2                 ONLINE  ONLINE       1vmrac2
21 ora.ons
22                 ONLINE  ONLINE       1vmrac2
23 ora.registry.acfs
24                 ONLINE  ONLINE       1vmrac2
25  --------------------------------------------------------------------------------
26 C1uster Resources
27  --------------------------------------------------------------------------------
28 ora.LISTENER_SCAN1.1snr

29	1	ONLINE	ONLINE	1vmrac2
3	ora.cvu			
31	1	ONLINE	ONLINE	1vmrac2
32 ora.1vmrac.db
33        1        ONLINE  OFFLINE
34        2        ONLINE  ONLINE       1vmrac2                  Open
35 ora.1vmrac1.vip
36        1        ONLINE  INTERMEDIATE 1vmrac2                  FAILED OVER
37 ora.1vmrac2.vip
		  1        ONLINE  ONLINE       lvmrac2 ora.oc4j
	      1        ONLINE  OFFLINE                               STARTING ora.scan1.vip
		  1        ONLINE  ONLINE       lvmrac2

2、删除instance（在节点2进行节点1的删除）

1）检查OCR备份(grid)

36  [grid@lvmrac1 ~]$ ocrconfig ‐showbackup
37 lvmrac1 2017/03/30 05:58:31 /u01/11.2.0/grid/cdata/lvmrac‐cluster/backup00.ocr
38 lvmrac1 2017/03/30 01:58:29 /u01/11.2.0/grid/cdata/lvmrac‐cluster/backup01.ocr
39 lvmrac1 2017/03/29 21:58:28 /u01/11.2.0/grid/cdata/lvmrac‐cluster/backup02.ocr
40 lvmrac1 2017/03/29 21:58:28 /u01/11.2.0/grid/cdata/lvmrac‐cluster/day.ocr
41 lvmrac1 2017/03/29 21:58:28 /u01/11.2.0/grid/cdata/lvmrac‐cluster/week.ocr

2）删除要删除节点的instance(oracle)

dbca -silent -deleteDatabase -sourceDB lvmrac1 -sysDBAUserName sys -sysDBAPassword xxxx

3）在保留的节点禁用删除节点的log thread(oracle)

1  SQL> ALTER DATABASE DISABLE THREAD 1; 2
3  Database a1tered.

3、移除rac

1）清除删除节点的监听(grid)
RAC中grid用户管理数据库的监听，还管理数据库的ASM；oracle只负责数据库

1  [grid@lvmrac2 ~]$ srvctl disable listener ‐l listener ‐n lvmrac1
2  [grid@lvmrac2 ~]$ srvctl stop listener ‐l listener  ‐n lvmrac1

2）在删除节点，同步oraInventory库
进入$ORACLE_HOME/oui/bin(grid、oracle)

[grid@lvmrac1 bin]$ ./runInstaller ‐updateNodeList ORACLE_HOME=/u01/11.2.0/grid/ "CLUSTER_NODES={lvmrac1}" ‐local
5  Starting Oracle Universal Installer... 6
7  Checking swap space: must be greater than 500 MB.   Actual 4031 MB    Passed
8  The inventory pointer is located at /etc/oraInst.loc
9  The inventory is located at /u01/app/oraInventory 10  'UpdateNodeList ' was successful.
11
12  [oracle@lvmrac1 bin]$  ./runInstaller ‐updateNodeList
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1/ "CLUSTER_NODES={lvmrac1}" ‐local
13 Starting Oracle Universal Installer... 14
15 Checking swap space: must be greater than 500 MB.   Actual 4026 MB    Passed
16 The inventory pointer is located at /etc/oraInst.loc
17 The inventory is located at /u01/app/oraInventory 18  'UpdateNodeList ' was successful.

3）在删除节点删除软件

1  进入$ORACLE_HOME/de install
2  [grid@lvmrac1 de install]$ ./de install ‐local
3  按照提示，一步一步进行 4
5  [oracle@lvmrac1 de install]$ ./de install ‐local
6  按照提示，一步一步进行

4）在保留节点，同步oraInventory库

 进入$ORACLE_HOME/oui/bin(grid、oracle)
2  [grid@lvmrac2 bin]$ ./runInstaller ‐updateNodeList ORACLE_HOME=/u01/11.2.0/grid/ "CLUSTER_NODES={lvmrac2}"
3  Starting Oracle Universal Installer... 4
5  Checking swap space: must be greater than 500 MB.   Actual 2763 MB    Passed
6  The inventory pointer is located at /etc/oraInst.loc
7  The inventory is located at /u01/app/oraInventory 8  'UpdateNodeList ' was successful.
9
10  [oracle@lvmrac2 bin]$ ./runInstaller ‐updateNodeList
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1/ "CLUSTER_NODES={lvmrac2}"
11 Starting Oracle Universal Installer... 12
13 Checking swap space: must be greater than 500 MB.   Actual 2883 MB    Passed
14 The inventory pointer is located at /etc/oraInst.loc
15 The inventory is located at /u01/app/oraInventory 16  'UpdateNodeList ' was successful.