RAC环境替换多路径软件后cssd服务无法启动的恢复

已于 2022-03-30 09:21:20 修改
阅读量2.3k 收藏 5
点赞数 1
文章标签： oracle
于 2022-03-28 14:57:55 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ffoooxx/article/details/123794207
版权

系统环境：Centos6.8
数据库版本：11.2.0.4.0

由华为多路径替换为Centos自带的device-mapper-multipath后，RAC集群启动一直卡在CSSD服务，状态一直是starting。

 

由于11gR2中CRS服务依赖于ASM，因为ocr存放在ASM中，所以ASM若无法有效启动，这导致CRS服务也无法正常工作:

集群日志：

2022-03-26 12:08:02.469: 
[ohasd(28938)]CRS-2112:The OLR service started on node RAC01.
2022-03-26 12:08:02.486: 
[ohasd(28938)]CRS-1301:Oracle High Availability Service started on node RAC01.
2022-03-26 12:08:02.493: 
[ohasd(28938)]CRS-8017:location: /etc/oracle/lastgasp has 2 reboot advisory log files, 0 were announced and 0 errors occurred
2022-03-26 12:08:06.212: 
[/u01/app/11.2.0/grid/bin/orarootagent.bin(29065)]CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running). 
2022-03-26 12:08:10.405: 
[ohasd(28938)]CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running). 
2022-03-26 12:08:10.412: 
[gpnpd(29482)]CRS-2328:GPNPD started on node RAC01. 
2022-03-26 12:08:12.745: 
[cssd(29564)]CRS-1713:CSSD daemon is started in clustered mode
2022-03-26 12:08:14.621: 
[ohasd(28938)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
2022-03-26 12:08:14.621: 
[ohasd(28938)]CRS-2769:Unable to failover resource 'ora.diskmon'.
2022-03-26 12:08:17.884: 
[cssd(29564)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/RAC01/cssd/ocssd.log
2022-03-26 12:08:32.900: 
[cssd(29564)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/RAC01/cssd/ocssd.log
2022-03-26 12:08:47.916: 
[cssd(29564)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/RAC01/cssd/ocssd.log
2022-03-26 12:09:02.932: 
[cssd(29564)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/RAC01/cssd/ocssd.log
2022-03-26 12:09:17.949: 
[cssd(29564)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/RAC01/cssd/ocssd.log
2022-03-26 12:09:32.965: 
[cssd(29564)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/RAC01/cssd/ocssd.log
2022-03-26 12:09:47.981: 
[cssd(29564)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/RAC01/cssd/ocssd.log
2022-03-26 12:10:02.998: 
[cssd(29564)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/RAC01/cssd/ocssd.log

 ocssd.log


2022-03-26 12:09:47.981: [    CLSF][3717953280]checksum failed for disk:/dev/asm-datadisk01-new:
2022-03-26 12:09:47.981: [    CLSF][3717953280]Error: obj 2147483658 blk 0 name 'check_kfbh' num1 1289612970 num2 2751807285
2022-03-26 12:09:47.981: [    CLSF][3717953280]bh: ptr 0x7f5dc8138e00 size 512
2022-03-26 12:09:47.981: [   SKGFD][3717953280]bh:  dump of 0x0x7f5dc8138e00, len 512
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e00 01 82 01 01 00 00 00 00 - 0a 00 00 80 aa ee dd 4c ...............L
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e10 a0 6f 80 15 00 00 00 00 - 00 00 00 00 00 00 00 00 .o..............
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e20 4f 52 43 4c 44 49 53 4b - 00 00 00 00 00 00 00 00 ORCLDISK........
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e30 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e40 00 00 20 0b 0a 00 01 03 - 44 41 54 41 5f 30 30 31 .. .....DATA_001
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e50 30 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 0...............
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e60 00 00 00 00 00 00 00 00 - 44 41 54 41 00 00 00 00 ........DATA....
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e70 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e80 00 00 00 00 00 00 00 00 - 44 41 54 41 5f 30 30 31 ........DATA_001
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138e90 30 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 0...............
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138ea0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138eb0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138ec0 00 00 00 00 00 00 00 00 - d1 8e f9 01 00 1c 9b 10 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138ed0 d1 8e f9 01 00 28 9b 10 - 00 02 00 10 00 00 10 00 .....(..........
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138ee0 80 bc 01 00 00 00 20 00 - 14 00 00 00 01 00 00 00 ...... .........
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138ef0 02 00 00 00 12 1c 0d 00 - 0a 00 ff ff ff ff ff ff ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f00 00 00 10 0a ab 51 f8 01 - 00 b0 35 65 00 00 00 00 .....Q....5e....
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f10 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f20 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f30 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f40 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f50 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f60 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f70 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f80 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138f90 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138fa0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138fb0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138fc0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138fd0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138fe0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]0x0x7f5dc8138ff0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc81388e0 for disk :/dev/asm-datadisk01-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc8139110 for disk :/dev/asm-datadisk02-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc813abb0 for disk :/dev/asm-datadisk09-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc813b660 for disk :/dev/asm-datadisk03-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc813c280 for disk :/dev/asm-datadisk10-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc81413c0 for disk :/dev/asm-datadisk05-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc8141fe0 for disk :/dev/asm-datadisk04-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc8142c00 for disk :/dev/asm-datadisk06-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc8143820 for disk :/dev/asm-datadisk08-new:

2022-03-26 12:09:47.981: [   SKGFD][3717953280]Lib :UFS:: closing handle 0x7f5dc8144440 for disk :/dev/asm-datadisk07-new:

2022-03-26 12:09:47.981: [    CSSD][3717953280]clssnmvDiskVerify: Successful discovery of 0 disks
2022-03-26 12:09:47.981: [    CSSD][3717953280]clssnmCompleteInitVFDiscovery: Completing initial voting file discovery
2022-03-26 12:09:47.981: [    CSSD][3717953280]clssnmvFindInitialConfigs: No voting files found
2022-03-26 12:09:47.982: [    CSSD][3717953280](:CSSNM00070:)clssnmCompleteInitVFDiscovery: Voting file not found. Retrying discovery in 15 seconds
2022-03-26 12:09:47.986: [    CSSD][3720496896]clssgmExecuteClientRequest(): type(37) size(80) only connect and exit messages are allowed before lease acquisition proc(0x7f5dd406ed80) client((nil))
2022-03-26 12:09:47.986: [    CSSD][3720496896]clssgmDeadProc: proc 0x7f5dd406ed80
2022-03-26 12:09:47.986: [    CSSD][3720496896]clssgmDestroyProc: cleaning up proc(0x7f5dd406ed80) con(0x896) skgpid  ospid 29509 with 0 clients, refcount 0
2022-03-26 12:09:47.986: [    CSSD][3720496896]clssgmDiscEndpcl: gipcDestroy 0x896
2022-03-26 12:09:52.573: [    CSSD][3720496896]clssscSelect: cookie accept request 0x26156b0

checksum failed for disk:/dev/asm-datadisk01-new:
Error: obj 2147483658 blk 0 name 'check_kfbh' num1 1289612970 num2 2751807285
bh: ptr 0x7f5dc8138e00 size 512
bh:  dump of 0x0x7f5dc8138e00, len 512

clssnmvDiskVerify: Successful discovery of 0 disks

找不到votedisk


解决方法：

1、首先彻底关闭OHASD服务：

crsctl stop has -f

2、以-excl -nocrs方式启动CRS，这将仅启动ASM 实例而不会启动CRS服务：

crsctl start crs -excl -nocrs

3、修改ASM实例的disk_strings为当前的ASM DISK PATH信息，并重建spfile文件:

[root@RAC01 ~]# su - grid

[grid@RAC01 ~]$ sqlplus  / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 15 04:40:40 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> ALTER SYSTEM SET asm_diskgroups = CRS, DATA;

System altered.

SQL> alter system set asm_diskstring='/dev/asm*';

System altered.

SQL> alter diskgroup CRS mount;

Diskgroup altered.

SQL> alter diskgroup DATA mount;

Diskgroup 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/grid/app/11.2.0/grid/dbs/
                                                 spfile+ASM1.ora

SQL> show parameter disk

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                       string      CRS, DATA
asm_diskstring                       string      /dev/asm*

SQL> create pfile from spfile;

File created.

SQL> create spfile='+CRS' from pfile;

File created.

SQL> startup force;
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      +CRS/RAC-cluster/asmparameterfile/registry.253.788682933

以上成功修改了asm_diskstring ，且更新了ASM DISKGROUP上的SPFILE ， 由于ASM使用共享的SPFILE所以其他节点上一般无需在做其他操作。

4、crsctl replace votedisk 命令将votedisk重置位置：

[root@RAC01 ~]# crsctl replace votedisk +CRS
Successful addition of voting disk b0d8ba07a9684fcfbfe7660e829128d5.
Successfully replaced voting disk group with +CRS.
CRS-4266: Voting file(s) successfully replaced
[root@RAC01 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   b0d8ba07a9684fcfbfe7660e829128d5 (/dev/asm-crsdisk-new) [CRS]
Located 1 voting disk(s).
[root@RAC01 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2940
         Available space (kbytes) :     259180
         ID                       : 2028826513
         Device/File Name         :       +CRS
                                    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

以上replace了votedisk到新的 ASM DISK上，并确认votedisk和OCR均为可用状态。

5、重启CRS服务：

[root@RAC01 ~]# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'RAC01'
CRS-2673: Attempting to stop 'ora.ctssd' on 'RAC01'
CRS-2673: Attempting to stop 'ora.asm' on 'RAC01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'RAC01'
CRS-2677: Stop of 'ora.mdnsd' on 'RAC01' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'RAC01' succeeded
CRS-2677: Stop of 'ora.asm' on 'RAC01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'RAC01'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'RAC01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'RAC01'
CRS-2677: Stop of 'ora.cssd' on 'RAC01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'RAC01'
CRS-2677: Stop of 'ora.gipcd' on 'RAC01' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'RAC01'
CRS-2677: Stop of 'ora.gpnpd' on 'RAC01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'RAC01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@RAC01 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

[root@RAC01 ~]# crsctl status res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       RAC01              Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       RAC01                                  
ora.crf
      1        OFFLINE OFFLINE                                                   
ora.crsd
      1        ONLINE  ONLINE       RAC01                                  
ora.cssd
      1        ONLINE  ONLINE       RAC01                                  
ora.cssdmonitor
      1        ONLINE  ONLINE       RAC01                                  
ora.ctssd
      1        ONLINE  ONLINE       RAC01              OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       RAC01                                  
ora.gipcd
      1        ONLINE  ONLINE       RAC01                                  
ora.gpnpd
      1        ONLINE  ONLINE       RAC01                                  
ora.mdnsd
      1        ONLINE  ONLINE       RAC01

因为上面更新了ASM共享使用的SPFILE，所以其他节点上一般不会存在问题，直接重启后CRS即可正常工作。

以上修复过程参考：在11gR2 RAC中修改ASM DISK Path磁盘路径

楚枫默寒
关注
  • 1
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
修改计算机名或IP后Oracle10g服务无法启动的解决方法
12-15
遇到的问题，问题产生原因不详。症状为，windows服务中有一项oracle服务启动不了，报出如下错误。 Windows 不能在 本地计算机 启动 OracleDBConsoleorcl 。有关更多信息，查阅系统事件日志。如果这是非 Microsoft 服务，请与服务厂商联系，并参考特定服务错误代码 2 后从网上寻得一贴，问题解决，解决原因不详，反正就是解决了。 问题描述：学校机房母盘安装Oracle10g传输到其它机器，母盘的Oracle可以正常使用，而其它机器启动Oracle服务时无法启动。 具体为：在“服务”中启动“OracleDBConsoleorcl”时出现“Windows不能在本地
DELL Md3600F linux配置多路径_rac
01-09
md3600f多路径配置，Dell 800实验教程，经过实践考证
12CR2 RAC_多路径_ASM Failgroup_NFS实现存储双活详细搭建步骤.docx
05-17
此套存储双活环境上线之前经过严格的测试，排除了所有的单点故障，不管是手动模拟故障，还是暴力的直接拔电源，集群都能自行恢复正常运行，目前这套环境已经正式上线半年，运行稳定，性能优异。若基础设施性能没有问题，也可适用于extended rac的搭建，但两个机房之间距离最远不要超过100公里。
OracleOraDb10g_home1TNSListener服务无法启动怎么解决
12-15
造成OracleOraDb10g_home1TNSListener服务无法启动可能有三种情况： 1.listener.ora文件配置有错误导致无法启动 2.相关环境变量没设置好 3.删除客户端时导致服务端相关注册表信息误删导致无法启动 无法启动弹出的信息框显示信息：“本地计算机上的OracleOraDb10g_home1TNSListener服务启动后停止。某些服务在未由其他服务或程序使用时将自动停止。” 因listener.ora文件配置有错误导致无法启动的解决思路：检查是否修改过计算机名，如果是HOST修改成电脑正确的计算机名；配置文件的HOST是否设置为动态IP,如果是修改成电脑的计
oracle 共享存储 出现问题,记一次RAC节点连接共享存储失败重启问题
weixin_28850145的博客
04-10 2013
节点二成功关机后，客户可在节点一继续操作，但就在节点二关机不到5分钟，节点一居然自动关闭RAC服务并且重启机器了(此时时间约为2016年1月20日10:15)；询问过搬机柜的人员，他们说没有碰到节点一的线，也不清楚为什么发生这样的情况，待节点一重启后，我们开始寻找原因；一开始个人认为是votedisk将节点一踢出，进行IO隔离从而重启节点一服务器，但是经过查看log，跟votedisk非直接原因，...
CRS-1714 Unable to discover any voting files
Jove2761781的博客
05-01 1625
今天安装oracle rac 11.2.0.4，操作系统是oracle linux 7u9，磁盘采用的是iSCSI共享挂载。 重启的时候出现一个奇怪的现象，crs群集无法正常启动。 [grid@rac1 ~]$ crsctl stat res -t CRS-4535: Cannot communicate with Cluster Ready Services CRS-4000: Command Status failed, or completed with errors. 查看/u01/app/11.
分析11.2.0.3 rac CRS-1714:Unable to discover any voting files
09-19 1669
结论： 1，11.2.0.3或者说ORACLE不同版本的RAC进程依赖机制一直在发展演化，一定要尽力搞清RAC各进程间依赖关系，到关重要 2，CRS-1714:Unable to discover ...
Oracle RAC目录权限丢失故障恢复
sqlora的专栏
09-15 876
oracle rac目录权限丢失恢复
oracle+日志时间乱序,Oracle归档日志所在目录时间不对&&Oracle集群日志时间显示错误...
weixin_31481495的博客
04-06 502
前言这个问题在18年的时候遇到了，基本不注意并且集群或者数据库运行正常是很难注意到的。忘记当时怎么发现的了，最近拿出来重现一下问题。具体描述一下问题：比如当前时间是2020年07月03日0点，数据库对redo log发起归档。在OMF下，归档会按照日期进行分类归档。但是发起归档之后，新的归档文件会放在的20200702的目录中。另外，db和asm和集群的警告日志的时间也和操作系统的date时间不一...
Oracle11G_12C+CentOs7 RAC安装配置步骤整理_包括多路径配置
03-15
Oracle11G_12C+CentOs7 RAC安装配置步骤整理_包括多路径配置
Oracle 11g RAC CSSD进程无法启动real time模式
最新发布
jin415147的博客
08-15 219
主机因故障重启，重启后节点无法正常启动，其它节点可以正常对外提供服务。
基础小结
weixin_47734254的博客
08-06 394
一. java基础 .1. JDK和JJRE有什么区别? 1.jdk是Java开发的工具包, 主要面向开发人员; 2. jdk包含了jre. 同时页包含了编译java源代码的javac, 还包含了Java调试和分析的工具; 3. jdk是Java开发的核心, 包含了jre运行环境, java工具和java基础类等; 4. jre是java运行环境, 面向Java程序的使用者,而不是开发者; 5. JRE是可以在其上运行、测试和传输应用程序的Java平台。它包括Java虚拟机（jvm）、Java核
CRS-1714:Unable to discover any voting files
weixin_34349320的博客
11-05 1302
RHEL6.4+ORACLE 11.2.0.4rac，今天重启一个节点，发现crs起不来，ASM起不来，google了好多资料都不对症，先说下主要症状[root@rac2 ~]# /oracle/app/grid/product/11.2.0/bin/crsctl start crsCRS-4640: Oracle High Availability Services is ...
案例——集群启动到css报错的问题处理记录
liuzhilong的博客
10-17 1303
今天早上一套rac的的一个节点的服务器宕机 服务器起来后登陆上去查看集群和数据库的启动情况   查看crs是否正在启动，有进程表示在启动中或已起好 # ps -ef|grep d.bin root       7528      1  2 09:35 ?        00:00:01 /grid/app/11.2.0/grid/bin/ohasd.bin reboot grid     ...
titanagent服务导致oracle数据库集群cssd进程无法启动
dba笔记
05-05 2361
titanagent服务导致oracle数据库集群cssd进程无法启动
12c rac环境磁盘问题导致集群异常的解决实例
liuzhilong的博客
05-28 976
rac环境中4节点集群异常，voting file无法正常读取因为这个库之前出过一次磁盘权限导致磁盘无法读取的问题，所以我首先直接对比了4个几点的磁盘权限和用户所属组发现4节点的oracle用户所属组比其他3个节点的所属组要少一个asmadmin[oracle@dbnode04 ~]$ id oracleuid=1101(oracle) gid=1020(oinstall) groups=1020...
oracle10g cssd日志,Oracle故障处理之CRS-2674: Start of 'ora.cssd' on 'rac2' failed
weixin_42349126的博客
04-03 1102
问题背景：客户反馈Oracle rac集群节点宕机1、首先查看宕机原因归档日志满导致服务重启，查看归档日志路径是USE_DB_RECOVERY_FILE_DEST (默认路径)，安装的时候没有做调整，应该调整单独的归档目录，首先清理归档日志然后修改归档路径2、节点一正常启动，节点二起不来 没有cluster服务检查集群服务在rac2节点上检查集群服务的状态报错[grid@rac2 ~]# u...
安装oracle11g ocr分配,案例:Oracle 11G/12C RAC的ocr磁盘组异常备份恢复详细步骤
weixin_35978903的博客
04-02 460
天萃荷净记录关于Oracle 11G/12C RAC的ocr磁盘组异常，通过备份进行恢复详细步骤在11.2或者12.1的RAC中,ocr和votedisk可以放到asm中,而很多人安装系统把ocr和votedisk放到一个单独的asm 磁盘组里面,但是如果这个磁盘组坏了,而数据所在的磁盘组是好的,这个时候该怎么恢复呢？1.OCR磁盘组恢复两种案例情况：a.有ocr备份的恢复b.无ocr备份的恢复但...
rac asm环境数据库db修改spfile故障后，如何恢复
05-25
当你修改 SPFILE 文件时，如果出现故障，可以根据以下步骤进行恢复： 1. 确认你的 SPFILE 文件存在，可以使用以下命令查看： ``` SHOW PARAMETER spfile; ``` 2. 如果 SPFILE 文件存在，那么可以使用以下命令来恢复： ``` STARTUP FORCE ``` 这会强制 Oracle 数据库使用 SPFILE 文件来启动数据库。 3. 如果 SPFILE 文件丢失，那么可以使用 PFILE 文件来启动数据库。可以使用以下命令将 PFILE 文件转换为 SPFILE 文件： ``` CREATE SPFILE FROM PFILE='<path_to_pfile>'; ``` 然后，可以使用以下命令来启动数据库： ``` STARTUP FORCE ``` 这会强制 Oracle 数据库使用 SPFILE 文件来启动数据库。 如果以上方法无法解决问题，可以考虑使用 RMAN 进行数据库恢复。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

楚枫默寒

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值