RAC中的srvctl和crs命令

$ srvctl -h
Usage: srvctl [-V]
Usage: srvctl add database -d -o [-m ] [-p ] [-A /netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s ] [-n ] [-y {AUTOMATIC | MANUAL}]
Usage: srvctl add instance -d -i -n
Usage: srvctl add service -d -s -r "" [-a ""] [-P ]
Usage: srvctl add service -d -s -u {-r "" | -a ""}
Usage: srvctl add nodeapps -n -o -A /netmask[/if1[|if2|...]]
Usage: srvctl add asm -n -i -o [-p ]
Usage: srvctl config database
Usage: srvctl config database -d [-a] [-t]
Usage: srvctl config service -d [-s ] [-a] [-S ]
Usage: srvctl config nodeapps -n [-a] [-g] [-s] [-l]
Usage: srvctl config asm -n
Usage: srvctl config listener -n
Usage: srvctl disable database -d
Usage: srvctl disable instance -d -i ""
Usage: srvctl disable service -d -s "" [-i ]
Usage: srvctl disable asm -n [-i ]
Usage: srvctl enable database -d
Usage: srvctl enable instance -d -i ""
Usage: srvctl enable service -d -s "" [-i ]
Usage: srvctl enable asm -n [-i ]
Usage: srvctl getenv database -d [-t ""]
Usage: srvctl getenv instance -d -i [-t ""]
Usage: srvctl getenv service -d -s [-t ""]
Usage: srvctl getenv nodeapps -n [-t ""]
Usage: srvctl modify database -d [-n ] [-m ] [-p ]  [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s ] [-y {AUTOMATIC | MANUAL}]
Usage: srvctl modify instance -d -i -n
Usage: srvctl modify instance -d -i {-s | -r}
Usage: srvctl modify service -d -s -i -t [-f]
Usage: srvctl modify service -d -s -i -r [-f]
Usage: srvctl modify service -d -s -n -i [-a ] [-f]
Usage: srvctl modify asm -n -i [-o ] [-p ]
Usage: srvctl modify nodeapps -n [-o ] [-A ]
Usage: srvctl relocate service -d -s -i -t [-f]
Usage: srvctl remove database -d [-f]
Usage: srvctl remove instance -d -i [-f]
Usage: srvctl remove service -d -s [-i ] [-f]
Usage: srvctl remove nodeapps -n "" [-f]
Usage: srvctl remove asm -n [-i ] [-f]
Usage: srvctl setenv database -d {-t =[,=,...] | -T =}
Usage: srvctl setenv instance -d [-i ] {-t "=[,=,...]" | -T "="}
Usage: srvctl setenv service -d [-s ] {-t "=[,=,...]" | -T "="}
Usage: srvctl setenv nodeapps -n {-t "=[,=,...]" | -T "="}
Usage: srvctl start database -d [-o ]
Usage: srvctl start instance -d -i "" [-o ]
Usage: srvctl start service -d [-s "" [-i ]] [-o ]
Usage: srvctl start nodeapps -n
Usage: srvctl start asm -n [-i ] [-o ]
Usage: srvctl start listener -n [-l ]
Usage: srvctl status database -d [-f] [-v] [-S ]
Usage: srvctl status instance -d -i "" [-f] [-v] [-S ]
Usage: srvctl status service -d [-s ""] [-f] [-v] [-S ]
Usage: srvctl status nodeapps -n
Usage: srvctl status asm -n
Usage: srvctl stop database -d [-o ]
Usage: srvctl stop instance -d -i "" [-o ]
Usage: srvctl stop service -d [-s "" [-i ]] [-f]
Usage: srvctl stop nodeapps -n [-r]
Usage: srvctl stop asm -n [-i ] [-o ]
Usage: srvctl stop listener -n [-l ]
Usage: srvctl unsetenv database -d -t ""
Usage: srvctl unsetenv instance -d [-i ] -t ""
Usage: srvctl unsetenv service -d [-s ] -t ""
Usage: srvctl unsetenv nodeapps -n -t ""
$

從上我們可以看到 srvctl 這個命令工具很強大，可以操作 database, instance ,asm ,service , listener,nodeapps (gsd,vip ,ons)這些資源

 

1.透過srvctl命令來start/stop/check所有的例項
$srvctl start|stop|status database -d rac1
[oracle@rac1 ~]$ srvctl status database -d testrac
Instance testrac1 is running on node rac1
Instance testrac2 is running on node rac2

 

2.start/stop 指定的例項
$srvctl start |stop |status instance -d -i

[oracle@rac1 ~]$ srvctl status instance  -d testrac -i testrac1
Instance testrac1 is running on node rac1

 

3.列出當前rac下所有的
$ srvctl config database -d
[oracle@rac1 ~]$ srvctl config database -d testrac
rac1 testrac1 /u01/product/database
rac2 testrac2 /u01/product/database

 

4.start/stop/check 所有的nodeapps，比如：VIP, GSD, listener, ONS：
$ srvctl start|stop|status nodeapps -n
[oracle@rac1 ~]$ srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is running on node: rac1
Listener is running on node: rac1
ONS daemon is running on node: rac1

 

5.srvctl也可以start/stop ASM例項：
$ srvctl start|stop asm -n [-i ] [-o]
[oracle@rac1 ~]$ srvctl start asm -n rac1

 

6.獲取所有的環境資訊
$ srvctl getenv database -d [-i ]

 

7.設定全域性環境變數：
$ srvctl setenv database -d -t LANG=en

 

8.從OCR中刪除已有的資料庫：
$ srvctl remove database -d

 

9.向OCR中新增一個資料庫：
$ srvctl add database -d -o [-m ] [-p] [-A /netmask] [-r {PRIMARY | PHYSICAL_STANDBY |LOGICAL_STANDBY}] [-s ]

 

10.向OCR中新增一個資料庫的例項：
$ srvctl add instance -d -i -n

 

11.向OCR中新增一個ASM例項：
$ srvctl add asm -n -i -o
 
12.新增一個service
$ srvctl add service -d -s -r [-a ] [-P ] [-u]

例如：

新建了一個服務名叫“msrac”，首先呼叫msdb1伺服器，若有問題則自動呼叫msdb2伺服器。

呼叫RAC中的該服務，只需要注意URL中的service_name為上面配置的“msrac”即可。

jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racdb3-vip)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = racdb4-vip)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = msrac)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = PRECONNECT)(RETRIES = 180)(DELAY = 5))))
 
13.修改在其他節點上的service（修改的是配置，此時使用的例項不變）
$ srvctl modify service -d -s -i -t
 
14.relocate 某個節點的service到其他節點（當taf轉到avail例項上後，又想轉到pre的例項上，用relocate）
srvctl relocate service -d -s - i -t

 

1.檢視狀態的命令
Usage:  crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_member]
        crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_member]
        crs_stat -p [resource_name [...]] [-q]
        crs_stat [-a] application -g
        crs_stat [-a] application -r [-c cluster_member]
        crs_stat -f [resource_name [...]] [-q] [-c cluster_member]
        crs_stat -ls [resource_name [...]] [-q]

 

$crs_stat -t 檢視crs及所有的service的狀態
[oracle@rac1 ~]$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac1       
ora....C1.lsnr application    ONLINE    ONLINE    rac1       
ora.rac1.gsd   application    ONLINE    ONLINE    rac1       
ora.rac1.ons   application    ONLINE    ONLINE    rac1       
ora.rac1.vip   application    ONLINE    ONLINE    rac1       
ora....SM2.asm application    ONLINE    ONLINE    rac2       
ora....C2.lsnr application    ONLINE    ONLINE    rac2       
ora.rac2.gsd   application    ONLINE    ONLINE    rac2       
ora.rac2.ons   application    ONLINE    ONLINE    rac2       
ora.rac2.vip   application    ONLINE    ONLINE    rac2       
ora.testrac.db application    ONLINE    ONLINE    rac1       
ora....c1.inst application    ONLINE    ONLINE    rac1       
ora....c2.inst application    ONLINE    ONLINE    rac2  

 

2.crsctl check crs  檢查CRS相關服務狀態
[oracle@rac1 ~]$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy

 

3.啟動和關閉命令
$ crs_start –all --啟動所有的crs服務
$ crs_stop –all --停止所有的crs服務
$ crsctl start crs --啟動crs服務
$ crsctl stop crs --停止crs服務
$ srvctl start nodeapps -n rac1(rac2) --啟動某節點上所有的應用
$ srvctl stop nodeapps -n rac1(rac2) --停止某節點上所有的應用
$ srvctl start listener -n rac1(rac2) --啟動某個節點的listener
$ srvctl stop listener -n rac1(rac2) --停止某個節點的listener
$ srvctl start instance –d db –i rac1(rac2) --啟動某個instance
$ srvctl stop instance –d db –i rac1(rac2) --停止某個instance
$ srvctl start database –d db --啟動資料庫
$ srvctl stop database –d db --停止資料庫