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》这本书的实验总结
- ORACLE RAC 基础知识总结
- Oracle RAC 基础知识
- Oracle RAC相关以及基础知识
- Oracle 11g RAC 的一些基础知识
- Oracle 11g RAC 基础知识详解
- Oracle RAC 运维总结
- oracle 基础知识总结
- Oracle基础知识整理总结
- Oracle 数据库基础知识总结
- Oracle阶段性基础知识总结
- Oracle RAC 日志 存放路径总结
- Oracle RAC 日志 存放路径总结
- ORACLE 11G R2 RAC安装总结
- ORACLE-RAC的CRS维护命令总结
- 基础知识:oracle数据字典总结
- 基础知识:oracle数据字典总结
- Oracle Fusion Middleware 基础知识总结
- Oracle RAC
- [微信小程序]下拉刷新上拉加载更多
- 产品经理常用网站搜集
- day16<集合框架+>
- day17<集合框架+>
- oracle 修改字符集 修改为ZHS16GBK
- ORACLE RAC 基础知识总结
- day18<集合框架+>
- bzoj 3375: [Usaco2004 Mar]Paranoid Cows 发疯的奶牛
- MD5加密工具类
- day19<异常&File类>
- QT写helloworld
- day20<IO流>
- bat文件一键部署maven项目
- day21<IO流+&FIle递归>