Oracle RAC 日常基本维护命令-CSDN博客

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