• 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
    

      

      

      

    做一个决定,并不难,难的是付诸行动,并且坚持到底。
  • 相关阅读:
    LeetCode 260
    LeetCode 258
    LeetCode 237
    LeetCode 226
    LeetCode 203
    LeetCode 202
    codeforces 7D
    codefroces 7C
    codeforces 7B
    codeforces 6E (非原创)
  • 原文地址:https://www.cnblogs.com/wukc/p/15593095.html
Copyright © 2020-2023  润新知