ORACLE RAC 基础知识总结

来源:互联网 发布:删除数据库表中的数据 编辑:程序博客网 时间:2024/06/09 21:01
[root@racdb01 app]# /sbin/ip ad 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN     link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00    inet 127.0.0.1/8 scope host lo    inet6 ::1/128 scope host        valid_lft forever preferred_lft forever2: eth3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000    link/ether 00:50:56:a3:06:ac brd ff:ff:ff:ff:ff:ff    inet 10.100.21.200/23 brd 10.100.21.255 scope global eth3    inet 10.100.21.204/23 brd 10.100.21.255 scope global secondary eth3:1    inet 10.100.21.201/23 brd 10.100.21.255 scope global secondary eth3:4    inet6 fe80::250:56ff:fea3:6ac/64 scope link        valid_lft forever preferred_lft forever3: eth4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000    link/ether 00:50:56:a3:35:5b brd ff:ff:ff:ff:ff:ff    inet 172.16.6.30/23 brd 172.16.7.255 scope global eth4    inet 169.254.174.146/16 brd 169.254.255.255 scope global eth4:1    inet6 fe80::250:56ff:fea3:355b/64 scope link        valid_lft forever preferred_lft forever
[grid@racdb01 ~]$ oifcfg iflisteth3  10.100.20.0eth4  172.16.6.0eth4  169.254.0.0 -- haip[grid@racdb01 ~]$ oifcfg getifeth3  10.100.20.0  global  public                 -- publiceth4  172.16.6.0  global  cluster_interconnect    -- private 群是否使用HAIP、
select * from gv$cluster_interconnects1   1   eth4:1  169.254.174.146 NO  2   3   eth4:1  169.254.29.101  NO  3   2   eth4:1  169.254.56.240  NO  

关闭某一个节点的服务

[root@racdb01 bin]# ./crsctl stop crsCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racdb01'CRS-2673: Attempting to stop 'ora.crsd' on 'racdb01'CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'racdb01'CRS-2673: Attempting to stop 'ora.oc4j' on 'racdb01'CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'racdb01'CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'racdb01'CRS-2673: Attempting to stop 'ora.OCR.dg' on 'racdb01'CRS-2673: Attempting to stop 'ora.orcl.db' on 'racdb01'CRS-2673: Attempting to stop 'ora.cvu' on 'racdb01'CRS-2677: Stop of 'ora.cvu' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.cvu' on 'racdb02'CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.racdb01.vip' on 'racdb01'CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.scan1.vip' on 'racdb01'CRS-2676: Start of 'ora.cvu' on 'racdb02' succeededCRS-2677: Stop of 'ora.orcl.db' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.DATA.dg' on 'racdb01'CRS-2677: Stop of 'ora.DATA.dg' on 'racdb01' succeededCRS-2677: Stop of 'ora.racdb01.vip' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.racdb01.vip' on 'racdb03'CRS-2677: Stop of 'ora.scan1.vip' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.scan1.vip' on 'racdb02'CRS-2676: Start of 'ora.racdb01.vip' on 'racdb03' succeededCRS-2676: Start of 'ora.scan1.vip' on 'racdb02' succeededCRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'racdb02'CRS-2677: Stop of 'ora.oc4j' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.oc4j' on 'racdb03'CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'racdb02' succeededCRS-2677: Stop of 'ora.OCR.dg' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.asm' on 'racdb01'CRS-2677: Stop of 'ora.asm' on 'racdb01' succeededCRS-2676: Start of 'ora.oc4j' on 'racdb03' succeededCRS-2673: Attempting to stop 'ora.ons' on 'racdb01'CRS-2677: Stop of 'ora.ons' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.net1.network' on 'racdb01'CRS-2677: Stop of 'ora.net1.network' on 'racdb01' succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'racdb01' has completedCRS-2677: Stop of 'ora.crsd' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.ctssd' on 'racdb01'CRS-2673: Attempting to stop 'ora.evmd' on 'racdb01'CRS-2673: Attempting to stop 'ora.asm' on 'racdb01'CRS-2673: Attempting to stop 'ora.mdnsd' on 'racdb01'CRS-2677: Stop of 'ora.mdnsd' on 'racdb01' succeededCRS-2677: Stop of 'ora.evmd' on 'racdb01' succeededCRS-2677: Stop of 'ora.ctssd' on 'racdb01' succeededCRS-2677: Stop of 'ora.asm' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racdb01'CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'racdb01'CRS-2677: Stop of 'ora.cssd' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.crf' on 'racdb01'CRS-2677: Stop of 'ora.crf' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'racdb01'CRS-2677: Stop of 'ora.gipcd' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'racdb01'CRS-2677: Stop of 'ora.gpnpd' on 'racdb01' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racdb01' has completedCRS-4133: Oracle High Availability Services has been stopped.[root@racdb01 bin]# ./crsctl check crsCRS-4639: Could not contact Oracle High Availability Services

再把集群服务起来

[root@racdb01 bin]# pwd/u01/app/11.2.0/grid/bin[root@racdb01 bin]# ./crsctl start crsCRS-4123: Oracle High Availability Services has been started.[root@racdb01 bin]# ./crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4535: Cannot communicate with Cluster Ready ServicesCRS-4530: Communications failure contacting Cluster Synchronization Services daemonCRS-4534: Cannot communicate with Event Manager--wait a minute [root@racdb01 bin]# ./crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online

也可以这样关闭:

[root@racdb01 bin]# ./crsctl stop cluster CRS-2673: Attempting to stop 'ora.crsd' on 'racdb01'CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'racdb01'CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'racdb01'CRS-2673: Attempting to stop 'ora.OCR.dg' on 'racdb01'CRS-2673: Attempting to stop 'ora.orcl.db' on 'racdb01'CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.racdb01.vip' on 'racdb01'CRS-2677: Stop of 'ora.orcl.db' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.DATA.dg' on 'racdb01'CRS-2677: Stop of 'ora.racdb01.vip' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.racdb01.vip' on 'racdb02'CRS-2677: Stop of 'ora.DATA.dg' on 'racdb01' succeededCRS-2676: Start of 'ora.racdb01.vip' on 'racdb02' succeededCRS-2677: Stop of 'ora.OCR.dg' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.asm' on 'racdb01'CRS-2677: Stop of 'ora.asm' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.ons' on 'racdb01'CRS-2677: Stop of 'ora.ons' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.net1.network' on 'racdb01'CRS-2677: Stop of 'ora.net1.network' on 'racdb01' succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'racdb01' has completedCRS-2677: Stop of 'ora.crsd' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.ctssd' on 'racdb01'CRS-2673: Attempting to stop 'ora.evmd' on 'racdb01'CRS-2673: Attempting to stop 'ora.asm' on 'racdb01'CRS-2677: Stop of 'ora.evmd' on 'racdb01' succeededCRS-2677: Stop of 'ora.asm' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racdb01'CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racdb01' succeededCRS-2677: Stop of 'ora.ctssd' on 'racdb01' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'racdb01'CRS-2677: Stop of 'ora.cssd' on 'racdb01' succeeded
[root@racdb01 bin]# ./crsctl start clusterCRS-2672: Attempting to start 'ora.cssdmonitor' on 'racdb01'CRS-2676: Start of 'ora.cssdmonitor' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.cssd' on 'racdb01'CRS-2672: Attempting to start 'ora.diskmon' on 'racdb01'CRS-2676: Start of 'ora.diskmon' on 'racdb01' succeededCRS-2676: Start of 'ora.cssd' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.ctssd' on 'racdb01'CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'racdb01'CRS-2676: Start of 'ora.ctssd' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.evmd' on 'racdb01'CRS-2676: Start of 'ora.evmd' on 'racdb01' succeededCRS-2676: Start of 'ora.cluster_interconnect.haip' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.asm' on 'racdb01'CRS-2676: Start of 'ora.asm' on 'racdb01' succeededCRS-2672: Attempting to start 'ora.crsd' on 'racdb01'CRS-2676: Start of 'ora.crsd' on 'racdb01' succeeded

–以上只是启动或者关闭某一个节点,要想关闭rac的所有节点,可以试着加 -all 参数

–11.2 中 有些命令已经废弃了 ,但是还是继续保留

[grid@racdb01 ~]$ crsctl check crsdCRS-272: This command remains for backward compatibility onlyCluster Ready Services is online[grid@racdb01 ~]$ crsctl check cssdCRS-272: This command remains for backward compatibility onlyCluster Synchronization Services is online[grid@racdb01 ~]$ crsctl check evmdCRS-272: This command remains for backward compatibility onlyEvent Manager is online

–检测集群的服务,在各个节点的分布情况

这个

[grid@racdb01 ~]$ crsctl status resource -t --------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg               ONLINE  ONLINE       racdb01                                                     ONLINE  ONLINE       racdb02                                                     ONLINE  ONLINE       racdb03                                      ora.LISTENER.lsnr               ONLINE  ONLINE       racdb01                                                     ONLINE  ONLINE       racdb02                                                     ONLINE  ONLINE       racdb03                                      ora.OCR.dg               ONLINE  ONLINE       racdb01                                                     ONLINE  ONLINE       racdb02                                                     ONLINE  ONLINE       racdb03                                      ora.asm               ONLINE  ONLINE       racdb01                  Started                            ONLINE  ONLINE       racdb02                  Started                            ONLINE  ONLINE       racdb03                  Started             ora.gsd               OFFLINE OFFLINE      racdb01                                                     OFFLINE OFFLINE      racdb02                                                     OFFLINE OFFLINE      racdb03                                      ora.net1.network               ONLINE  ONLINE       racdb01                                                     ONLINE  ONLINE       racdb02                                                     ONLINE  ONLINE       racdb03                                      ora.ons               ONLINE  ONLINE       racdb01                                                     ONLINE  ONLINE       racdb02                                                     ONLINE  ONLINE       racdb03                                      --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr      1        ONLINE  ONLINE       racdb02                                      ora.cvu      1        ONLINE  ONLINE       racdb02                                      ora.oc4j      1        ONLINE  ONLINE       racdb03                                      ora.orcl.db      1        ONLINE  ONLINE       racdb01                  Open                      2        ONLINE  ONLINE       racdb02                  Open                      3        ONLINE  ONLINE       racdb03                  Open                ora.racdb01.vip      1        ONLINE  ONLINE       racdb01                                      ora.racdb02.vip      1        ONLINE  ONLINE       racdb02                                      ora.racdb03.vip      1        ONLINE  ONLINE       racdb03                                      ora.scan1.vip      1        ONLINE  ONLINE       racdb

不过有些废弃的参数仍然可以继续使用:(crs_*** 系列的命令已经全部废弃,但是功能仍然全部保留,现在的瑞士军刀是crsctl了)

      [grid@racdb01 ~]$ crs_stat -t Name           Type           Target    State     Host        ------------------------------------------------------------ora.DATA.dg    ora....up.type ONLINE    ONLINE    racdb01     ora....ER.lsnr ora....er.type ONLINE    ONLINE    racdb01     ora....N1.lsnr ora....er.type ONLINE    ONLINE    racdb02     ora.OCR.dg     ora....up.type ONLINE    ONLINE    racdb01     ora.asm        ora.asm.type   ONLINE    ONLINE    racdb01     ora.cvu        ora.cvu.type   ONLINE    ONLINE    racdb02     ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               ora....network ora....rk.type ONLINE    ONLINE    racdb01     ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    racdb03     ora.ons        ora.ons.type   ONLINE    ONLINE    racdb01     ora.orcl.db    ora....se.type ONLINE    ONLINE    racdb01     ora....SM1.asm application    ONLINE    ONLINE    racdb01     ora....01.lsnr application    ONLINE    ONLINE    racdb01     ora....b01.gsd application    OFFLINE   OFFLINE               ora....b01.ons application    ONLINE    ONLINE    racdb01     ora....b01.vip ora....t1.type ONLINE    ONLINE    racdb01     ora....SM2.asm application    ONLINE    ONLINE    racdb02     ora....02.lsnr application    ONLINE    ONLINE    racdb02     ora....b02.gsd application    OFFLINE   OFFLINE               ora....b02.ons application    ONLINE    ONLINE    racdb02     ora....b02.vip ora....t1.type ONLINE    ONLINE    racdb02     ora....SM3.asm application    ONLINE    ONLINE    racdb03     ora....03.lsnr application    ONLINE    ONLINE    racdb03     ora....b03.gsd application    OFFLINE   OFFLINE               ora....b03.ons application    ONLINE    ONLINE    racdb03     ora....b03.vip ora....t1.type ONLINE    ONLINE    racdb03     ora.scan1.vip  ora....ip.type ONLINE    ONLINE    racdb02  

crsctl check crs
Check status of OHAS and CRS stack

[grid@racdb01 ~]$ crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online
看看11g grid中的三个基本服务[grid@racdb01 ~]$ crsctl check cluster -all**************************************************************racdb01:CRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online**************************************************************racdb02:CRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online**************************************************************racdb03:CRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online**************************************************************

css 服务具有自己重启节点的功能

[root@racdb01 bin]# ps -ef|grep ocssdroot     17752 14495  0 09:33 pts/0    00:00:00 grep ocssdgrid     26321     1  1 Sep22 ?        00:10:48 /u01/app/11.2.0/grid/bin/ocssd.bin [root@racdb01 bin]# kill -9 26321 

查看alert日志

Error 29701: unexpected return code 6 from the Cluster Synchronization ServiceErrors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lmon_27873.trc:ORA-29701: unable to connect to Cluster Synchronization ServiceSat Sep 23 09:47:07 2017System state dump requested by (instance=1, osid=27873 (LMON)), summary=[abnormal instance termination].

值得注意的这个进程如果被杀掉,或者挂掉的话,os会自动重启,相当暴力

– 后台 daemon

[grid@racdb03 ~]$ crsctl status resource  -t -init--------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm      1        ONLINE  ONLINE       racdb03                  Started             ora.cluster_interconnect.haip      1        ONLINE  ONLINE       racdb03                                      ora.crf      1        ONLINE  ONLINE       racdb03                                      ora.crsd      1        ONLINE  ONLINE       racdb03                                      ora.cssd      1        ONLINE  ONLINE       racdb03                                      ora.cssdmonitor      1        ONLINE  ONLINE       racdb03                                      ora.ctssd      1        ONLINE  ONLINE       racdb03                  ACTIVE:0            ora.diskmon      1        OFFLINE OFFLINE                                                   ora.evmd      1        ONLINE  ONLINE       racdb03                                      ora.gipcd      1        ONLINE  ONLINE       racdb03                                      ora.gpnpd      1        ONLINE  ONLINE       racdb03                                      ora.mdnsd      1        ONLINE  ONLINE       racdb03                                      [grid@racdb03 ~]$ 

调查集群的名字:

[grid@racdb01 ~]$ cemutlo -nracdb-cluster[grid@racdb01 ~]$ which cemutlo/u01/app/11.2.0/grid/bin/cemutlo[grid@racdb01 ~]$ ll /u01/app/11.2.0/grid/bin/cemutlo-rwxr-xr-x 1 grid oinstall 8575 Sep 15 17:30 /u01/app/11.2.0/grid/bin/cemutlo

节点的状态

-- nodeapps[grid@racdb01 ~]$ srvctl status nodeappsVIP racdb01-vip is enabledVIP racdb01-vip is running on node: racdb01VIP racdb02-vip is enabledVIP racdb02-vip is running on node: racdb02VIP racdb03-vip is enabledVIP racdb03-vip is running on node: racdb03Network is enabledNetwork is running on node: racdb01Network is running on node: racdb02Network is running on node: racdb03GSD is disabledGSD is not running on node: racdb01GSD is not running on node: racdb02GSD is not running on node: racdb03ONS is enabledONS daemon is running on node: racdb01ONS daemon is running on node: racdb02ONS daemon is running on node: racdb03

– scan ip

[grid@racdb01 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node racdb01[grid@racdb01 ~]$ srvctl  config scanSCAN name: racdb-scan, Network: 1/10.100.20.0/255.255.254.0/eth3SCAN VIP name: scan1, IP: /racdb-scan/10.100.21.204[grid@racdb01 ~]$ srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is running on node racdb01

—vip

– 根据每个节点去查询

[grid@racdb01 ~]$ srvctl config vip -n racdb01VIP exists: /racdb01-vip/10.100.21.201/10.100.20.0/255.255.254.0/eth3, hosting node racdb01[grid@racdb01 ~]$ srvctl config vip -n racdb02VIP exists: /racdb02-vip/10.100.21.206/10.100.20.0/255.255.254.0/eth3, hosting node racdb02[grid@racdb01 ~]$ srvctl config vip -n racdb03VIP exists: /racdb03-vip/10.100.21.203/10.100.20.0/255.255.254.0/eth3, hosting node racdb03

– 根据vipname 去查询

[grid@racdb01 ~]$ srvctl config vip -i racdb02-vipVIP exists: /racdb02-vip/10.100.21.206/10.100.20.0/255.255.254.0/eth3, hosting node racdb02

关于 –agent

grid     10628     1  0 Sep23 ?        00:18:31 /u01/app/11.2.0/grid/bin/oraagent.binroot     10660     1  0 Sep23 ?        00:18:19 /u01/app/11.2.0/grid/bin/orarootagent.binroot     10706     1  0 Sep23 ?        00:05:12 /u01/app/11.2.0/grid/bin/cssdagentgrid     11142     1  0 Sep23 ?        00:11:35 /u01/app/11.2.0/grid/bin/oraagent.binroot     11149     1  1 Sep23 ?        00:32:15 /u01/app/11.2.0/grid/bin/orarootagent.binoracle   11409     1  0 Sep23 ?        00:20:23 /u01/app/11.2.0/grid/bin/oraagent.bin

agent 的日志目录:

/u01/app/11.2.0/grid/log/racdb01/agent

其中root用户的agent的日志:

root /u01/app/11.2.0/grid/log/racdb01/agent/ohasd/orarootagent_root
rac 的后台进程[grid@racdb01 orarootagent_root]$ crsctl  status  resource -t  -init --------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm      1        ONLINE  ONLINE       racdb01                  Started             ora.cluster_interconnect.haip      1        ONLINE  ONLINE       racdb01                                      ora.crf      1        ONLINE  ONLINE       racdb01                                      ora.crsd      1        ONLINE  ONLINE       racdb01                                      ora.cssd      1        ONLINE  ONLINE       racdb01                                      ora.cssdmonitor      1        ONLINE  ONLINE       racdb01                                      ora.ctssd      1        ONLINE  ONLINE       racdb01                  ACTIVE:0            ora.diskmon      1        OFFLINE OFFLINE                                                   ora.evmd      1        ONLINE  ONLINE       racdb01                                      ora.gipcd      1        ONLINE  ONLINE       racdb01                                      ora.gpnpd      1        ONLINE  ONLINE       racdb01                                      ora.mdnsd      1        ONLINE  ONLINE       racdb01                                      [grid@racdb01 orarootagent_root]$ 

ora.evmd 进程的日志

/u01/app/11.2.0/grid/log/racdb01/evmd
[grid@racdb01 evmd]$ ps -ef|grep evmgrid       408 12405  0 16:33 pts/0    00:00:00 grep evmgrid     10855     1  0 Sep23 ?        00:17:37 /u01/app/11.2.0/grid/bin/evmd.bingrid     11106 10855  0 Sep23 ?        00:00:00 /u01/app/11.2.0/grid/bin/evmlogger.bin -o /u01/app/11.2.0/grid/evm/log/evmlogger.info -l /u01/app/11.2.0/grid/evm/log/evmlogger.logora.mdnsd      1        ONLINE  ONLINE       racdb01   

对应的gnsd的解析

  ora.gpnpd  1        ONLINE  ONLINE       racdb01 

/u01/app/11.2.0/grid/log/racdb01/gpnpd – 有关于节点插入集群

它的日志:

-rw-r–r– 1 grid oinstall 75499 Sep 23 09:51 gpnpd.log
-rw-r–r– 1 grid oinstall 400 Sep 23 09:49 gpnpdOUT.log
-rw-r–r– 1 grid oinstall 6 Sep 23 09:49 racdb01.pid

ora.gipcd

有关时间的进程:

ora.ctssd
1 ONLINE ONLINE racdb01 ACTIVE:0

/u01/app/11.2.0/grid/log/racdb01/ctssd

ora.diskmon
1 OFFLINE OFFLINE

  专门用于exdata  非exadata环境无法启动diskmon 了 本地资源信 [grid@racdb01 oracle]$ cat olr.loc

olrconfig_loc=/u01/app/11.2.0/grid/cdata/racdb01.olr
crs_home=/u01/app/11.2.0/grid
[grid@racdb01 oracle]$ cd /u01/app/11.2.0/grid/cdata/racdb01.olr

[root@racdb01 bin]# ./ocrcheck -local
Status of Oracle Local Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2660
Available space (kbytes) : 259460
ID : 556127896
Device/File Name : /u01/app/11.2.0/grid/cdata/racdb01.olr
Device/File integrity check succeeded

 Local registry integrity check succeeded Logical corruption check succeeded

[root@racdb01 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3052
Available space (kbytes) : 259068
ID : 615736491
Device/File Name : +ocr
Device/File integrity check succeeded

                                Device/File not configured                                Device/File not configured                                Device/File not configured                                Device/File not configured Cluster registry integrity check succeeded Logical corruption check succeeded 观察ctss的运行模式  [grid@racdb01 etc]$ crsctl check ctss

CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0

[root@racdb01 bin]# ./ocrconfig -showbackup

racdb02 2017/09/27 14:06:20 /u01/app/11.2.0/grid/cdata/racdb-cluster/backup00.ocr

racdb02 2017/09/27 10:06:19 /u01/app/11.2.0/grid/cdata/racdb-cluster/backup01.ocr

racdb02 2017/09/27 06:06:19 /u01/app/11.2.0/grid/cdata/racdb-cluster/backup02.ocr

racdb02 2017/09/26 10:06:16 /u01/app/11.2.0/grid/cdata/racdb-cluster/day.ocr

racdb01 2017/09/15 21:50:18 /u01/app/11.2.0/grid/cdata/racdb-cluster/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available

以上信息来自于《大话RAC11G》这本书的实验总结

原创粉丝点击