Oracle 11gR2 RAC 常用維護操作

一．啟動和停止叢集

在Oracle 11gR2 下的RAC，架構發生了變化。CRS的資訊也是放在ASM 例項裡的，所以要關asm,必須關閉crs, 如果還使用了acfs的話，一關crs那麼acfs裡的資訊也不能訪問了，所以一般不重啟機器，不輕易關crs, 其他的service可以根據自己的需要去stop/start。

注意：

11g RAC 開啟資源相對比較慢(即使命令後面顯示的資源都start succeeded,通過crs_stat -t檢視都不一定online), 需要耐心並檢視log。

在Oracle 11gR2 裡引入了Oracle Restart的特性，其用來管理Cluster Resource。關於Oracle Restart，參考我的Blog：

Oracle 11g 新特性 -- Oracle Restart 說明

http://blog.csdn.net/tianlesoftware/article/details/8435670

1.1 使用crsctl stop has/crsctl stopcrs

用root使用者，在Oracle11gR2中停止和啟動叢集的命令如下：

#crsctl stop has [-f]

#crsctl start has

注意：

對於crsctl stop has 只有一個可選的引數就是-f，該命令只能停執行該命令伺服器上的HAS.而不能停所有節點上的。所以要把RAC 全部停掉，需要在所有節點執行該命令。

下面的2個命令：使用crs 和使用has 效果是完全一樣的：

#crsctl stop crs [-f]

#crsctl start crs

示例：

--停止HAS

[root@rac1 bin]# ./crsctl stophas

CRS-2791:Starting shutdown of Oracle High Availability Services-managed resources on'rac1'

CRS-2673:Attempting to stop 'ora.crsd' on 'rac1'

CRS-2790:Starting shutdown of Cluster Ready Services-managed resources on 'rac1'

CRS-2673:Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'

CRS-2673:Attempting to stop 'ora.OCRVOTING.dg' on 'rac1'

CRS-2673:Attempting to stop 'ora.sdd.db' on 'rac1'

CRS-2673:Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'

CRS-2673:Attempting to stop 'ora.oc4j' on 'rac1'

CRS-2673:Attempting to stop 'ora.cvu' on 'rac1'

CRS-2677: Stopof 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.scan1.vip' on 'rac1'

CRS-2677: Stopof 'ora.LISTENER.lsnr' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.rac1.vip' on 'rac1'

CRS-2677: Stopof 'ora.rac1.vip' on 'rac1' succeeded

CRS-2672:Attempting to start 'ora.rac1.vip' on 'rac2'

CRS-2677: Stopof 'ora.scan1.vip' on 'rac1' succeeded

CRS-2672:Attempting to start 'ora.scan1.vip' on 'rac2'

CRS-2676:Start of 'ora.scan1.vip' on 'rac2' succeeded

CRS-2676:Start of 'ora.rac1.vip' on 'rac2' succeeded

CRS-2672:Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2'

CRS-2677: Stopof 'ora.sdd.db' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.DATA.dg' on 'rac1'

CRS-2673:Attempting to stop 'ora.FRA.dg' on 'rac1'

CRS-2676:Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded

CRS-2677: Stopof 'ora.FRA.dg' on 'rac1' succeeded

CRS-2677: Stopof 'ora.DATA.dg' on 'rac1' succeeded

CRS-2677: Stopof 'ora.oc4j' on 'rac1' succeeded

CRS-2672:Attempting to start 'ora.oc4j' on 'rac2'

CRS-2677: Stopof 'ora.cvu' on 'rac1' succeeded

CRS-2672:Attempting to start 'ora.cvu' on 'rac2'

CRS-2676:Start of 'ora.cvu' on 'rac2' succeeded

CRS-2677: Stopof 'ora.OCRVOTING.dg' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.asm' on 'rac1'

CRS-2677: Stopof 'ora.asm' on 'rac1' succeeded

CRS-2676:Start of 'ora.oc4j' on 'rac2' succeeded

CRS-2673:Attempting to stop 'ora.ons' on 'rac1'

CRS-2677: Stopof 'ora.ons' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.net1.network' on 'rac1'

CRS-2677: Stopof 'ora.net1.network' on 'rac1' succeeded

CRS-2792:Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed

CRS-2677: Stopof 'ora.crsd' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.mdnsd' on 'rac1'

CRS-2673:Attempting to stop 'ora.ctssd' on 'rac1'

CRS-2673:Attempting to stop 'ora.evmd' on 'rac1'

CRS-2673:Attempting to stop 'ora.asm' on 'rac1'

CRS-2677: Stopof 'ora.evmd' on 'rac1' succeeded

CRS-2677: Stopof 'ora.mdnsd' on 'rac1' succeeded

CRS-2677: Stopof 'ora.ctssd' on 'rac1' succeeded

CRS-2677: Stopof 'ora.asm' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'

CRS-2677: Stopof 'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.cssd' on 'rac1'

CRS-2677: Stopof 'ora.cssd' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.crf' on 'rac1'

CRS-2677: Stopof 'ora.crf' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.gipcd' on 'rac1'

CRS-2677: Stopof 'ora.gipcd' on 'rac1' succeeded

CRS-2673:Attempting to stop 'ora.gpnpd' on 'rac1'

CRS-2677: Stopof 'ora.gpnpd' on 'rac1' succeeded

CRS-2793:Shutdown of Oracle High Availability Services-managed resources on 'rac1' hascompleted

CRS-4133:Oracle High Availability Services has been stopped.

[root@rac1bin]#

注意：

我這裡測試的是Oracle11gR2的環境，我們在節點1上執行該命令，只把節點1上的程式停了，而把相關的資源轉移到我們的節點2上了，因此也證實了我們上面的說的，該命令只爭對當前伺服器有效。

--啟動HAS：

[root@rac1bin]# ./crsctl start has

CRS-4123:Oracle High Availability Services has been started.

[root@rac1bin]#

從上面看只是啟動了HAS。實際上後面會把Oracle Restart 管理的資源都會啟動。這個可以使用crs_stat命令來程式驗證，不過Oracle 11g的程式啟動過程比較慢，需要耐心等待。

[root@rac1u01]# sh crs_stat.sh

Name Target State Host

---------------------------------------- --------- -------

ora.DATA.dg ONLINE ONLINE rac1

ora.FRA.dg ONLINE ONLINE rac1

ora.LISTENER.lsnr ONLINE ONLINE rac1

ora.LISTENER_SCAN1.lsnr ONLINE ONLINE rac2

ora.OCRVOTING.dg ONLINE ONLINE rac1

ora.asm ONLINE ONLINE rac1

ora.cvu ONLINE ONLINE rac2

ora.gsd OFFLINE OFFLINE

ora.net1.network ONLINE ONLINE rac1

ora.oc4j ONLINE ONLINE rac2

ora.ons ONLINE ONLINE rac1

ora.rac1.ASM1.asm ONLINE ONLINE rac1

ora.rac1.LISTENER_RAC1.lsnr ONLINE ONLINE rac1

ora.rac1.gsd OFFLINE OFFLINE

ora.rac1.ons ONLINE ONLINE rac1

ora.rac1.vip ONLINE ONLINE rac1

ora.rac2.ASM2.asm ONLINE ONLINE rac2

ora.rac2.LISTENER_RAC2.lsnr ONLINE ONLINE rac2

ora.rac2.gsd OFFLINE OFFLINE

ora.rac2.ons ONLINE ONLINE rac2

ora.rac2.vip ONLINE ONLINE rac2

ora.scan1.vip ONLINE ONLINE rac2

ora.sdd.db ONLINE ONLINE rac2

1.2 使用crsctl stop cluster [-all]…

該命令的語法如下：

crsctl stop cluster [[-all]|[-n[...]]] [-f]

crsctl start cluster [[-all]|[-n[...]]]

與1.1 節最大的不同，該引數支援的選項更多，可以同時操控所有的節點。如果不指定引數，那麼只對當前節點有效。

如：

[root@rac1 ~]# ./crsctl start cluster -n rac1 rac2

--停止當前節點叢集：

[root@rac1 bin]# ./crsctl stop cluster

CRS-2673: Attempting to stop 'ora.crsd' on'rac1'

CRS-2790: Starting shutdown of ClusterReady Services-managed resources on 'rac1'

CRS-2673: Attempting to stop'ora.LISTENER.lsnr' on 'rac1'

CRS-2673: Attempting to stop'ora.OCRVOTING.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.sdd.db'on 'rac1'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on'rac1' succeeded

CRS-2673: Attempting to stop 'ora.rac1.vip'on 'rac1'

CRS-2677: Stop of 'ora.rac1.vip' on 'rac1'succeeded

CRS-2672: Attempting to start'ora.rac1.vip' on 'rac2'

CRS-2677: Stop of 'ora.sdd.db' on 'rac1'succeeded

CRS-2673: Attempting to stop 'ora.DATA.dg'on 'rac1'

CRS-2673: Attempting to stop 'ora.FRA.dg'on 'rac1'

CRS-2676: Start of 'ora.rac1.vip' on 'rac2'succeeded

CRS-2677: Stop of 'ora.FRA.dg' on 'rac1'succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'rac1'succeeded

CRS-2677: Stop of 'ora.OCRVOTING.dg' on'rac1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on'rac1'

CRS-2677: Stop of 'ora.asm' on 'rac1'succeeded

CRS-2673: Attempting to stop 'ora.ons' on'rac1'

CRS-2677: Stop of 'ora.ons' on 'rac1'succeeded

CRS-2673: Attempting to stop'ora.net1.network' on 'rac1'

CRS-2677: Stop of 'ora.net1.network' on'rac1' succeeded

CRS-2792: Shutdown of Cluster ReadyServices-managed resources on 'rac1' has completed

CRS-2677: Stop of 'ora.crsd' on 'rac1'succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on'rac1'

CRS-2673: Attempting to stop 'ora.evmd' on'rac1'

CRS-2673: Attempting to stop 'ora.asm' on'rac1'

CRS-2677: Stop of 'ora.evmd' on 'rac1'succeeded

CRS-2677: Stop of 'ora.ctssd' on 'rac1'succeeded

CRS-2677: Stop of 'ora.asm' on 'rac1'succeeded

CRS-2673: Attempting to stop'ora.cluster_interconnect.haip' on 'rac1'

CRS-2677: Stop of'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on'rac1'

CRS-2677: Stop of 'ora.cssd' on 'rac1'succeeded

[root@rac1 bin]#

這裡只停了節點1，相關程式全飄到節點2了，如下：

[root@rac2 u01]# sh crs_stat.sh

Name Target State Host

------------------------------ ------------------- -------

ora.DATA.dg ONLINE ONLINE rac2

ora.FRA.dg ONLINE ONLINE rac2

ora.LISTENER.lsnr ONLINE ONLINE rac2

ora.LISTENER_SCAN1.lsnr ONLINE ONLINE rac2

ora.OCRVOTING.dg ONLINE ONLINE rac2

ora.asm ONLINE ONLINE rac2

ora.cvu ONLINE ONLINE rac2

ora.gsd OFFLINE OFFLINE

ora.net1.network ONLINE ONLINE rac2

ora.oc4j ONLINE ONLINE rac2

ora.ons ONLINE ONLINE rac2

ora.rac1.ASM1.asm ONLINE OFFLINE

ora.rac1.LISTENER_RAC1.lsnr ONLINE OFFLINE

ora.rac1.gsd OFFLINE OFFLINE

ora.rac1.ons ONLINE OFFLINE

ora.rac1.vip ONLINE ONLINE rac2

ora.rac2.ASM2.asm ONLINE ONLINE rac2

ora.rac2.LISTENER_RAC2.lsnr ONLINE ONLINE rac2

ora.rac2.gsd OFFLINE OFFLINE

ora.rac2.ons ONLINE ONLINE rac2

ora.rac2.vip ONLINE ONLINE rac2

ora.scan1.vip ONLINE ONLINE rac2

ora.sdd.db ONLINE ONLINE rac2

--啟用當前節點：

[root@rac1 bin]#./crsctl start cluster

CRS-2672: Attempting to start'ora.cssdmonitor' on 'rac1'

CRS-2676: Start of 'ora.cssdmonitor' on'rac1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on'rac1'

CRS-2672: Attempting to start 'ora.diskmon'on 'rac1'

CRS-2676: Start of 'ora.diskmon' on 'rac1'succeeded

CRS-2676: Start of 'ora.cssd' on 'rac1'succeeded

CRS-2672: Attempting to start 'ora.ctssd'on 'rac1'

CRS-2672: Attempting to start'ora.cluster_interconnect.haip' on 'rac1'

CRS-2676: Start of 'ora.ctssd' on 'rac1'succeeded

CRS-2672: Attempting to start 'ora.evmd' on'rac1'

CRS-2676: Start of 'ora.evmd' on 'rac1'succeeded

CRS-2676: Start of'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.asm' on'rac1'

CRS-2676: Start of 'ora.asm' on 'rac1'succeeded

CRS-2672: Attempting to start 'ora.crsd' on'rac1'

CRS-2676: Start of 'ora.crsd' on 'rac1'succeeded

[root@rac1 bin]#

1.3 檢查叢集的狀態

--簡單的輸出:

[root@rac1 bin]# ./crsctl check cluster

[root@rac1 bin]# ./crsctl check crs

--詳細的資訊:

# crs_stat -t

使用crsctl check crs命令，如下：

[root@rac1 bin]# ./crsctl check crs

CRS-4638: Oracle High Availability Servicesis online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Servicesis online

CRS-4533: Event Manager is online

[root@rac1 bin]# ./crsctl check cluster

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Servicesis online

CRS-4533: Event Manager is online

二．停止和啟動Resource

在第一節中，看到直接停止叢集，相關的Resource 也會被停止。但一些實際情況下，我們操作更多的是對某些資源的操作。具體就是使用SRVCTL 命令

1.1. 官網說明

SRVCTL Command Reference for Oracle Restart

http://docs.oracle.com/cd/E11882_01/server.112/e25494/restart005.htm

檢視命令幫助：

Srvclt –h

這個命令顯示的結果太長，不好檢視，可以進一步的檢視幫助：

--使用-h：

[grid@rac1 ~]$ srvctl start -h

The SRVCTL start command starts, OracleClusterware enabled, non-running objects.

Usage: srvctl start database -d [-o ] [-n ]

Usage: srvctl start instance -d {-n [-i ] | -i } [-o]

Usage: srvctl start service -d [-s "" [-n | -i ] ] [-o ]

Usage: srvctl start nodeapps [-n ][-g] [-v]

Usage: srvctl start vip { -n | -i } [-v]

Usage: srvctl start asm [-n] [-o ]

Usage: srvctl start listener [-l] [-n ]

Usage: srvctl start scan [-i] [-n ]

Usage: srvctl start scan_listener [-n] [-i ]

Usage: srvctl start oc4j [-v]

Usage: srvctl start home -o -s -n

Usage: srvctl start filesystem -d [-n ]

Usage: srvctl start diskgroup -g [-n ""]

Usage: srvctl start gns [-l] [-n ] [-v]

Usage: srvctl start cvu [-n]

For detailed help on each command andobject and its options use:

srvctl

--或者命令不敲全：

[grid@rac1 ~]$ srvctl database

Usage: srvctl

For detailed help on each command andobject and its options use:

srvctl -h or

srvctl

1.2 示例

1.2.1 檢查叢集狀態

[grid@rac1 ~]$ crsctl check cluster

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Servicesis online

CRS-4533: Event Manager is online

1.2.2 所有Oracle例項（資料庫狀態）

[grid@rac1 ~]$ srvctl status database -dsdd

Instance sdd1 is running on node rac1

Instance sdd2 is running on node rac2

1.2.3 檢查單個例項狀態

[grid@rac1 ~]$ srvctl status instance -dsdd -i sdd1

Instance sdd1 is running on node rac1

[grid@rac1 ~]$

1.2.4節點應用程式狀態

[grid@rac1 ~]$ srvctl status nodeapps

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

VIP rac2-vip is enabled

VIP rac2-vip is running on node: rac2

Network is enabled

Network is running on node: rac1

Network is running on node: rac2

GSD is disabled

GSD is not running on node: rac1

GSD is not running on node: rac2

ONS is enabled

ONS daemon is running on node: rac1

ONS daemon is running on node: rac2

1.2.5 列出所有的配置資料庫

[grid@rac1 ~]$ srvctl config database

sdd

1.2.6 資料庫配置

[grid@rac1 ~]$ srvctl config database -dsdd -a

Database unique name: sdd

Database name: sdd

Oracle home: /u01/app/oracle/11.2.0/db_1

Oracle user: oracle

Spfile: +DATA/sdd/spfilesdd.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: sdd

Database instances: sdd1,sdd2

Disk Groups: DATA,FRA

Mount point paths:

Services:

Type: RAC

Database is enabled

Database is administrator managed

1.2.7 ASM狀態以及ASM配置

[grid@rac1 ~]$ srvctl status asm

ASM is running on rac2,rac1

[grid@rac1 ~]$ srvctl status asm -a

ASM is running on rac2,rac1

ASM is enabled.

1.2.8 TNS監聽器狀態以及配置

[grid@rac1 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s):rac2,rac1

[grid@rac1 ~]$ srvctl config listener -a

Name: LISTENER

Network: 1, Owner: grid

Home:

/u01/app/grid/11.2.0 on node(s) rac2,rac1

End points: TCP:1521

1.2.8 SCAN狀態以及配置

[grid@rac1 ~]$ srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac1

[grid@rac1 ~]$ srvctl config scan

SCAN name: rac-scan, Network:1/192.168.16.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP:/rac-scan/192.168.16.207

1.2.9 VIP各個節點的狀態以及配置

[grid@rac1 ~]$ srvctl status vip -n rac1

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

[grid@rac1 ~]$ srvctl status vip -n rac2

VIP rac2-vip is enabled

VIP rac2-vip is running on node: rac2

[grid@rac1 ~]$ srvctl config vip -n rac1

VIP exists: /rac1-vip/192.168.16.201/192.168.16.0/255.255.255.0/eth0,hosting node rac1

[grid@rac1 ~]$ srvctl config vip -n rac2

VIP exists:/rac2-vip/192.168.16.203/192.168.16.0/255.255.255.0/eth0, hosting node rac2

[grid@rac1 ~]$

1.2.10 節點應用程式配置（VIP、GSD、ONS、監聽器）

[grid@rac1 ~]$ srvctl config nodeapps -a -g-s -l

Warning:-l option has been deprecated andwill be ignored.

Network exists:1/192.168.16.0/255.255.255.0/eth0, type static

VIP exists:/rac1-vip/192.168.16.201/192.168.16.0/255.255.255.0/eth0, hosting node rac1

VIP exists:/rac2-vip/192.168.16.203/192.168.16.0/255.255.255.0/eth0, hosting node rac2

GSD exists

ONS exists: Local port 6100, remote port6200, EM port 2016

Name: LISTENER

Network: 1, Owner: grid

Home:

/u01/app/grid/11.2.0 on node(s) rac2,rac1

End points: TCP:1521

1.3 語法簡匯

1.3.1 資料庫與例項

srvctl config database # 列出安裝的資料庫
srvctl config database -d rac -a # 檢查資料庫相關的資訊
srvctlstatus database -d RAC # 檢查資料庫的狀態
srvctl status instance -d RAC -i rac1 # 檢查指定例項的狀態

srvctl config asm -a # ASM配置
srvctl status asm # ASM的狀態

srvctl start database -d rac # 啟動資料庫
srvctl stop database -d rac # 關閉資料庫

srvctl start instance -d rac -i rac1 # 啟動指定的例項
srvctl stop instance -d rac -i rac2 # 關閉指定例項

1.3.2 網路相關的命令

srvctl status listener # 檢查TNS listener的狀態
srvctl config scan # SCAN的配置
srvctl status scan # SCAN listener狀態, 包含當前執行節點的資訊

# 檢查VIP的配置及狀態
srvctl status vip -n rac1
srvctl config vip -n rac1

1.3.3 檢視各資源狀態(nodeapps節點應用程式，ASM例項，資料庫等)

[root@db02 u01]# crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.DATA.dg ora....up.type ONLINE ONLINE db02

ora.FRA.dg ora....up.type ONLINE ONLINE db02

ora....ER.lsnr ora....er.type ONLINE ONLINE db02

ora....N1.lsnr ora....er.type ONLINE ONLINE db02

ora....N2.lsnr ora....er.type ONLINE ONLINE db02

ora....N3.lsnr ora....er.type ONLINE ONLINE db02

ora.OCR.dg ora....up.type ONLINE ONLINE db02

ora.asm ora.asm.type ONLINE ONLINE db02

ora....-01.vip ora....t1.type ONLINE ONLINE db02

ora....SM2.asm application ONLINE ONLINE db02

ora....02.lsnr application ONLINE ONLINE db02

ora....-02.gsd application OFFLINE OFFLINE

ora....-02.ons application ONLINE ONLINE db02

ora....-02.vip ora....t1.type ONLINE ONLINE db02

ora.cvu ora.cvu.type ONLINE ONLINE db02

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE db02

ora.oc4j ora.oc4j.type ONLINE ONLINE db02

ora.ons ora.ons.type ONLINE ONLINE db02

ora.orcl.db ora....se.type ONLINE ONLINE db02

ora....taf.svc ora....ce.type ONLINE ONLINE db02

ora.scan1.vip ora....ip.type ONLINE ONLINE db02

ora.scan2.vip ora....ip.type ONLINE ONLINE db02

ora.scan3.vip ora....ip.type ONLINE ONLINE db02

在11g R2中，預設 oc4j和gsd資源是 disable的；oc4j 是用於WLM 的一個資源, WLM在 11.2.0.2 才可用；gsd是 CRS 用於跟 9i RAC 進行通訊的一個模組,是為了向後相容才保留的，不影響效能；建議不要刪除, 也不要嘗試開啟他們, 忽略即可。

ora.gsd is OFFLINE by default ifthere is no 9i database in the cluster.

ora.oc4j is OFFLINE in 11.2.0.1 as DatabaseWorkload Management(DBWLM) is unavailable. these can be ignored in11gR2 RAC.

狀態檢查也可以使用如下命令：

crsctl stat resource –t

或者

crsctl stat resource

更多內容參考：

Oracle 11gR2RAC 程式說明

http://blog.csdn.net/tianlesoftware/article/details/6009962

1.3.4 綜合

1、通過SRVCTL命令來start/stop/check所有的例項:

srvctl start|stop|status database -d

2、start/stop指定的例項：

srvctl start|stop|statusinstance -d -i

3、列出當前RAC下所有的

srvctl config database -d

4、start/stop/check 所有的nodeapps，比如：VIP, GSD, listener, ONS：

srvctl start|stop|status nodeapps -n

5、如果你使用ASM，srvctl也可以start/stop ASM例項：

srvctl start|stop asm -n [-i ] [-o]

6、可以獲取所有的環境資訊：

srvctl getenv database -d [-i]

7、設定全域性環境和變數：

srvctl setenv database -d -t LANG=en

8、從OCR中刪除已有的資料庫：

srvctl remove database -d

9、向OCR中新增一個資料庫的例項：

srvctl add instance -d -i -n

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24558279/viewspace-1131791/，如需轉載，請註明出處，否則將追究法律責任。

Oracle 11gR2 RAC 常用維護操作

一．啟動和停止叢集

1.1 使用crsctl stop has/crsctl stopcrs

1.2 使用crsctl stop cluster [-all]…

1.3 檢查叢集的狀態

二．停止和啟動Resource

1.1. 官網說明

1.2 示例

1.2.1 檢查叢集狀態

1.2.2 所有Oracle例項（資料庫狀態）

1.2.3 檢查單個例項狀態

1.2.4節點應用程式狀態

1.2.5 列出所有的配置資料庫

1.2.6 資料庫配置

1.2.7 ASM狀態以及ASM配置

1.2.8 TNS監聽器狀態以及配置

1.2.8 SCAN狀態以及配置

1.2.9 VIP各個節點的狀態以及配置

1.2.10 節點應用程式配置（VIP、GSD、ONS、監聽器）

1.3 語法簡匯

1.3.1 資料庫與例項

1.3.2 網路相關的命令

1.3.3 檢視各資源狀態(nodeapps節點應用程式，ASM例項，資料庫等)

1.3.4 綜合

相關文章