1.檢查數據庫狀態,狀態正常

[oracle@racdb01 rac]$ crs_stat -t
Name?????????? Type?????????? Target??? State???? Host???????
------------------------------------------------------------
ora.rac.db???? application??? ONLINE??? ONLINE??? racdb01????
ora....s1.inst application??? ONLINE??? ONLINE??? racdb01????
ora....s2.inst application??? ONLINE??? ONLINE??? racdb02????
ora....esdb.cs application??? ONLINE??? ONLINE??? racdb01????
ora....es1.srv application??? ONLINE??? ONLINE??? racdb01????
ora....01.lsnr application??? ONLINE??? ONLINE??? racdb01????
ora....b01.gsd application??? ONLINE??? ONLINE??? racdb01????
ora....b01.ons application??? ONLINE??? ONLINE??? racdb01????
ora....b01.vip application??? ONLINE??? ONLINE??? racdb01????
ora....02.lsnr application??? ONLINE??? ONLINE??? racdb02????
ora....b02.gsd application??? ONLINE??? ONLINE??? racdb02????
ora....b02.ons application??? ONLINE??? ONLINE??? racdb02????
ora....b02.vip application??? ONLINE??? ONLINE??? racdb02
2. AP程序打開,用Toad發現連接到instance 1
3. shutdown instance1
[oracle@racdb01 rac]$srvctl stop instance -d rac -i rac1
4. 檢查數據庫狀態
[oracle@racdb01 rac]$ crs_stat -t
Name?????????? Type?????????? Target??? State???? Host???????
------------------------------------------------------------
ora.rac.db???? application??? ONLINE??? ONLINE??? racdb01????
ora....s1.inst application??? OFFLINE?? OFFLINE??????????????
ora....s2.inst application??? ONLINE??? ONLINE??? racdb02????
ora....esdb.cs application??? ONLINE??? ONLINE??? racdb01????
ora....es1.srv application??? ONLINE??? ONLINE??? racdb02????
ora....01.lsnr application??? ONLINE??? ONLINE??? racdb01????
ora....b01.gsd application??? ONLINE??? ONLINE??? racdb01????
ora....b01.ons application??? ONLINE??? ONLINE??? racdb01????
ora....b01.vip application??? ONLINE??? ONLINE??? racdb01????
ora....02.lsnr application??? ONLINE??? ONLINE??? racdb02????
ora....b02.gsd application??? ONLINE??? ONLINE??? racdb02????
ora....b02.ons application??? ONLINE??? ONLINE??? racdb02????
ora....b02.vip application??? ONLINE??? ONLINE??? racdb02
5. 用toad察看連接狀態,發現所有AP均自動連接到instance2上,功能正常
6. startup instance 1
[oracle@racdb01 rac]$ crs_start ora.rac.rac1.inst
7. 檢查數據庫狀態
[oracle@racdb01 rac]$ crs_stat -t
Name?????????? Type?????????? Target??? State???? Host???????
------------------------------------------------------------
ora.rac.db???? application??? ONLINE??? ONLINE??? racdb01????
ora....s1.inst application??? ONLINE??? ONLINE??? racdb01????
ora....s2.inst application??? ONLINE??? ONLINE??? racdb02????
ora....esdb.cs application??? ONLINE??? ONLINE??? racdb01????
ora....es1.srv application??? ONLINE??? ONLINE??? racdb02????
ora....01.lsnr application??? ONLINE??? ONLINE??? racdb01????
ora....b01.gsd application??? ONLINE??? ONLINE??? racdb01????
ora....b01.ons application??? ONLINE??? ONLINE??? racdb01????
ora....b01.vip application??? ONLINE??? ONLINE??? racdb01????
ora....02.lsnr application??? ONLINE??? ONLINE??? racdb02????
ora....b02.gsd application??? ONLINE??? ONLINE??? racdb02????
ora....b02.ons application??? ONLINE??? ONLINE??? racdb02????
ora....b02.vip application??? ONLINE??? ONLINE??? racdb02?
8. shutdown instance 2
[oracle@racdb02 ~]$ srvctl stop instance -d rac -i rac2
9. 檢查數據庫狀態
[oracle@racdb02 ~]$ crs_stat -t
Name?????????? Type?????????? Target??? State???? Host???????
------------------------------------------------------------
ora.rac.db???? application??? ONLINE??? ONLINE??? racdb01????
ora....s1.inst application??? ONLINE??? ONLINE??? racdb01????
ora....s2.inst application??? OFFLINE?? OFFLINE??????????????
ora....esdb.cs application??? ONLINE??? ONLINE??? racdb01????
ora....es1.srv application??? ONLINE??? ONLINE??? racdb01????
ora....01.lsnr application??? ONLINE??? ONLINE??? racdb01????
ora....b01.gsd application??? ONLINE??? ONLINE??? racdb01????
ora....b01.ons application??? ONLINE??? ONLINE??? racdb01????
ora....b01.vip application??? ONLINE??? ONLINE??? racdb01????
ora....02.lsnr application??? ONLINE??? ONLINE??? racdb02????
ora....b02.gsd application??? ONLINE??? ONLINE??? racdb02????
ora....b02.ons application??? ONLINE??? ONLINE??? racdb02????
ora....b02.vip application??? ONLINE??? ONLINE??? racdb02
10. 檢查AP程序連接狀態,發現所有AP均自動連接到instance 1,功能正常
11. startup instance 2
[oracle@racdb02 ~]$ crs_start ora.rac.rac2.inst
12. 檢查數據庫狀態
[oracle@racdb02 ~]$ crs_stat -t
Name?????????? Type?????????? Target??? State???? Host???????
------------------------------------------------------------
ora.rac.db???? application??? ONLINE??? ONLINE??? racdb01????
ora....s1.inst application??? ONLINE??? ONLINE??? racdb01????
ora....s2.inst application??? ONLINE??? ONLINE??? racdb02????
ora....esdb.cs application??? ONLINE??? ONLINE??? racdb01????
ora....es1.srv application??? ONLINE??? ONLINE??? racdb01????
ora....01.lsnr application??? ONLINE??? ONLINE??? racdb01????
ora....b01.gsd application??? ONLINE??? ONLINE??? racdb01????
ora....b01.ons application??? ONLINE??? ONLINE??? racdb01????
ora....b01.vip application??? ONLINE??? ONLINE??? racdb01????
ora....02.lsnr application??? ONLINE??? ONLINE??? racdb02????
ora....b02.gsd application??? ONLINE??? ONLINE??? racdb02????
ora....b02.ons application??? ONLINE??? ONLINE??? racdb02????
ora....b02.vip application??? ONLINE??? ONLINE??? racdb02

轉載于:https://www.cnblogs.com/kevinsun/archive/2008/12/15/1355149.html

總結

以上是生活随笔為你收集整理的Oracle 1204 RAC failover 测试 (二)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。