19c grid oracle base 误删除恢复操作

测试数据库升级时报空间不足,把 grid用户的oracle base /u01/app/11.2.0 删除导致集群启动不起来,
处理步骤
1、节点1运行root.sh 重新配置集群
2、节点2本地表决文件和节点1的不同,把节点1的拷贝过去 ,注意用户组和改名

[+ASM2]@ht02[/u01/app/11.2.0/grid/diag/crs/ht02/crs/trace]$ocrconfig -local -showbackuploc
The Oracle Local Registry backup location is [/u01/app/11.2.0/grid/crsdata/ht02/olr/].


3、ora.storage 服务启动不起来 报错ORA-15077 ,手动启动asm实例 挂载磁盘组、

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
  OCRASM:236908864: SLOS : SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge
 
2022-04-21 18:08:46.434 :  OCRASM:236908864: ASM Error Stack : ORA-15077: 找不到提供所需磁盘组的 ASM 实例
 
2022-04-21 18:08:46.434 :  OCRASM:236908864: proprasmo: kgfoCheckMount returned [7]
2022-04-21 18:08:46.434 :  OCRASM:236908864: proprasmo: The ASM instance is down
2022-04-21 18:08:46.434 :  OCRRAW:236908864: proprioo: Failed to open [+ocr]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
2022-04-21 18:08:46.434 :  OCRRAW:236908864: proprioo: No OCR/OLR devices are usable
  OCRUTL:236908864: u_fill_errorbuf: Error Info : [仲裁磁盘不足, 无法打开 OCR 设备]
 default:236908864: u_set_gbl_comp_error: comptype '107' : error '0'
2022-04-21 18:08:46.434 : default:236908864: clsvactversion:4: Retrieving Active Version from local storage.
2022-04-21 18:08:46.436 :  OCRRAW:236908864: proprrepauto: The local OCR configuration matches with the configuration published by OCR Cache Writer. No repair required.
2022-04-21 18:08:46.436 :  OCRRAW:236908864: proprinit: Could not open raw device
2022-04-21 18:08:46.440 :  OCRAPI:236908864: a_init:16!: Backend init unsuccessful : [26]
2022-04-21 18:08:46.440 :  OCRAPI:236908864: estack 'PROC-00026: 访问物理存储时出错'
2022-04-21 18:08:46.440 :  CRSOCR:236908864: [    ERROR]  OCR context init failure.  Error: PROC-26: 访问物理存储时出错 存储层错误 [仲裁磁盘不足, 无法打开 OCR 设备] [0]
2022-04-21 18:08:46.441 :    CRSD:236908864: [     NONE]  Created alert : (:CRSD00111:) :  Could not init OCR, error: PROC-26: 访问物理存储时出错 存储层错误 [仲裁磁盘不足, 无法打开 OCR 设备] [0]
2022-04-21 18:08:46.441 :    CRSD:236908864: [    ERROR] [PANIC] CRSD exiting: Could not init OCR, code: 26
2022-04-21 18:08:46.441 :    CRSD:236908864: [     INFO]  Done.
 
 
 
[+ASM2]@ht02[/dev/asm]$crsctl stat res -t -init
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       ht02                     STABLE
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       ht02                     STABLE
ora.crf
      1        ONLINE  ONLINE       ht02                     STABLE
ora.crsd
      1        ONLINE  OFFLINE                               STABLE
ora.cssd
      1        ONLINE  ONLINE       ht02                     STABLE
ora.cssdmonitor
      1        ONLINE  ONLINE       ht02                     STABLE
ora.ctssd
      1        ONLINE  ONLINE       ht02                     OBSERVER,STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       ht02                     STABLE
ora.gipcd
      1        ONLINE  ONLINE       ht02                     STABLE
ora.gpnpd
      1        ONLINE  ONLINE       ht02                     STABLE
ora.mdnsd
      1        ONLINE  ONLINE       ht02                     STABLE
ora.storage
      1        ONLINE  OFFLINE      ht02                     STARTING
--------------------------------------------------------------------------------
[+ASM2]@ht02[/dev/asm]$crsctl start res ora.crsd -init
CRS-5702: Resource 'ora.crsd' is already running on 'ht02'
CRS-4000: Command Start failed, or completed with errors.

  

手动重启asm解决ora.storage服务一直启动不起来的问题

 

posted @   刚好遇见Mysql  阅读(262)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 无需6万激活码!GitHub神秘组织3小时极速复刻Manus,手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· Manus爆火,是硬核还是营销?
· 终于写完轮子一部分:tcp代理 了,记录一下
· 【杭电多校比赛记录】2025“钉耙编程”中国大学生算法设计春季联赛(1)
点击右上角即可分享
微信分享提示