您的位置: 首页  >  IT文章  >  Oracle 10g RAC 惯用维护命令

Oracle 10g RAC 惯用维护命令

分类: IT文章 • 2023-10-09 14:39:07
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     Host        
------------------------
ora....SM1.asm application    ONLINE    ONLINE    vzwc1       
ora....C1.lsnr application    ONLINE    ONLINE    vzwc1       
ora.vzwc1.gsd  application    ONLINE    ONLINE    vzwc1       
ora.vzwc1.ons  application    ONLINE    ONLINE    vzwc1       
ora.vzwc1.vip  application    ONLINE    ONLINE    vzwc1       
ora....SM2.asm application    ONLINE    ONLINE    vzwc2       
ora....C2.lsnr application    ONLINE    ONLINE    vzwc2       
ora.vzwc2.gsd  application    ONLINE    ONLINE    vzwc2       
ora.vzwc2.ons  application    ONLINE    ONLINE    vzwc2       
ora.vzwc2.vip  application    ONLINE    ONLINE    vzwc2       
ora.zwc.db     application    ONLINE    ONLINE    vzwc2       
ora....c1.inst application    ONLINE    ONLINE    vzwc1       
ora....c2.inst application    ONLINE    ONLINE    vzwc2


停止 Oracle 实例，当此实例（和相关服务）关闭后，关闭 ASM 实例。最后，关闭节点应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）。
export ORACLE_SID=zwc1
emctl stop dbconsole
srvctl stop instance -d zwc -i zwc1
srvctl stop asm -n vzwc1
srvctl stop nodeapps -n vzwc1


启动节点应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）。当成功启动节点应用程序后，启动 ASM 实例。最后，启动 Oracle 实例（和相关服务）以及EM。
export ORACLE_SID=zwc1
srvctl start nodeapps -n vzwc1
srvctl start asm -n vzwc1
srvctl start instance -d zwc -i zwc1
emctl start dbconsole


启动/停止所有实例及其启用的服务
srvctl start database -d zwc
srvctl stop database -d zwc

相关推荐