ORACLERAC必学会的基础知识总结
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
上一篇: C/C++混合编程代码实例
下一篇: oracle分页查询千万级优化