12c OCR corrupted results in CRS stack down.

最新推荐文章于 2021-04-18 12:08:00 发布
最新推荐文章于 2021-04-18 12:08:00 发布
阅读量253 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/lyonlee/p/6598428.html
版权

12c OCR corrupted results in CRS stack down.

1. check crsd.trc
2017-03-21 16:14:44.667838 :  CRSOCR:2580299264:  OCR context init failure.  Error: PROC-26: Error while accessing the physical storage Storage layer error [Insufficient quorum to open OCR devices] [0]
2017-03-21 16:14:44.668018 :    CRSD:2580299264:  Created alert : (:CRSD00111:) :  Could not init OCR, error: PROC-26: Error while accessing the physical storage Storage layer error [Insufficient quorum to open OCR devices] [0]
2017-03-21 16:14:44.668032 :    CRSD:2580299264: [PANIC] CRSD exiting: Could not init OCR, code: 26
2017-03-21 16:14:44.668078 :    CRSD:2580299264:  Done.



2. ocrcheck reported same problem.
[root@testdb01 ~]# ocrcheck
PROT-602: Failed to retrieve data from the cluster registry
PROC-26: Error while accessing the physical storage Storage layer error [Insufficient quorum to open OCR devices] [0]



3. check if there's any ocr backups.
[root@testdb01 ~]# cd /u01/app/12.1.0.2/grid/cdata/cluster-test07/
[root@testdb01 cluster-test07]# ll
total 25156
-rw-r--r-- 1 oracle oinstall 1687552 Feb 22 15:49 backup_20170222_154955.ocr
-rw-r--r-- 1 oracle oinstall 1712128 Feb 22 15:49 backup_20170222_154956.ocr
-rw-r--r-- 1 oracle oinstall 1863680 Mar  8 02:06 week.ocr
-rw-r--r-- 1 oracle oinstall 1863680 Mar 15 02:07 week_.ocr
-rw-r--r-- 1 oracle oinstall 1863680 Mar 19 02:07 day.ocr
-rw-r--r-- 1 oracle oinstall 1863680 Mar 20 02:07 day_.ocr
-rw-r--r-- 1 oracle oinstall 1863680 Mar 20 06:07 backup02.ocr
-rw-r--r-- 1 oracle oinstall 1863680 Mar 20 10:07 backup01.ocr
-rw-r--r-- 1 oracle oinstall 1863680 Mar 20 14:07 backup00.ocr
-rw-r--r-- 1 root   root     1859584 Mar 20 18:37 23219979.ocr
-rw-r--r-- 1 root   root     1863680 Mar 20 22:37 41104710.ocr
-rw-r--r-- 1 root   root     1863680 Mar 21 02:37 25823987.ocr
-rw-r--r-- 1 root   root     1863680 Mar 21 06:37 42138219.ocr
-rw-r--r-- 1 root   root     1863680 Mar 21 10:37 17919197.ocr
[root@testdb01 cluster-test07]# ls -lht
total 25M
-rw-r--r-- 1 root   root     1.8M Mar 21 10:37 17919197.ocr
-rw-r--r-- 1 root   root     1.8M Mar 21 06:37 42138219.ocr
-rw-r--r-- 1 root   root     1.8M Mar 21 02:37 25823987.ocr
-rw-r--r-- 1 root   root     1.8M Mar 20 22:37 41104710.ocr
-rw-r--r-- 1 root   root     1.8M Mar 20 18:37 23219979.ocr
-rw-r--r-- 1 oracle oinstall 1.8M Mar 20 14:07 backup00.ocr
-rw-r--r-- 1 oracle oinstall 1.8M Mar 20 10:07 backup01.ocr
-rw-r--r-- 1 oracle oinstall 1.8M Mar 20 06:07 backup02.ocr
-rw-r--r-- 1 oracle oinstall 1.8M Mar 20 02:07 day_.ocr
-rw-r--r-- 1 oracle oinstall 1.8M Mar 19 02:07 day.ocr
-rw-r--r-- 1 oracle oinstall 1.8M Mar 15 02:07 week_.ocr
-rw-r--r-- 1 oracle oinstall 1.8M Mar  8 02:06 week.ocr
-rw-r--r-- 1 oracle oinstall 1.7M Feb 22 15:49 backup_20170222_154956.ocr
-rw-r--r-- 1 oracle oinstall 1.7M Feb 22 15:49 backup_20170222_154955.ocr


4. restore OCR
[root@testdb01 cluster-test07]# ocrconfig -restore backup00.ocr
[root@testdb01 cluster-test07]# crsctl start res ora.crsd -init
CRS-2672: Attempting to start 'ora.crsd' on 'testdb01'
CRS-2676: Start of 'ora.crsd' on 'testdb01' succeeded
[root@testdb01 cluster-test07]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     409568
         Used space (kbytes)      :       1652
         Available space (kbytes) :     407916
         ID                       : 1368296587
         Device/File Name         :   +DBFS_DG
                                    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

[root@testdb01 cluster-test07]# crsctl check cluster -all
**************************************************************
testdb01:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
test07db02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[root@testdb01 cluster-test07]# crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_test07.dg
               ONLINE  ONLINE       testdb01                 STABLE
               ONLINE  ONLINE       test07db02                 STABLE
ora.DBFS_DG.dg
               ONLINE  ONLINE       testdb01                 STABLE
               ONLINE  ONLINE       test07db02                 STABLE
ora.LISTENER.lsnr
               OFFLINE OFFLINE      testdb01                 STABLE
               ONLINE  ONLINE       test07db02                 STABLE
ora.RECO_test07.dg
               ONLINE  ONLINE       testdb01                 STABLE
               ONLINE  ONLINE       test07db02                 STABLE
ora.asm
               ONLINE  ONLINE       testdb01                 Started,STABLE
               ONLINE  ONLINE       test07db02                 Started,STABLE
ora.net1.network
               ONLINE  ONLINE       testdb01                 STABLE
               ONLINE  ONLINE       test07db02                 STABLE
ora.ons
               ONLINE  ONLINE       testdb01                 STABLE
               ONLINE  ONLINE       test07db02                 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       testdb01                 STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       test07db02                 STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       test07db02                 STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       test07db02                 192.168.17.3 192.168
                                                             .17.4,STABLE
ora.cvu
      1        ONLINE  ONLINE       test07db02                 STABLE
ora.testdb01.vip
      1        ONLINE  ONLINE       testdb01                 STABLE
ora.test07db02.vip
      1        ONLINE  ONLINE       test07db02                 STABLE
ora.mgmtdb
      1        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.oc4j
      1        ONLINE  ONLINE       test07db02                 STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       testdb01                 STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       test07db02                 STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       test07db02                 STABLE
--------------------------------------------------------------------------------

转载于:https://www.cnblogs.com/lyonlee/p/6598428.html

weixin_30493321
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Navicat 连接数据库Oracle 12c ocr.dll连接资源包
12-25
标题中的“Navicat 连接数据库Oracle 12c OCR.dll连接资源包”指的是使用Navicat这款数据库管理工具连接Oracle 12c数据库时，可能会遇到的问题以及解决这个问题所需的资源。Navicat是一款流行的数据库管理和开发工具...
当OCR备份位于ASM磁盘组中时，如何恢复基于ASM的OCR? (Doc ID 2569847.1)
u010692693的专栏
11-20 690
How to Restore ASM Based OCR when OCR backup is located in ASM diskgroup? (Doc ID 2569847.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later Information in this documen...
oracle 集群无法启动 报错CRS-0804 PROC-26
关光磊的博客
08-05 2076
oracle 集群无法启动 报错CRS-0804 PROC-26 环境：oracle 12.2.0.1 OS：redhat 7.4 集群alert日志中报错如下，PROC-26: Error while accessing the physical storage Storage这里还以为是存储的问题，还让存储的人看了存储，在这里其实不是存储的问题 2018-04-05 15:16:53.918 [CRSD(2697)]CRS-8500: Oracle Clusterware CRSD process is
12.2.0.1 RAC CRS Cannot Start With Error CRS-5017 CRS-5818 (Doc ID 2521346.1)
u010692693的专栏
11-20 1824
12.2.0.1 RAC CRS Cannot Start With Error CRS-5017 CRS-5818 (Doc ID 2521346.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later Information in this document applies to an...
crs启动失败案例分析
liuzhilong的博客
07-16 4166
一次存储维修后，一套rac的1节点的集群资源起不来 crs日志 2018-07-12 21:20:40.484 [CRSD(23288)]CRS-0804: Cluster Ready Service aborted due to Oracle Cluster Registry error [PROC-26: Error while accessing the physical storag...
CR initialization failed accessing OCR device: PROC-26: Error while accessing the physical storage O
N
07-29 8890
rac1-> crs_stat -t CRS-0184: Cannot communicate with the CRS daemon. rac1-> ps -ef |grep crs root      4334     1  0 00:41 ?        00:00:00 /bin/sh /etc/init.d/init.crsd run oracle    6284  5
Oracle 12C In-Memory Column Store特性
最新发布
03-04
Oracle 12C In-Memory Column Store特性
Oracle 12c In-Memory技术优势详解.pptx
10-11
Oracle 12c In-Memory技术是Oracle数据库12c版本中的一个重要创新，旨在显著提升大数据分析和查询的性能。这一技术的推出是为了应对日益增长的数据量和对实时分析的需求，同时也是Oracle对市场中如SAP HANA等内存...
weblogic12c补丁opatch13.9.4.28下载
01-23
weblogic12c补丁opatch13.9.4.28下载
STC12C5A.rar_STC12C5A_stc12c5a .h
07-14
STC12C5A系列单片机是STC公司推出的一款8位微控制器，以其高性价比、低功耗和丰富的内置功能而受到广大电子工程师的欢迎。STC12C5A系列单片机主要基于增强型8051内核，提供了更多的I/O口和增强的定时器功能，特别...
CRS-0804:PROC-26: Error while accessing the physical storage
sqlora的专栏
07-07 2286
With the Real Application Clusters and Automatic Storage Management options [grid@rac1 rac1]$ tail -f alertrac1.log 2020-07-07 16:27:02.696: [mdnsd(3096)]CRS-5602:mDNS service stopping by request. 2020-07-07 16:27:17.049: [cssd(3176)]CRS-1603:CSSD on no...
oracle crs 4535,11gRAC报错CRS-4535,CRS-4000解决
weixin_39533280的博客
04-11 5366
1.故障现象使用crsctl查看集群各资源状态，在任一节点都会直接报错CRS-4535,CRS-4000；但此时数据库是可以被正常访问的。具体故障现象如下：＃节点1查询grid@bjdb1:/home/grid>crsctl stat res -tCRS-4535: Cannot communicate with Cluster Ready ServicesCRS-4000: Command...
PROC-26 Error while accessing the physical storage
cke63021的博客
03-27 1668
问题描述： 由于网站整体上云，IDC机房的服务器需要下架，其中一套oracle rac 从IDC搬回来之后，尝试启动报错，报错信息如下： 1）尝试启动oracle 实例： SQL&g...
Oracle OCR/VF磁盘组故障恢复
dbhang的博客
07-22 455
OCR/VF磁盘组故障的恢复： 备份准备：（采用手工导出方式） [root@rac1 ~]# /oracle/grid/crs_1/bin/ocrconfig -export ocr_export [root@rac1 ~]# ll ocr_export -rw------- 1 root root 123903 Jul 22 17:43 ocr_export 集群正常运行 [grid@rac1 ~]$ ocrcheck Status of Oracle Cluster Registry.
【Oracle】RAC11gR2Grid启动顺序及启动故障诊断思路
lzw5210的博客
03-03 2231
从11gR2开始，Oracle RAC的架构有了比较大的变化，集群层面相交于之前的版本有了比较大的变动，原来的rac架构基本上属于cssd、crsd、evmd三大光秃秃的主干进程，日志数量较少，对于rac无法启动原因，采用最原始的方法逐一查看各个进程的日志也可找到无法启动的原因。然而从11gR2之后，集群层发生了比较大的变动，以下是$GRID_HOME/log/rac1/下的目录情况：   [
oracle crs 0184,Oracle RAC CRS-0184 --Cannot communicate with the CRS daemon
weixin_30767393的博客
04-14 159
Oracle 11gR2下RAC安装后，启动CRS.错误如下：https://www.cndba.cn/Dave/article/572[root@rac1 bin]# ./crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4535: Cannot communicate with Cluster Re...
OCR和voting disk损坏恢复
wangxi06的专栏
04-18 1044
OCR和voting disk损坏恢复 原创魔鬼之武 介绍 有时候服务器或存储的突发情况，导致数据库服务器重启同时出现OCR磁盘丢失报错，导致oracle数据库集群宕机。这时，就需要我们来恢复OCR磁盘和voting disk，从而恢复集群！整个过程中，数据库是无法使用的！ 本文数据库版本11.2.0.4 RAC，使用dd命令来模拟ocr磁盘损坏，然后通过ocr的自动备份来恢复ocr信息，然后重建voting disk！ 检查当前可用资源 [grid@rac1 ~]$ asmcmd ASMCM
Grid (GI) startup fails because crsd fails to start in a flex asm environment (Doc ID 2392762.1)
u010692693的专栏
11-20 891
Grid Infrastructure (GI) startup fails because crsd fails to start in a flex asm environment (Doc ID 2392762.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later Oracle D...
RAC上ocr和voting disk维护操作和需求1
Super菜的专栏
11-16 2679
部分转自http://www.lunar2013.com/ Oracle从10.1开始推出了自己真正意义的集群软件（9i和9i之前的版本，Oracle只有集群数据库，集群的存储和网络是由第三方厂商维护的，比如IBM的HACMP，HPUX的MC SERVICE GUARD /OA，SUN的suncluster，True64的Trucluster，linux就用ocfs和check-timer等等）

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值