windows RAC 刪除失敗節點，添加節點執行個體操作文檔

標籤：windows oracle rac

windows RAC 刪除失敗節點，添加節點執行個體操作文檔

平台介紹:

（OS:Windows server 2004, Oracle :10.2.0.4.0 ）

實施步驟：

（1）重新安裝rac2的作業系統

（2）刪除節點

（3）添加新節點

（4）配置新的節點

一.安裝RAC2作業系統（步驟略）。

二.刪除節點：

 2.1 Onrac1, or on any node that you are not deleting, run the following   command from CRS_home\bin

 crssetup del –nnnode_name,node_number

650) this.width=650;" width="554" height="47" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="64" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="553" height="351" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="95" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="46" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

2.2可以發現rac3的資源仍然在叢集中註冊。

.C:\oracle\product\10.2.0\crs\BIN>crs_stat-t -v  
名稱          類型           R/RA  F/FT   目標      狀態      主機
----------------------------------------------------------------------
ora....B1.inst application    0/5    0/0   ONLINE    ONLINE    rac1
ora....B2.inst application    0/5    0/0   ONLINE    OFFLINE
ora....RLIB.db application    0/0    0/1   ONLINE    ONLINE    rac1
ora....C1.lsnr application    0/5    0/0    ONLINE   ONLINE    rac1
ora.rac1.gsd   application    0/5    0/0   ONLINE    ONLINE    rac1
ora.rac1.ons   application    0/3    0/0   ONLINE    ONLINE    rac1
ora.rac1.vip   application    0/0    0/0   ONLINE    ONLINE    rac1
ora....C2.lsnr application    0/5    0/0   OFFLINE   OFFLINE
ora.rac2.vip   application    0/0    0/0   OFFLINE   OFFLINE

手動取消rac2的所有資源註冊，可以用crs_stat查看rac2的叢集資源註冊情況：

C:\oracle\product\10.2.0\crs\BIN>crs_unregister.exeora.INTERLIB.INTERLIB2.inst
C:\oracle\product\10.2.0\crs\BIN>crs_unregister.exe ora.rac2.LISTENER_RAC2.lsnr
C:\oracle\product\10.2.0\crs\BIN>crs_unregister.exe ora.rac2.vip

更新節點資訊：

setup.exe -updateNodeListORACLE_HOME=Oracle_home "CLUSTER_NODES={node_list}"

C:\oracle\product\10.2.0\db_1\oui\bin>setup.exe -updateNodeListORACLE_HOME=C:\oracle\product\10.2.0\db_1\ "CLUSTER_NODES={rac1}"

650) this.width=650;" width="554" height="34" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/themes/default/images/word.gif") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

setup.exe-updateNodeList ORACLE_HOME=CRS_home "CLUSTER_NODES={node_list}"

C:\oracle\product\10.2.0\crs\oui\bin>setup.exe -updateNodeListORACLE_HOME=C:\oracle\product\10.2.0\crs\ "CLUSTER_NODES={rac1}"CRS=TRUE

650) this.width=650;" width="554" height="39" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/themes/default/images/word.gif") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

2.3驗證刪除結果：

650) this.width=650;" width="554" height="123" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="53" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

三.添加節點：

 3.1 Go to CRS_home\oui\bin on node1 and runthe addnode.bat script

650) this.width=650;" width="554" height="62" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

650) this.width=650;" width="554" height="404" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

650) this.width=650;" width="554" height="410" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

650) this.width=650;" width="554" height="413" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

3.2 From CRS_home\install on node1,run the crssetup.add.bat script.

650) this.width=650;" width="554" height="267" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

這裡有報錯，請在新的節點執行vipca配置vip;

3.3檢查新的節點CRS相關的所有服務已經啟動：

650) this.width=650;" width="553" height="131" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

在新節點上執行CRS_HOME/bin/vipca.bat，為新的節點配置vip資源；

(網卡名須用英文或者數字)

650) this.width=650;" width="554" height="384" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="389" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="402" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="403" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

配置成功：

650) this.width=650;" width="554" height="471" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

3.4添加ORACLE_HOME到新的節點：Go to Oracle_home\oui\bin on node1 andrun the addnode.bat script
650) this.width=650;" width="554" height="40" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/themes/default/images/word.gif") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

650) this.width=650;" width="553" height="444" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

650) this.width=650;" width="553" height="318" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

3.5.運行DBCA添加新的執行個體：

650) this.width=650;" width="554" height="58" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

650) this.width=650;" width="553" height="398" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="404" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="553" height="435" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="553" height="450" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="491" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="422" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

650) this.width=650;" width="553" height="438" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="423" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

650) this.width=650;" width="554" height="467" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

 

650) this.width=650;" width="554" height="379" src="/e/u261/themes/default/images/spacer.gif" style="background:url("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd;" alt="spacer.gif" />

 

四.配置新的節點：

4.1在存活節點上為新的節點添加REDO log解決上面ORA-02174錯誤，

ALTER  DATABASE ENABLE THREAD 2 執行該SQL，啟用第二個節點的redo。

4.2.啟動新的節點。

========================== The  end =========================================

windows RAC 刪除失敗節點，添加節點執行個體操作文檔