一,查询磁盘状况
1,如何查看表决磁盘的相关信息
[root@rac-two bin]# ./crsctl query css votedisk
2,如何备份表决磁盘:
dd if=/dev/raw/raw3 of=/tmp/votedisk.bak
3,恢复表决磁盘:
dd if=/tmp/votedisk.bak of=/dev/raw/raw3
4,删除votedisk
/app/crs/product/11.0.6/crs/bin/crsctl delete crss votedisk /dev/raw/raw5
5,[grid@rac1 ~]$ crsctl delete css votedisk ORCL:DISK3
CRS-4258: Addition and deletion of voting files are not allowed because the voting files are on ASM
[grid@rac1 ~]$
6,[oracle@rac1 ~]$ /u01/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2680
Available space (kbytes) : 259440
ID : 2063842061
Device/File Name : +DATA
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 bypassed due to non-privileged user
[oracle@rac1 ~]$
7,oracle@rac1 init.d]$ su - grid
Password:
[grid@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1
ONLINE ONLINE rac2 Started
ora.eons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.oc4j
1 OFFLINE OFFLINE
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.radb.db
1 ONLINE ONLINE rac1
2 ONLINE ONLINE rac2 Open
ora.scan1.vip
1 ONLINE ONLINE rac1
[grid@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1
ONLINE ONLINE rac2 Started
ora.eons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.oc4j
1 OFFLINE OFFLINE
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.radb.db
1 ONLINE ONLINE rac1
2 ONLINE ONLINE rac2 Open
ora.scan1.vip
1 ONLINE ONLINE rac1
[grid@rac1 ~]$
二,备份与恢复
1,查看备份磁盘
[grid@rac1 ~]$ ocrconfig -showbackup
PROT-24: Auto backups for the Oracle Cluster Registry are not available
PROT-25: Manual backups for the Oracle Cluster Registry are not available
[grid@rac1 ~]$
2,恢复
ocrconfig -restore /app/crs/product/11.0.6/crs/cdata/racluster/backup01.ocr
3,查看配置
[grid@rac1 ~]$ more /etc/oracle/ocr.loc
ocrconfig_loc=+DATA
local_only=FALSE
[grid@rac1 ~]$
4,查看进程
[grid@rac1 ~]$ ps -ef | grep d.bin
root 4694 1 0 10:00 ? 00:00:13 /u01/grid/bin/ohasd.bin reboot
grid 4821 1 0 10:00 ? 00:00:28 /u01/grid/bin/oraagent.bin
root 4823 1 0 10:00 ? 00:00:04 /u01/grid/bin/orarootagent.bin
grid 4846 1 0 10:00 ? 00:00:00 /u01/grid/bin/gipcd.bin
grid 4859 1 0 10:00 ? 00:00:00 /u01/grid/bin/mdnsd.bin
grid 4874 1 0 10:00 ? 00:00:01 /u01/grid/bin/gpnpd.bin
root 8645 1 0 10:47 ? 00:00:04 /u01/grid/bin/cssdmonitor
root 8662 1 0 10:48 ? 00:00:05 /u01/grid/bin/cssdagent
grid 8664 1 0 10:48 ? 00:00:01 /u01/grid/bin/diskmon.bin -d -f
grid 8688 1 0 10:48 ? 00:00:40 /u01/grid/bin/ocssd.bin
root 8754 1 0 10:50 ? 00:00:01 /u01/grid/bin/octssd.bin
grid 8770 1 0 10:50 ? 00:00:02 /u01/grid/bin/evmd.bin
grid 8888 1 0 10:51 ? 00:00:00 /u01/grid/bin/oclskd.bin
root 8920 1 0 10:51 ? 00:00:07 /u01/grid/bin/crsd.bin reboot
root 8966 1 0 10:51 ? 00:00:00 /u01/grid/bin/oclskd.bin
grid 9013 8770 0 10:51 ? 00:00:00 /u01/grid/bin/evmlogger.bin -o /u01/grid/evm/log/evmlogger.info -l /u01/grid/evm/log/evmlogger.log
grid 9055 1 0 10:51 ? 00:00:06 /u01/grid/bin/oraagent.bin
root 9059 1 0 10:51 ? 00:00:42 /u01/grid/bin/orarootagent.bin
grid 9283 1 0 10:52 ? 00:00:00 /u01/grid/bin/tnslsnr LISTENER -inherit
oracle 9549 1 0 10:58 ? 00:00:26 /u01/grid/bin/oraagent.bin
oracle 9773 1 0 11:00 ? 00:00:00 /u01/grid/bin/oclskd.bin
grid 18618 1 0 13:46 ? 00:00:00 /u01/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
grid 22527 21370 0 14:58 pts/2 00:00:00 grep d.bin
[grid@rac1 ~]$
注:
occsd:用于管理与协调集群中各个节点的关系,并用于节点通信。该进程非常的重要,如果这个进程异常中止,会导致系统自动重启。在某些极端的情况下,如果ocssd无法正常启动,就会导致操作系统循环重启。
crsd:监控节点各个资源,当某个资源发生异常是,自动重启或者切换该资源。
evmd:是一个基于后台的事件检测程序。
oclskd:该守护进程是Oracle 11g(11.10.6)新增的一个后台进程,主要是用于监控RAC数据库节点实例,当某个实例挂起时,就重启该节点。
三,管理表决磁盘
voting disk (表决磁盘)主要用于记录节点成员信息,例如包包含哪些节点成员、节点添加删除信息的记录等 。
1,查看voting disk
要查看voting disk信息,可以执行如下命令:
crsctl query css votedisk
2,备份voting disk
voting disk 的信息很重要,需要定期备份votedisk,例如:
dd if=/dev/raw/raw3 of=/tmp/votedisk.bak
3,恢复voting disk
dd if=/tmp/votedisk.bak of=/dev/raw/rawe
4,删除voting disk镜像盘
如果删除一块表决磁盘,可以执行如下命令:
crsctl delete css votedisk /dev/raw/raw5 -force
这个操作 以root用户身份。
5,添加一块表决磁盘
添加一块表决磁盘时,执行如下命令:
crsctl add css votedisk /dev/raw/raw5 -force
这个操作以root用户身份
OCR磁盘主要用户记录节点成员的配置信息,如数据库、服务、实例、vip地址、监听、应用进程等CRS资源配置信息,OCR可以存储在裸设备或者集群文件系统上。
(1),检查ocr设置
可以通过如下命令查看当前的OCR设置ocrcheck
(2),OCR的备份与恢复
默认情况下,Oracle每四个小时自动备份一个OCR,并保留三个有效版本,但是仅保存在集群的某一个节点上。
查看自动备份OCR文件的路径,执行如下命令
四,导入导出
1,ocrconfig -showbackup
2,ocrconfig -restore \>/app/oracrs/product/11.0.6/cdata/rac-cluster/backup01.ocr
3,其实OCR也可以通过手动的方式导出、导入、方法如下:
ocrconfig -export /tmp/ocr_bak
ocrconfig -import /tmp/ocr_bak
五,添加OCR镜像盘
向磁盘组中添加OCR磁盘的基本步骤如下:
1,执行命令crsctl stop crs 停掉CRS服务
2,创建用于镜像OCR的RAW设备,例如:/dev/raw/raw11
3,执行"ocrconfig -export"命令导出OCR的信息
4,修改/etc/oracle/ocr.loc 文件,添加新增的raw设备,
5,执行命令“orcconfig -import”将OCR备份信息导入磁盘
6,检查ocr设置信息,看是否增加成功
7,最后用"crsctl start crs" 启动crs服务
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29611940/viewspace-1164486/
,如需转载,请注明出处,否则将追究法律责任。