标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,655)
- DB2 (22)
- MySQL (71)
- Oracle (1,519)
- Data Guard (51)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (65)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (553)
- Oracle安装升级 (90)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (76)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- RAC默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
- Linux 8 修改网卡名称
- 如何修改集群的公网信息(包括 VIP) (Doc ID 1674442.1)
- 如何在 oracle 集群环境下修改私网信息 (Doc ID 2103317.1)
- ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] 相关bug
- ORA-600 krhpfh_03-1210故障处理
- 19c库启动报ORA-600 kcbzib_kcrsds_1
- DBMS_SESSION.set_context提示ORA-01031问题解决
- redo写丢失导致ORA-600 kcrf_resilver_log_1故障
- 硬件故障导致ORA-01242 ORA-01122等错误
- 200T 数据库非归档无备份恢复
- 利用flashback快速恢复failover 的备库
- [comingback2022@cock.li].eking和[tsai.shen@mailfence.com].faust扩展名勒索病毒数据库可以完美恢复
- opatch auto 出现unable to get oracle owner for 错误
- Oracle 23ai 表和视图的列最多支持到4096个
- 断电引起redo和数据文件不一致故障恢复
- ORA-03113: 通信通道的文件结尾
标签归档:rac时间超过10分钟无法启动
RAC主机相差超过10分钟导致crs无法启动
客户反馈有一套19c 2节点rac,断电之后,一个节点数据库无法正常启动,通过crsctl命令查看发现crs进程没有正常启动
[root@xifenf1 ~]# /u01/app/19.0/grid/bin/crsctl status res -t -init -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 ONLINE OFFLINE STABLE ora.cluster_interconnect.haip 1 ONLINE ONLINE xifenf1 STABLE ora.crf 1 ONLINE ONLINE xifenf1 STABLE ora.crsd 1 ONLINE OFFLINE STABLE ora.cssd 1 ONLINE ONLINE xifenf1 STABLE ora.cssdmonitor 1 ONLINE ONLINE xifenf1 STABLE ora.ctssd 1 ONLINE OFFLINE STABLE ora.diskmon 1 OFFLINE OFFLINE STABLE ora.evmd 1 ONLINE ONLINE xifenf1 STABLE ora.gipcd 1 ONLINE ONLINE xifenf1 STABLE ora.gpnpd 1 ONLINE ONLINE xifenf1 STABLE ora.mdnsd 1 ONLINE ONLINE xifenf1 STABLE ora.storage 1 ONLINE ONLINE xifenf1 STABLE --------------------------------------------------------------------------------
查看crs的alert日志发现集群时间间隔超过600s,无法启动csst进程
2024-06-11 17:33:09.953 [OCSSD(5020)]CRS-1605: CSSD voting file is online: /dev/asm_ocr5; details in /u01/app/grid/diag/crs/xifenf1/crs/trace/ocssd.trc. 2024-06-11 17:33:09.956 [OCSSD(5020)]CRS-1605: CSSD voting file is online: /dev/asm_ocr1; details in /u01/app/grid/diag/crs/xifenf1/crs/trace/ocssd.trc. 2024-06-11 17:33:10.024 [OCSSD(5020)]CRS-1605: CSSD voting file is online: /dev/asm_ocr2; details in /u01/app/grid/diag/crs/xifenf1/crs/trace/ocssd.trc. 2024-06-11 17:33:10.031 [OCSSD(5020)]CRS-1605: CSSD voting file is online: /dev/asm_ocr4; details in /u01/app/grid/diag/crs/xifenf1/crs/trace/ocssd.trc. 2024-06-11 17:33:10.040 [OCSSD(5020)]CRS-1605: CSSD voting file is online: /dev/asm_ocr3; details in /u01/app/grid/diag/crs/xifenf1/crs/trace/ocssd.trc. 2024-06-11 17:33:11.900 [OCSSD(5020)]CRS-1601: CSSD Reconfiguration complete. Active nodes are xifenf1 xifenf2 . 2024-06-11 17:33:13.344 [OCSSD(5020)]CRS-1720: Cluster Synchronization Services daemon (CSSD) is ready for operation. 2024-06-11 17:33:13.809 [OCTSSD(5488)]CRS-8500: Oracle Clusterware OCTSSD process is starting with operating system process ID 5488 2024-06-11 17:33:16.017 [OCTSSD(5488)]CRS-2407: The new Cluster Time Synchronization Service reference node is host xifenf2. 2024-06-11 17:33:16.018 [OCTSSD(5488)]CRS-2401: The Cluster Time Synchronization Service started on host xifenf1. 2024-06-11 17:33:16.105 [OCTSSD(5488)]CRS-2419: The clock on host xifenf1 differs from mean cluster time by 1031504618 microseconds. The Cluster Time Synchronization Service will not perform time synchronization because the time difference is beyond the permissible offset of 600 seconds. Details in /u01/app/grid/diag/crs/xifenf1/crs/trace/octssd.trc. 2024-06-11 17:33:16.579 [OCTSSD(5488)]CRS-2402: The Cluster Time Synchronization Service aborted on host xifenf1. Details at (:ctsselect_mstm4:) in /u01/app/grid/diag/crs/xifenf1/crs/trace/octssd.trc.
查看主机时间
[grid@xifenf1 ~]$ date ;ssh xifenf2 date Tue Jun 11 17:54:09 CST 2024 Tue Jun 11 18:04:34 CST 2024
修改主机时间
[root@xifenf1 ~]# date -s "20240611 18:06:00" Tue Jun 11 18:06:00 CST 2024 [root@xifenf1 ~]# su - grid Last login: Tue Jun 11 17:37:53 CST 2024 on pts/0 [grid@xifenf1 ~]$ date ;ssh xifenf2 date Tue Jun 11 18:06:09 CST 2024 Tue Jun 11 18:05:34 CST 2024
重启crs
[root@xifenf1 ~]# /u01/app/19.0/grid/bin/crsctl stop crs -f CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'xifenf1' CRS-2673: Attempting to stop 'ora.storage' on 'xifenf1' CRS-2673: Attempting to stop 'ora.mdnsd' on 'xifenf1' CRS-2673: Attempting to stop 'ora.crf' on 'xifenf1' CRS-2677: Stop of 'ora.storage' on 'xifenf1' succeeded CRS-2673: Attempting to stop 'ora.evmd' on 'xifenf1' CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'xifenf1' CRS-2677: Stop of 'ora.mdnsd' on 'xifenf1' succeeded CRS-2677: Stop of 'ora.crf' on 'xifenf1' succeeded CRS-2677: Stop of 'ora.evmd' on 'xifenf1' succeeded CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'xifenf1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'xifenf1' CRS-2677: Stop of 'ora.cssd' on 'xifenf1' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'xifenf1' CRS-2673: Attempting to stop 'ora.gipcd' on 'xifenf1' CRS-2677: Stop of 'ora.gpnpd' on 'xifenf1' succeeded CRS-2677: Stop of 'ora.gipcd' on 'xifenf1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'xifenf1' has completed CRS-4133: Oracle High Availability Services has been stopped. [root@xifenf1 ~]# /u01/app/19.0/grid/bin/crsctl start crs CRS-4123: Oracle High Availability Services has been started. [root@xifenf1 ~]# /u01/app/19.0/grid/bin/crsctl status res -t -init -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 ONLINE ONLINE xifenf1 STABLE ora.cluster_interconnect.haip 1 ONLINE ONLINE xifenf1 STABLE ora.crf 1 ONLINE ONLINE xifenf1 STABLE ora.crsd 1 ONLINE ONLINE xifenf1 STABLE ora.cssd 1 ONLINE ONLINE xifenf1 STABLE ora.cssdmonitor 1 ONLINE ONLINE xifenf1 STABLE ora.ctssd 1 ONLINE ONLINE xifenf1 ACTIVE:35600,STABLE ora.diskmon 1 OFFLINE OFFLINE STABLE ora.evmd 1 ONLINE ONLINE xifenf1 STABLE ora.gipcd 1 ONLINE ONLINE xifenf1 STABLE ora.gpnpd 1 ONLINE ONLINE xifenf1 STABLE ora.mdnsd 1 ONLINE ONLINE xifenf1 STABLE ora.storage 1 ONLINE ONLINE xifenf1 STABLE --------------------------------------------------------------------------------