当前位置:数据库 > Oracle >>

Oracle 10g RAC常用维护命令

Oracle 10g RAC常用维护命令
 
所有实例和服务的状态
[oracle@vzwc1 ~]$ srvctl status database -d zwc  
Instance zwc1 is running on node vzwc1  
Instance zwc2 is running on node vzwc2  
 
单个实例的状态
[oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc1  
Instance zwc1 is running on node vzwc1  
[oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc2  
Instance zwc2 is running on node vzwc2  
 
特定节点上节点应用程序的状态
[oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc1  
VIP is running on node: vzwc1  
GSD is running on node: vzwc1  
Listener is running on node: vzwc1  
ONS daemon is running on node: vzwc1  
[oracle@vzwc1 ~]$   
[oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc2  
VIP is running on node: vzwc2  
GSD is running on node: vzwc2  
Listener is running on node: vzwc2  
ONS daemon is running on node: vzwc2  
 
ASM 实例的状态
[oracle@vzwc1 ~]$ srvctl status asm -n vzwc1  
ASM instance +ASM1 is running on node vzwc1.  
[oracle@vzwc1 ~]$   
[oracle@vzwc1 ~]$ srvctl status asm -n vzwc2  
ASM instance +ASM2 is running on node vzwc2.  
 
显示 RAC 数据库的配置
[oracle@vzwc1 ~]$ srvctl config database -d zwc  
vzwc1 zwc1 /u01/app/oracle/product/10.2.0/db_1  
vzwc2 zwc2 /u01/app/oracle/product/10.2.0/db_1  
 
显示节点应用程序的配置 —(VIP、GSD、ONS、监听)
[oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc1 -a -g -s -l  
VIP exists.: /vzwc1-vip/192.168.1.151/255.255.255.0/eth0  
GSD exists.  
ONS daemon exists.  
Listener exists.  
[oracle@vzwc1 ~]$   
[oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc2 -a -g -s -l   
VIP exists.: /vzwc2-vip/192.168.1.152/255.255.255.0/eth0  
GSD exists.  
ONS daemon exists.  
Listener exists.  
 
显示 ASM 实例的配置
[oracle@vzwc1 ~]$ srvctl config asm -n vzwc1  
+ASM1 /u01/app/oracle/product/10.2.0/db_1  
[oracle@vzwc1 ~]$   
[oracle@vzwc1 ~]$ srvctl config asm -n vzwc2  
+ASM2 /u01/app/oracle/product/10.2.0/db_1  
 
RAC正在运行的实例
SQL> SELECT  
  2      inst_id  
  , instance_number inst_no  
  , instance_name inst_name  
  , parallel  
  6    , status  
  7    , database_status db_status  
  8    , active_state state  
  9    , host_name host  
 10  FROM gv$instance  
 11  /  
  
   INST_ID    INST_NO INST_NAME        PAR STATUS       DB_STATUS         STATE     HOST  
---------- ---------- ---------------- --- ------------ ----------------- --------- ----------  
         1          1 zwc1             YES OPEN         ACTIVE            NORMAL    vzwc1  
         2          2 zwc2             YES OPEN         ACTIVE            NORMAL    vzwc2  
 
磁盘组中的所有数据文件
SQL> select name from v$datafile  
  2  union  
  3  select member from v$logfile  
  4  union  
  5  select name from v$controlfile  
  6  union  
  7  select name from v$tempfile  
  8  /  
  
NAME  
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  
+DATADG/zwc/controlfile/current.260.810684377  
+DATADG/zwc/datafile/example.264.810684397  
+DATADG/zwc/datafile/sysaux.257.810684333  
+DATADG/zwc/datafile/system.256.810684333  
+DATADG/zwc/datafile/undotbs1.258.810684333  
+DATADG/zwc/datafile/undotbs2.265.810684503  
+DATADG/zwc/datafile/users.259.810684333  
+DATADG/zwc/onlinelog/group_1.261.810684379  
+DATADG/zwc/onlinelog/group_2.262.810684383  
+DATADG/zwc/onlinelog/group_3.266.810684557  
+DATADG/zwc/onlinelog/group_4.267.810684559  
+DATADG/zwc/tempfile/temp.263.810684393  
+FLASHDG/zwc/controlfile/current.256.810684377  
+FLASHDG/zwc/onlinelog/group_1.257.810684381  
+FLASHDG/zwc/onlinelog/group_2.258.810684385  
+FLASHDG/zwc/onlinelog/group_3.259.810684559  
+FLASHDG/zwc/onlinelog/group_4.260.810684561  
 
OCR存放路径
[oracle@vzwc1 ~]$ ocrcheck  
Status of Oracle Cluster Registry is as follows :  
         Version                  :          2  
         Total space (kbytes)     :    1043916  
         Used space (kbytes)      :       3832  
         Available space (kbytes) :    1040084  
         ID                       : 1906841437  
         Device/File Name         : /dev/raw/raw1  
                                    Device/File integrity check succeeded  
  
                                    Device/File not configured  
  
         Cluster registry integrity check succeeded  
 
VOTEDISK存放路径
[oracle@vzwc1 ~]$ crsctl query css votedisk  
 0.     0    /dev/raw/raw2  
  
located 1 votedisk(s).  
 
clusterware版本
[oracle@vzwc1 ~]$ crsctl query crs activeversion  
CRS active version on the cluster is [10.2.0.5.0]  
 
RAC资源查看
[oracle@vzwc1 ~]$ crs_stat -t  
Name           Type           Target    State   &nbs
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,