• 11g RAC OCR,VOTING DISK存储全部损坏,利用自动备份,恢复OCR,VOTING DISK到新存储。


    背景:

    11g R2 rac 的orc ,voting disk asm存储磁盘全部损坏。通过调查得知 损坏的 OCR磁盘对应为 VOL1 ,
    voting disk磁盘对应于 VOL2 。 故,添加asm新存储(过程省略),设置为旧配置名 VOL1,VOL2 。

    /usr/sbin/oracleasm createdisk VOL1 /dev/sdb1
    /usr/sbin/oracleasm createdisk VOL2 /dev/sdc1

    [root@node1 bin]# /usr/sbin/oracleasm listdisks -- 查看 listdisks 。
    VOL1
    VOL2
    VOL3 -- 说明此为没有损坏的asm
    VOL4 -- 说明此为没有损坏的asm

    存储配置完成后,正式恢复OCR,VOTING DISK 操作流程:

    1. 以-excl -nocrs 方式启动cluster,这将可以启动ASM实例 但不启动CRS

    # crsctl start crs -excl -nocrs

    2.以 sqlplus / as sysasm 登录asm,重建原ocr和votedisk所在diskgroup,注意compatible.asm必须是11.2 。
    ## 注意 DISKGROUP 名为旧ORC,VOTING DISK磁盘组名。

    SQL> CREATE DISKGROUP griddg external REDUNDANCY
    DISK 'ORCL:vol1','ORCL:vol2' ATTRIBUTE 'compatible.asm'='11.2.0.0.0';
    Diskgroup created.

    3.从ocr 自动 backup 中恢复ocr并做ocrcheck检验:
    [root@node1 bin]# ./ocrconfig -restore /u01/app/11.2.0/grid/cdata/scan-cluster/backup02.ocr

    [root@node1 bin]# ./ocrcheck
    Status of Oracle Cluster Registry is as follows :
    Version : 3
    Total space (kbytes) : 262120
    Used space (kbytes) : 3068
    Available space (kbytes) : 259052
    ID : 1970085021
    Device/File Name : +GRIDDG
    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

    4.准备恢复votedisk
    [root@node1 bin]# ./crsctl replace votedisk +GRIDDG
    Successful addition of voting disk aede3b23ab684fc8bfc52d1bf5a45ea6.
    Successful deletion of voting disk 138dbfa62e2d4feabf73d9ec4cb70c68.
    Successfully replaced voting disk group with +GRIDDG.
    CRS-4266: Voting file(s) successfully replaced

    恢复完成。

    如果第四步中可能会遇到下面的错误:
    [grid@vrh1 ~]$ crsctl replace votedisk +SYSTEMDG
    CRS-4602: Failed 27 to add voting file 2e4e0fe285924f86bf5473d00dcc0388.
    CRS-4602: Failed 27 to add voting file 4fa54bb0cc5c4fafbf1a9be5479bf389.
    CRS-4602: Failed 27 to add voting file a109ead9ea4e4f28bfe233188623616a.
    CRS-4602: Failed 27 to add voting file 042c9fbd71b54f5abfcd3ab3408f3cf3.
    CRS-4602: Failed 27 to add voting file 7b5a8cd24f954fafbf835ad78615763f.
    Failed to replace voting disk group with +SYSTEMDG.
    CRS-4000: Command Replace failed, or completed with errors.
    需要重新配置一下ASM的参数,并重启ASM:

    SQL> alter system set asm_diskstring=‘/dev/asm*’;
    System altered.

    SQL> create spfile from memory;
    File created.

    SQL> startup force mount;
    ORA-32004: obsolete or deprecated parameter(s) specified for ASM instance
    ASM instance started
    Total System Global Area 283930624 bytes
    Fixed Size 2227664 bytes
    Variable Size 256537136 bytes
    ASM Cache 25165824 bytes
    ASM diskgroups mounted

    SQL> show parameter spfile
    NAME TYPE VALUE
    —————————————————— ————— ———————————————
    spfile string /g01/11.2.0/grid/dbs/spfi le+ASM1.ora

    [grid@vrh1 trace]$ crsctl replace votedisk +SYSTEMDG
    CRS-4256: Updating the profile
    Successful addition of voting disk 85edc0e82d274f78bfc58cdc73b8c68a.
    Successful addition of voting disk 201ffffc8ba44faabfe2efec2aa75840.
    Successful addition of voting disk 6f2a25c589964faabf6980f7c5f621ce.
    Successful addition of voting disk 93eb315648454f25bf3717df1a2c73d5.
    Successful addition of voting disk 3737240678964f88bfbfbd31d8b3829f.
    Successfully replaced voting disk group with +SYSTEMDG.
    CRS-4256: Updating the profile
    CRS-4266: Voting file(s) successfully replaced

  • 相关阅读:
    分离 附加 还原
    sql sever 数据表
    正则矩阵
    路由vue-router基础
    vue理解$nextTick
    vue组件
    vue事件处理
    vue列表渲染
    vue条件渲染
    vue class与style绑定
  • 原文地址:https://www.cnblogs.com/andy6/p/6422060.html
Copyright © 2020-2023  润新知