11G RAC 簡單命令
1、檢視叢集狀態:
[root@rac1 ~]# su - grid
[grid@rac1 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
2、資料庫例項狀態:
[grid@rac1 ~]$ srvctl status database -d yoon
Instance yoon1 is running on node rac1
Instance yoon2 is running on node rac2
3、單例項狀態:
[grid@rac1 ~]$ srvctl status instance -d yoon -i yoon1
Instance yoon1 is running on node rac1
[grid@rac1 ~]$ srvctl status instance -d yoon -i yoon2
Instance yoon2 is running on node rac2
4、node應用程式狀態:
[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
5、所有的配置資料庫:
[grid@rac1 ~]$ srvctl config database
yoon
7、資料庫配置資訊:
[grid@rac1 ~]$ srvctl config database -d yoon -a
Database unique name: yoon
Database name: yoon
Oracle home: /u01/app/oracle/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/yoon/spfileyoon.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: yoon
Database instances: yoon1,yoon2
Disk Groups: DATA,FLUSH
Mount point paths:
Services:
Type: RAC
Database is enabled
Database is administrator managed
8、ASM狀態:
[grid@rac1 ~]$ srvctl status asm
ASM is running on rac2,rac1
9、ASM配置資訊:
[grid@rac1 ~]$ srvctl config asm -a
ASM home: /u01/app/grid/11.2.0
ASM listener: LISTENER
ASM is enabled.
10、監聽狀態:
[grid@rac1 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac2,rac1
11、監聽配置資訊:
[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
12、SCAN狀態:
[grid@rac1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
13、SCAN配置資訊:
[grid@rac1 ~]$ srvctl config scan
SCAN name: rac-scan, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-scan/192.168.1.10
14、節點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
15、VIP配置資訊:
[grid@rac1 ~]$ srvctl config vip -n rac1
VIP exists: /rac1-vip/192.168.1.18/192.168.1.0/255.255.255.0/eth0, hosting node rac1
[grid@rac1 ~]$ srvctl config vip -n rac2
VIP exists: /rac2-vip/192.168.1.19/192.168.1.0/255.255.255.0/eth0, hosting node rac2
16、節點應用程式配置系資訊:
[grid@rac1 ~]$ srvctl config nodeapps -a -g -s -l
Warning:-l option has been deprecated and will be ignored.
Network exists: 1/192.168.1.0/255.255.255.0/eth0, type static
VIP exists: /rac1-vip/192.168.1.18/192.168.1.0/255.255.255.0/eth0, hosting node rac1
VIP exists: /rac2-vip/192.168.1.19/192.168.1.0/255.255.255.0/eth0, hosting node rac2
GSD exists
ONS exists: Local port 6100, remote port 6200, 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
17、啟動和停止叢集:
[root@rac1 ~]#/u01/app/grid/11.2.0/bin/crsctl stop cluster -all
[root@rac1 ~]#/u01/app/grid/11.2.0/bin/crsctl start cluster -all
[root@rac1 ~]#srvctl stop database -d yoon
[root@rac1 ~]#srvctl start database -d yoon
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-1061468/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- LINUX上RAC中CHM命令的簡單示例Linux
- 11G RAC OLR維護命令
- oracle 11g rac 叢集操作命令Oracle
- Oracle 11g RAC 常用命令Oracle
- 11g rac ASM下最簡單歸檔開啟/關閉方法ASM
- 管理oracle 11g RAC 常用命令Oracle
- git簡單命令Git
- zookeeper簡單命令
- docker簡單命令Docker
- Oracle 11g RAC 配置單例項 DataGuardOracle單例
- docker命令簡單使用Docker
- Linux簡單命令Linux
- vi命令簡單使用
- tcpdump命令簡單使用TCP
- 簡單實用命令
- shell簡單命令大全。
- du命令 and touch命令簡單實用
- 11g r2 RAC的啟停命令概述1
- Oracle RAC的TAF簡單測試Oracle
- oracle 10g RAC簡單管理Oracle 10g
- Oracle 11g RAC到單例項OGG同步Oracle單例
- 簡單使用rpm命令
- git stash 命令簡單使用Git
- Linux簡單命令(一)Linux
- 簡單介紹 ldd 命令
- Git常用的簡單命令Git
- vi命令簡單實用
- (網路資料)管理oracle 11g RAC 常用命令Oracle
- Oracle 11g RAC crs_stat 命令結果完整顯示Oracle
- ORACLE 11G RAC--叢集應用層命令掃盲Oracle
- sed命令簡單使用示例分享
- DB2_簡單命令列DB2命令列
- ogg簡單維護命令
- aix的幾個簡單命令AI
- rename命令的簡單應用
- HPUX簡單帶庫操作命令UX
- ORACLE 11G RAC--維護叢集的OCR命令介紹Oracle
- 簡單批處理內部命令簡介