11g rac删除节点和添加节点

11g rac 删除节点和添加节点
某客户节点2本地磁盘损坏，节点1oracle数据库正常对外提供服务，更换磁盘之后需要重新把节点2加入集群。

参考mos

How to Add Node/Instance or Remove Node/Instance with Oracle Clusterware and RAC (DocID 1332451.1)

一、删除节点
1、在存活节点删除实例

• View Code
  ALTER SYSTEM RESET thread SCOPE=SPFILE SID='qdds2';

　

2、停止节点2的集群资源
srvctl stop nodeapps -n ht02 -f
如果是正常移除节点
$ORACLE_HOME/crs/install/rootcrs.pl -delete -force

3、检查节点状态
[+ASM1]@ht01[/u01/app/grid/oui/bin]$olsnodes -s -t
ht01 Active Unpinned
ht02 Inactive Unpinned
如果是pinned，请设为Unpinned
crsctl unpin css -n ht02
4、存活的节点上删除被删除节点的信息
/u01/app/grid/bin/crsctl delete node -n ht02
5、正常移除节点删除软件
$ORACLE_HOME/deinstall/deinstall -local

6、存活的节点上更新节点列表信息
su - grid
cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/u01/app/grid "CLUSTER_NODES={ht01}" CRS=TRUE -silent -local
su - oracle
cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/19c/dbhome_1 "CLUSTER_NODES={ht01}" CRS=TRUE -silent -local
7、验证从集群中删除指定节点
cluvfy stage -post nodedel -n ht02
[+ASM1]@ht01[/home/grid]$cluvfy stage -post nodedel -n ht02

Performing post-checks for node removal

Checking CRS integrity...

Clusterware version consistency passed

CRS integrity check passed

Node removal check passed

Post-check for node removal was successful.

二、添加节点
1、cluvfy验证添加节点的条件是否满足
--添加节点预验证
cluvfy stage -pre nodeadd -n ht02 -fixup -verbose

cluvfy stage -post hwos -n ht02

--对比2个节点的配置
cluvfy comp peer -refnode ht01 -n ht02 -orainv oinstall -osdba oinstall-verbose
2、grid添加节点
创建目录及授权
mkdir -p /u01/app/11.2.0/grid
mkdir -p /u01/app/grid
chown -R grid:oinstall /u01/app
chmod -R 777 /u01/app
export IGNORE_PREADDNODE_CHECKS=Y
cd $ORACLE_HOME/oui/bin
./addNode.sh -silent "CLUSTER_NEW_NODES={ht02}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={ht02-vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={ht02-prv}"

• View Code
  　　

3、添加oracle软件
节点2创建目录及权限
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/19c/dbhome_1
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle
su - oracle
cd $ORACLE_HOME/oui/bin
export IGNORE_PREADDNODE_CHECKS=Y
./addNode.sh -silent "CLUSTER_NEW_NODES={ht02}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={ht02-vip}"

• View Code
  　　

4、集群添加实例
[qdds1]@ht01[/home/oracle]$srvctl add instance -d qdds -i qdds2 -n ht02
[qdds1]@ht01[/home/oracle]$srvctl config database -d qdds
Database unique name: qdds
Database name: qdds
Oracle home: /u01/app/oracle/product/19c/dbhome_1
Oracle user: oracle
Spfile: +DATA/qdds/spfileqdds.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: qdds
Database instances: qdds1,qdds2
Disk Groups: DATA,ARCH
Mount point paths:
Services:
Type: RAC
Database is administrator managed
5、dbca添加实例
[qdds2]@ht02[/home/oracle]$dbca -silent -addInstance -nodeList ht02 -gdbName qdds -instanceName qdds2 -sysDBAUserName sys -sysDBAPassword oracle
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/qdds.log" for further details.

6、添加undo及redo
alter database add logfile thread 2 group 3 size 524288000;
alter database add logfile thread 2 group 4 size 524288000;
ALTER DATABASE enable THREAD 2;
create undo tablespace UNDOTBS2 datafile size 115343360 autoextend on;
7、修改pfile
create pfile='/home/oracle/pfile20220520' from spfile
主要是把节点2信息添加进去
qdds1.thread=1
qdds2.thread=2
qdds1.undo_tablespace='UNDOTBS1'
qdds2.undo_tablespace='UNDOTBS2'
qdds1.instance_number=1
qdds2.instance_number=2
8、创建spfile
[qdds1]@ht01[/home/oracle]$srvctl config database -d qdds
Database unique name: qdds
Database name: qdds
Oracle home: /u01/app/oracle/product/19c/dbhome_1
Oracle user: oracle
Spfile: +DATA/qdds/spfileqdds.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: qdds
Database instances: qdds1
Disk Groups: DATA,ARCH
Mount point paths:
Services:
Type: RAC
Database is administrator managed

startup nomount pfile='/home/oracle/pfile20220520'
create spfile='+DATA' from pfile='/home/oracle/pfile20220520';
asmcmd rm +DATA/QDDS/spfileqdds.ora
asmcmd mkalias +DATA/QDDS/PARAMETERFILE/spfile.268.1105527839 spfileqdds.ora

srvctl stop database -d qdds
srvctl start database -d qdds