RAC数据库grid的CRS磁盘dismount造成的CRS进程无法启动问题
问题:crs asm盘没有挂载问题
rx9900b@grid[/home/grid]crsctl status res -t CRS-4535: Cannot communicate with Cluster Ready Services CRS-4000: Command Status failed, or completed with errors.
问题分析:
问题查看过程 rx9900b@grid[/] ocrcheck rx9900b@grid[/] crsctl query css votedisk 1、查看crs进程日志 rx9900b@grid[/u01/app/grid/11.2.0/log/rx9900b/crsd]tail -n 20 /u01/app/grid/11.2.0/log/rx9900b/crsd/crsd.log 2021-11-17 13:07:12.711: [ OCRASM][1]ASM Error Stack : 2021-11-17 13:07:12.791: [ OCRASM][1]proprasmo: kgfoCheckMount returned [6] 2021-11-17 13:07:12.791: [ OCRASM][1]proprasmo: The ASM disk group OCR is not found or not mounted ----->ocr磁盘每找到 2021-11-17 13:07:12.792: [ OCRRAW][1]proprioo: Failed to open [+OCR]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE. 2021-11-17 13:07:12.792: [ OCRRAW][1]proprioo: No OCR/OLR devices are usable SQL> show parameter dump NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_core_dump string partial background_dump_dest string /u01/app/gridbase/diag/asm/+asm/+ASM2/trace 2、查看asm实例日志 tail -n 10000 /u01/app/gridbase/diag/asm/+asm/+ASM2/trace/alert_+ASM2.log|more SUCCESS: diskgroup OCR was dismounted SUCCESS: alter diskgroup OCR dismount force /* ASM SERVER:342992784 */ ----->ocr备强制dismount SUCCESS: ASM-initiated MANDATORY DISMOUNT of group OCR Wed Nov 17 12:06:47 2021 NOTE: diskgroup resource ora.OCR.dg is offline Wed Nov 17 12:06:47 2021 Errors in file /u01/app/gridbase/diag/asm/+asm/+ASM2/trace/+ASM2_ora_20678.trc:
问题处理:
rx9900b@grid[/home/grid]asmcmd ASMCMD [+] > lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 1024 4096 1048576 2297856 2127098 0 2127098 0 N ARCHDG/ MOUNTED EXTERN N 1024 4096 1048576 13065216 253437 0 253437 0 N RKYWDG/ MOUNTED EXTERN N 1024 4096 1048576 20454400 4558159 0 4558159 0 N RXZWDG/ sqlplus / as sysdba SQL> set linesize 300 SQL> set pagesize 100 SQL> col path format a40 SQL> col name format a20 SQL> col state format a10 SQL> select path,name,state,total_mb,free_mb from v$asm_disk; SQL> select name,state from v$asm_diskgroup; NAME STATE -------------------- ---------- ARCHDG MOUNTED OCR DISMOUNTED RKYWDG MOUNTED RXZWDG MOUNTED SQL> alter diskgroup OCR mount; #挂载asm磁盘 Diskgroup altered. SQL> select name,state from v$asm_diskgroup; NAME STATE -------------------- ---------- ARCHDG MOUNTED OCR MOUNTED RKYWDG MOUNTED RXZWDG MOUNTED 启动crs rx9900b@root[/]/u01/app/grid/11.2.0/bin/crsctl start res ora.crsd -init CRS-2672: Attempting to start 'ora.crsd' on 'rx9900b' CRS-2676: Start of 'ora.crsd' on 'rx9900b' succeeded rx9900b@root[/]/u01/app/grid/11.2.0/bin/crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4535: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online
做一个决定,并不难,难的是付诸行动,并且坚持到底。