Oracle RAC 日常基本维护命令
Oracle RAC 日常基本维护命令
RAC 集群状态查看、管理命令均在GRID用户下进行
集群资源状态
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.ARCH.dg ora....up.type ONLINE ONLINE webrac1
ora.CRS.dg ora....up.type ONLINE ONLINE webrac1
ora.DATA.dg ora....up.type ONLINE ONLINE webrac1
ora....ER.lsnr ora....er.type ONLINE ONLINE webrac1
ora....N1.lsnr ora....er.type ONLINE ONLINE webrac2
ora.asm ora.asm.type ONLINE ONLINE webrac1
ora.cvu ora.cvu.type ONLINE ONLINE webrac2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE webrac1
ora.oc4j ora.oc4j.type ONLINE ONLINE webrac2
ora.ons ora.ons.type ONLINE ONLINE webrac1
ora.racdb.db ora....se.type ONLINE ONLINE webrac1
ora.scan1.vip ora....ip.type ONLINE ONLINE webrac2
ora....SM1.asm application ONLINE ONLINE webrac1
ora....C1.lsnr application ONLINE ONLINE webrac1
ora....ac1.gsd application OFFLINE OFFLINE
ora....ac1.ons application ONLINE ONLINE webrac1
ora....ac1.vip ora....t1.type ONLINE ONLINE webrac1
ora....SM2.asm application ONLINE ONLINE webrac2
ora....C2.lsnr application ONLINE ONLINE webrac2
ora....ac2.gsd application OFFLINE OFFLINE
ora....ac2.ons application ONLINE ONLINE webrac2
ora....ac2.vip ora....t1.type ONLINE ONLINE webrac2
集群服务状态
$ crsctl check cluster -all
**************************************************************
webrac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
webrac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
所有实例服务状态
$ srvctl status database -d racdb
Instance racdb1 is running on node webrac1
Instance racdb2 is running on node webrac2
单实例服务状态
$ srvctl status instance -d racdb -i racdb1
Instance racdb1 is running on node webrac1
所有节点应用程序状态
$ srvctl status nodeapps
VIP webrac1-vip is enabled
VIP webrac1-vip is running on node: webrac1
VIP webrac2-vip is enabled
VIP webrac2-vip is running on node: webrac2
Network is enabled
Network is running on node: webrac1
Network is running on node: webrac2
GSD is disabled
GSD is not running on node: webrac1
GSD is not running on node: webrac2
ONS is enabled
ONS daemon is running on node: webrac1
ONS daemon is running on node: webrac2
所有ASM实例状态
$ srvctl status asm
ASM is running on webrac2,webrac1
RAC数据库配置
$ srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: DATA,ARCH
Mount point paths:
Services:
Type: RAC
Database is administrator managed
集群管理
--关闭\启动单个实例
$ srvctl stop\start instance -d racdb -i racdb1
--关闭\启动所有实例
$ srvctl stop\start database -d orcl
--关闭\启动CRS
$ crsctl stop\start crs
--关闭\启动集群服务
$ crsctl stop\start cluster -all
crsctl start\stop crs 是单节管理
crsctl start\stop cluster [-all 所有节点] 可以管理多个节点
crsctl start\stop crs 管理crs 包含进程 OHASD
crsctl start\stop cluster 不包含OHASD进程 要先启动 OHASD进程才可以使用
srvctl stop\start database 启动\停止所有实例及其启用的服务
使用SQL查看RAC状态信息
节点状态
SQL> SELECT inst_id
,instance_number inst_no
,instance_name inst_name
,parallel
,STATUS
,database_status db_status
,active_state STATE
,host_name host
FROM gv$instance
ORDER BY inst_id;
INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST
-------- -------- ---------- --- ------- ------------ -------
1 1 racdb1 YES OPEN ACTIVE NORMAL webrac1
2 2 racdb2 YES OPEN ACTIVE NORMAL webrac2
ASM磁盘信息
SQL> select failgroup,path,mode_status,total_mb,free_mb from v$asm_disk_stat;
FAILGROUP PATH MODE_STATUS TOTAL_MB FREE_MB
----------------- ------------------ ----------- --------- ----------
DATA_0000 /dev/raw/raw3 ONLINE 260896 255246
ARCH_0000 /dev/raw/raw2 ONLINE 153600 152903
CRS_0000 /dev/raw/raw1 ONLINE 10240 9844
ASM磁盘组容量
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
CRS 10240 9844
ARCH 153600 152903
DATA 260896 255246
相关链接
你不可不看的 Oracle RAC 日常基本维护命令
crsctl start/stop crs and crsctl start/stop cluster 区别
