oraclerac如何正確的刪除單個節點的actionlist
1 節點2
使用dbca刪除一個節點
2 節點1
alter database disable thread 2;
3 節點1
驗證是否已經刪除一個節點數據庫
[03:49:06 oracle(db)@rac1 ~]$ srvctl config database -d prod
Database unique name: prod
Database name: prod
Oracle home: /u01/app/oracle/product/11.2.0/db
Oracle user: oracle
Spfile: +DATA/prod/spfileprod.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: prod
Database instances: prod1
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Database is administrator managed
4 節點1
停止節點2的監聽
srvctl disable listener -l LISTENER -n rac2;
srvctl stop listener -l LISTENER -n rac2;
5 節點2
更新節點信息
/u01/app/oracle/product/11.2.0/db/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0/db "CLUSTER_NODES={rac2}" -local
6 節點2
刪除節點2的ORACLE軟件
/u01/app/oracle/product/11.2.0/db/deinstall/deinstall -local
7 節點1
更新剩余節點的信息
/u01/app/oracle/product/11.2.0/db/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0/db "CLUSTER_NODES={rac1}"
刪除oracle軟件已經完成
下面來刪除grid軟件
8 節點1
查看ons的資源情況
olsnodes -s -t
rac1 Active Unpinned
rac2 Active Unpinned
9 節點2
以root用戶執行rootcrs.pl 腳本清楚grid的配置信息
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -deinstall -force
10 節點1
再次確認ons的資源情況
olsnodes -s -t
rac1 Active Unpinned
rac2 Inactive Unpinned
11 節點1
root用戶執行
刪除另外一個節點的信息
crsctl delete node -n rac2
olsnodes -s -t
rac1 Active Unpinned
12 節點2
oracle用戶執行
/u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid/ "CLUSTER_NODES=rac2" CRS=TRUE -silent -local
13 節點2
卸載grid軟件
oracle用戶執行
/u01/app/11.2.0/grid/deinstall/deinstall -local
root 用戶下執行
rm -rf /etc/oraInst.loc
rm -rf /opt/ORCLfmap
rm -rf /etc/oratab
14 節點1
更新剩余節點的信息
oracle用戶執行：
/u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid/ "CLUSTER_NODES=rac1" CRS=TRUE -silent
15 節點1
檢查是否已經刪除
[04:24:28 oracle(db)@rac1 ~]$ cluvfy stage -post nodedel -n rac2 -verbose
Performing post-checks for node removal
Checking CRS integrity...
Clusterware version consistency passed
The Oracle Clusterware is healthy on node "rac1"
CRS integrity check passed
Result:
Node removal check passed
Post-check for node removal was successful.
可以看到節點刪除成功
