当前位置: 移动技术网 > IT编程>数据库>Oracle > ORACLERAC必学会的基础知识总结

ORACLERAC必学会的基础知识总结

2017年12月25日  | 移动技术网IT编程  | 我要评论

ORACLERAC必学会的基础知识总结

[root@racdb01 app]# /sbin/ip ad 
1: lo:  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 forever
2: eth3:  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 forever
3: eth4:  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 iflist
eth3  10.100.20.0
eth4  172.16.6.0
eth4  169.254.0.0 -- haip
[grid@racdb01 ~]$ oifcfg getif
eth3  10.100.20.0  global  public                 -- public
eth4  172.16.6.0  global  cluster_interconnect    -- private 群是否使用HAIP、
select * from gv$cluster_interconnects

1   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 crs
CRS-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' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'racdb02'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.racdb01.vip' on 'racdb01'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'racdb01'
CRS-2676: Start of 'ora.cvu' on 'racdb02' succeeded
CRS-2677: Stop of 'ora.orcl.db' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'racdb01'
CRS-2677: Stop of 'ora.DATA.dg' on 'racdb01' succeeded
CRS-2677: Stop of 'ora.racdb01.vip' on 'racdb01' succeeded
CRS-2672: Attempting to start 'ora.racdb01.vip' on 'racdb03'
CRS-2677: Stop of 'ora.scan1.vip' on 'racdb01' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'racdb02'
CRS-2676: Start of 'ora.racdb01.vip' on 'racdb03' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'racdb02'
CRS-2677: Stop of 'ora.oc4j' on 'racdb01' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'racdb03'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'racdb02' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'racdb01'
CRS-2677: Stop of 'ora.asm' on 'racdb01' succeeded
CRS-2676: Start of 'ora.oc4j' on 'racdb03' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'racdb01'
CRS-2677: Stop of 'ora.ons' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'racdb01'
CRS-2677: Stop of 'ora.net1.network' on 'racdb01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'racdb01' has completed
CRS-2677: Stop of 'ora.crsd' on 'racdb01' succeeded
CRS-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' succeeded
CRS-2677: Stop of 'ora.evmd' on 'racdb01' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'racdb01' succeeded
CRS-2677: Stop of 'ora.asm' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racdb01'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'racdb01'
CRS-2677: Stop of 'ora.cssd' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'racdb01'
CRS-2677: Stop of 'ora.crf' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'racdb01'
CRS-2677: Stop of 'ora.gipcd' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'racdb01'
CRS-2677: Stop of 'ora.gpnpd' on 'racdb01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racdb01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@racdb01 bin]# ./crsctl check crs
CRS-4639: Could not contact Oracle High Availability Services

再把集群服务起来

[root@racdb01 bin]# pwd
/u01/app/11.2.0/grid/bin
[root@racdb01 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

[root@racdb01 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager

--wait a minute 
[root@racdb01 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-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' succeeded
CRS-2673: Attempting to stop 'ora.racdb01.vip' on 'racdb01'
CRS-2677: Stop of 'ora.orcl.db' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'racdb01'
CRS-2677: Stop of 'ora.racdb01.vip' on 'racdb01' succeeded
CRS-2672: Attempting to start 'ora.racdb01.vip' on 'racdb02'
CRS-2677: Stop of 'ora.DATA.dg' on 'racdb01' succeeded
CRS-2676: Start of 'ora.racdb01.vip' on 'racdb02' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'racdb01'
CRS-2677: Stop of 'ora.asm' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'racdb01'
CRS-2677: Stop of 'ora.ons' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'racdb01'
CRS-2677: Stop of 'ora.net1.network' on 'racdb01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'racdb01' has completed
CRS-2677: Stop of 'ora.crsd' on 'racdb01' succeeded
CRS-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' succeeded
CRS-2677: Stop of 'ora.asm' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racdb01'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racdb01' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'racdb01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'racdb01'
CRS-2677: Stop of 'ora.cssd' on 'racdb01' succeeded
[root@racdb01 bin]# ./crsctl start cluster
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'racdb01'
CRS-2676: Start of 'ora.cssdmonitor' on 'racdb01' succeeded
CRS-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' succeeded
CRS-2676: Start of 'ora.cssd' on 'racdb01' succeeded
CRS-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' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'racdb01'
CRS-2676: Start of 'ora.evmd' on 'racdb01' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'racdb01' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'racdb01'
CRS-2676: Start of 'ora.asm' on 'racdb01' succeeded
CRS-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 crsd
CRS-272: This command remains for backward compatibility only
Cluster Ready Services is online
[grid@racdb01 ~]$ crsctl check cssd
CRS-272: This command remains for backward compatibility only
Cluster Synchronization Services is online
[grid@racdb01 ~]$ crsctl check evmd
CRS-272: This command remains for backward compatibility only
Event 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 crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
看看11g grid中的三个基本服务

[grid@racdb01 ~]$ crsctl check cluster -all
**************************************************************
racdb01:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
racdb02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
racdb03:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

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

[root@racdb01 bin]# ps -ef|grep ocssd
root     17752 14495  0 09:33 pts/0    00:00:00 grep ocssd
grid     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 Service
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lmon_27873.trc:
ORA-29701: unable to connect to Cluster Synchronization Service
Sat Sep 23 09:47:07 2017
System 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 -n
racdb-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 nodeapps
VIP racdb01-vip is enabled
VIP racdb01-vip is running on node: racdb01
VIP racdb02-vip is enabled
VIP racdb02-vip is running on node: racdb02
VIP racdb03-vip is enabled
VIP racdb03-vip is running on node: racdb03
Network is enabled
Network is running on node: racdb01
Network is running on node: racdb02
Network is running on node: racdb03
GSD is disabled
GSD is not running on node: racdb01
GSD is not running on node: racdb02
GSD is not running on node: racdb03
ONS is enabled
ONS daemon is running on node: racdb01
ONS daemon is running on node: racdb02
ONS daemon is running on node: racdb03

– scan ip

[grid@racdb01 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node racdb01
[grid@racdb01 ~]$ srvctl  config scan
SCAN name: racdb-scan, Network: 1/10.100.20.0/255.255.254.0/eth3
SCAN VIP name: scan1, IP: /racdb-scan/10.100.21.204



[grid@racdb01 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node racdb01

—vip

– 根据每个节点去查询

[grid@racdb01 ~]$ srvctl config vip -n racdb01
VIP 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 racdb02
VIP 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 racdb03
VIP 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-vip
VIP 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.bin
root     10660     1  0 Sep23 ?        00:18:19 /u01/app/11.2.0/grid/bin/orarootagent.bin
root     10706     1  0 Sep23 ?        00:05:12 /u01/app/11.2.0/grid/bin/cssdagent
grid     11142     1  0 Sep23 ?        00:11:35 /u01/app/11.2.0/grid/bin/oraagent.bin
root     11149     1  1 Sep23 ?        00:32:15 /u01/app/11.2.0/grid/bin/orarootagent.bin
oracle   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 evm
grid       408 12405  0 16:33 pts/0    00:00:00 grep evm
grid     10855     1  0 Sep23 ?        00:17:37 /u01/app/11.2.0/grid/bin/evmd.bin
grid     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.log


ora.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

如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复

相关文章:

验证码:
移动技术网