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服务一直启动不起来的问题
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 无需6万激活码!GitHub神秘组织3小时极速复刻Manus,手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· Manus爆火,是硬核还是营销?
· 终于写完轮子一部分:tcp代理 了,记录一下
· 【杭电多校比赛记录】2025“钉耙编程”中国大学生算法设计春季联赛(1)