OCR,VOTEDISK各种测试之三有备份恢复OCR及VOTEDISK

最新推荐文章于 2022-01-14 23:41:12 发布
最新推荐文章于 2022-01-14 23:41:12 发布
阅读量1.3k 收藏
点赞数
分类专栏： oracle 容灾
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kiwi_kid/article/details/40481281
版权 
查看当前orc的备份情况
[04:46:45 root(grid)@rac1 ~]# ocrconfig -showbackup
rac1     2014/10/27 04:30:23     /tmp/backup00.ocr
rac1     2014/10/27 04:30:23     /tmp/day.ocr
rac1     2014/10/27 04:30:23     /tmp/week.ocr
rac1     2014/10/27 04:12:17     /tmp/backup_20141027_041217.ocr
查看当前crs的状况
[04:39:17 root(grid)@rac1 ~]# crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type OFFLINE   OFFLINE               
ora....N1.lsnr ora....er.type OFFLINE   OFFLINE               
ora.OCRVOTE.dg ora....up.type ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.cvu        ora.cvu.type   OFFLINE   OFFLINE               
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora.prod.db    ora....se.type OFFLINE   OFFLINE               
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    OFFLINE   OFFLINE               
ora.rac1.gsd   application    OFFLINE   OFFLINE               
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    OFFLINE   OFFLINE               
ora.rac2.gsd   application    OFFLINE   OFFLINE               
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1        
ora.scan1.vip  ora....ip.type OFFLINE   OFFLINE  

两个节点手动停止crs服务
[04:47:02 root(grid)@rac1 ~]# crsctl stop crs -f
[00:15:28 root(grid)@rac2 ~]# crsctl stop crs -f

做破坏性试验把ocrvotedisk格掉
[04:51:11 root(grid)@rac1 ~]# dd if=/dev/zero of=/dev/sdd1 bs=1024k count=200
1+0 records in
1+0 records out
1048576 bytes (1.0 MB) copied, 0.0172843 s, 60.7 MB/s
[04:51:36 root(grid)@rac1 ~]# oracleasm querydisk /dev/sdd1
Device "/dev/sdd1" is not marked as an ASM disk
我们发现此时原来的仲裁盘已经不属于任何asmdisk了
这个时候我们尝试启动crs

[04:52:56 root(grid)@rac1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

查看grid报警日志：
[ohasd(2248)]CRS-2767:Resource state recovery not attempted for 'ora.cssdmonitor' as its target state is OFFLINE
2014-10-27 04:49:40.221: 
[ohasd(2248)]CRS-2769:Unable to failover resource 'ora.cssdmonitor'.
2014-10-27 04:49:42.525: 
[gpnpd(2609)]CRS-2329:GPNPD on node rac1 shutdown. 
2014-10-27 04:55:05.740: 
[ohasd(39995)]CRS-2112:The OLR service started on node rac1.
2014-10-27 04:55:05.771: 
[ohasd(39995)]CRS-1301:Oracle High Availability Service started on node rac1.
2014-10-27 04:55:05.777: 
[ohasd(39995)]CRS-8017:location: /etc/oracle/lastgasp has 2 reboot advisory log files, 0 were announced and 0 errors occurred
2014-10-27 04:55:10.133: 
[/u01/app/11.2.0/grid/bin/orarootagent.bin(40038)]CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running). 
2014-10-27 04:55:14.687: 
[gpnpd(40133)]CRS-2328:GPNPD started on node rac1. 
2014-10-27 04:55:17.612: 
[cssd(40207)]CRS-1713:CSSD daemon is started in clustered mode
2014-10-27 04:55:19.094: 
[ohasd(39995)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
2014-10-27 04:55:19.096: 
[ohasd(39995)]CRS-2769:Unable to failover resource 'ora.diskmon'.
2014-10-27 04:55:21.823: 
[cssd(40207)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/rac1/cssd/ocssd.log

[05:04:32 root(grid)@rac1 ~]# crsctl start crs -excl -nocrs 
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'
CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'
CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac1'
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded
CRS-2676: Start of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac1'
CRS-2676: Start of 'ora.asm' on 'rac1' succeeded

[05:15:03 oracle(grid)@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 27 05:15:08 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
05:15:08 idle> 
05:15:34 idle> create diskgroup OCRVOTE external redundancy  
05:16:22   2  disk 'ORCL:OCRVOTE'
05:16:22   3   ATTRIBUTE 'compatible.rdbms' = '11.2', 'compatible.asm' = '11.2';
Diskgroup created.

[05:06:57 root(grid)@rac1 ~]# ocrconfig -showbackup
PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy

rac1     2014/10/27 04:30:23     /tmp/backup00.ocr

rac1     2014/10/27 04:30:23     /tmp/day.ocr

rac1     2014/10/27 04:30:23     /tmp/week.ocr

rac1     2014/10/27 04:12:17     /tmp/backup_20141027_041217.ocr
[05:18:03 root(grid)@rac1 ~]# ocrconfig -restore /tmp/backup00.ocr
[05:18:34 root(grid)@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3112
         Available space (kbytes) :     259008
         ID                       : 1190837800
         Device/File Name         :   +OCRVOTE
                                    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
OCR已经恢复，我们现在来回复votedisk
[05:19:11 root(grid)@rac1 ~]# crsctl query css votedisk
Located 0 voting disk(s).
可以看到，现在还没有votedisk的任何的信息
[05:20:22 root(grid)@rac1 ~]# crsctl replace votedisk +OCRVOTE
Successful addition of voting disk 4d680831fca94f19bf393f63713e05bd.
Successfully replaced voting disk group with +OCRVOTE.
CRS-4266: Voting file(s) successfully replaced
[05:22:30 root(grid)@rac1 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   4d680831fca94f19bf393f63713e05bd (ORCL:OCRVOTE) [OCRVOTE]

重建spfile文件
05:24:12 idle> show parameter spfile;

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
spfile                               string
05:24:21 idle> create pfile='/tmp/init.ora' from memory;

File created.

Elapsed: 00:00:00.06
05:24:56 idle> shutdown immediate;
ASM diskgroups volume disabled
ASM diskgroups dismounted
ASM instance shutdown
05:25:20 idle> startup mount pfile='/tmp/init.ora';
ASM instance started

Total System Global Area    1135747072 bytes
Fixed Size                     2260728 bytes
Variable Size               1108320520 bytes
ASM Cache                     25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
05:26:32 idle> create spfile ='+OCRVOTE' from pfile='/tmp/init.ora';

File created.

Elapsed: 00:00:03.20
05:26:55 idle> startup mount force;
ASM instance started

Total System Global Area    1135747072 bytes
Fixed Size                     2260728 bytes
Variable Size               1108320520 bytes
ASM Cache                     25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
05:27:18 idle> show parameter spfile;

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
spfile                               string                            +OCRVOTE/rac-cluster/asmparameterfile/registry.253.862032413

完成以后重启crs服务
[05:22:40 root(grid)@rac1 ~]# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[05:27:58 root(grid)@rac1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[05:13:09 root(grid)@rac2 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

[05:30:57 root(grid)@rac1 ~]# crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type OFFLINE   OFFLINE               
ora....N1.lsnr ora....er.type OFFLINE   OFFLINE               
ora.OCRVOTE.dg ora....up.type ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.cvu        ora.cvu.type   OFFLINE   OFFLINE               
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora.prod.db    ora....se.type OFFLINE   OFFLINE               
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    OFFLINE   OFFLINE               
ora.rac1.gsd   application    OFFLINE   OFFLINE               
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    OFFLINE   OFFLINE               
ora.rac2.gsd   application    OFFLINE   OFFLINE               
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1        
ora.scan1.vip  ora....ip.type OFFLINE   OFFLINE     

可以看到CRS服务顺利的起来了
我们再在两个节点启动数据库，发现数据库顺利的启动了，一切ok，恢复完成!


 

bigclouder
关注
专栏目录
OCR入门教程系列（一）：OCR基础导论
专注大数据与人工智能技术分享，欢迎私信加群互相学习！
04-01 8万+
📝导读：本系列主要介绍计算机视觉领域OCR文字识别领域技术发展方向，面向深度学习同学，内容总计五章，每章将从OCR技术发展、概念、方法等各种角度展开详细介绍。第一篇介绍OCR概念及发展以及相关数据集，其次列出几种常见的OCR文本检测与文本识别技术，文章最后分享几种开源的OCR平台，后续系列文章将继续介绍OCR相关技术及实战演练。
oracle ocr votedisk 备份恢复
LiHong2012的专栏
02-26 1488
一、检查ocr和votedisk信息 1、查看ocr信息 [root@racnode1 bin]# ocrcheck Status of Oracle Cluster Registry is asfollows :         Version                  :          3         Total space (kbytes)     :     26
11gR2 ocr votedisk的恢复测试
DATA
07-26 2316
先做一些检查： 1.检查ocr的完整性 root@oeltan1 ~]# su - grid [grid@oeltan1 ~]$ cluvfy comp ocr -n all Verifying OCR integrity  Checking OCR integrity... Checking the absence of a non-clustered
备份及恢复votedisk
loryliu的专栏
07-01 542
oracle clusterware 10.2.0.5 on OEL 5.8 配置了三块votesdisk： ./crsctl query css votedisk [root@sdb1 bin]# ./crsctl query css votedisk  0.     0    /dev/raw/raw3  1.     0    /dev/raw/raw4  2.     0
OCR,VOTEDISK各种测试之一OCR,VOTEDISK的迁移
kiwi的专栏
10-26 615
1、迁移votedisk [20:18:19 root(grid)@rac1 ~]# crsctl replace votedisk +OCRVOTE Successful addition of voting disk 72f4fb9959454f8abf1e8ce6d91ec5ee. Successful deletion of voting disk 4192831431e94f8fb
RAC 增加，删除votedisk测试
crermom1734的博客
09-22 214
[root@rac1 ~]# /opt/app/oracle/product/10.2.0/crs_1/bin/crsctl check crsCSS appears healthyCRS appears healthyEVM ...
OCR与VOTEDISK的备份恢复
Super菜的专栏
01-20 1070
votedisk的备份 [grid@rac1 ~]$ crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 1
OCR_磁盘和Votedisk磁盘恢复
12-21
本文将详细介绍如何在OCR磁盘和Votedisk磁盘全部损坏且无备份的情况下进行快速恢复。 #### 二、故障场景及解决方案概述 假设OCR磁盘和Votedisk磁盘全部损坏，且没有备份。在这种情况下，我们可以通过以下步骤进行...
OCR备份和恢复
08-30
OCR备份和恢复
C# OCRServiceTest OCR服务测试程序
最新发布
10-11
**C# OCRServiceTest OCR服务测试程序** C# OCRServiceTest 是一个用于测试OCR（Optical Character Recognition，光学字符识别）服务的应用程序。这个程序旨在验证OCR技术在处理图像中的文字识别能力，以便将图像中...
使用备份恢复ocr和votedisk
oradbm的博客
09-05 299
11Gr2RAC使用备份恢复ocr和votedisk 1）检查环境，准备工作 [root@rac2 bin]# ./crsctl stat res -t ---------------------------------------------------------------------------...
OCRVOTE
喝醉酒的小白
01-14 1996
select a.group_number,b.name,a.failgroup,a.path from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number and a.group_number=1 order by 3; set linesize 300 pages 999 col path for a65 col disk_group_name for a15 col FAILGROUP for a25 col
OCR,VOTEDISK各种测试之四无备份的情况下重建OCR及VOTEDISK
kiwi的专栏
10-27 951
前几天，我们有个DBA在创建一个共享盘的时候
11gR2 OCRVOTE磁盘组替换
cipr45348的博客
03-11 340
11g R2替换OCR盘： 检查OCR盘信息： [root@s2-11g grid]# ocrcheck -config Oracle Cluster Registry configuration is : ...
利用UDEV配置OCR VOTE(基于整个磁盘)
cijinli4767的博客
06-04 117
CRS的共享磁盘存储OCR\VOTEDISK数据，11G之前，OUI不支持对block设备的直接读取(虽然从10.2.0.2开始，ORACLE可用O_DIRECT标志读取block设备，但OUI还是不支持该特性)，一般...
11G ocrvote盘损坏恢复
weixin_34211761的博客
08-28 221
11G OCR、VOTING损坏恢复概述：11Grac经常有会碰到ora.cssd,ora.crsd进程启动失败。一般css.d进程失败多是由于voting盘损坏或者voting盘数量不足导致，而crsd进程失败多是OCR损坏或者集群的配置信息损坏1.OCR一般默认4个小时备份一次，在备份文件位置处，至少存在5份OCR备份信息，最近4小时生成的OCR，最近一天生成的一份备份，...
ocr和vote盘的损坏恢复
cipr45348的博客
10-23 217
假设我们安装CRS时执行root.sh失败，我们应当如何重新执行root.sh，再比如OCR和VOTE全部损坏，并且都没有备份，应当如何恢复，这时候最简单的办法就是重新配置OCR和VOTE，下面是具体模拟过程：[root@rac...
oracle ocr组成员替换,11gR2 OCRVOTE磁盘组替换
weixin_39874196的博客
04-03 173
11g R2替换OCR盘：检查OCR盘信息：[root@s2-11g grid]# ocrcheck -configOracle Cluster Registry configuration is :Device/File Name : +OCRVOT[root@s2-11g grid]# more /etc/oracle/ocr.lococrconfig_loc=+OCRV...
Oracle RAC OCRVOTE 迁移替换
喝醉酒的小白
11-18 2610
asmcd 添加一个+ORCVOTE 替换OCR #ocrcheck #ocrconfig -add +OCRVOTE #more /etc/oracle/ocr.loc #ocrconfig -delete +MGMT (可选) #ocrconfig -replace +MGMT -replacement +OCRVOTE #orccheck 替换votedisk $crsctl query css votedisk $crsctl replace votedisk +OCRVOTE $crsctl qu
Oracle OCR备份与恢复指南
"这篇博客主要讨论了Oracle OCR（Oracle Configuration Registry）的备份与...这篇博客为读者提供了一个全面了解和处理OCR备份恢复，以及RAC相关故障的指南，对于RAC管理员和相关技术人员来说，是一份宝贵的参考资料。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值