IT数码 购物 网址 头条 软件 日历 阅读 图书馆
TxT小说阅读器
↓语音阅读,小说下载,古典文学↓
图片批量下载器
↓批量下载图片,美女图库↓
图片自动播放器
↓图片自动播放器↓
一键清除垃圾
↓轻轻一点,清除系统垃圾↓
开发: C++知识库 Java知识库 JavaScript Python PHP知识库 人工智能 区块链 大数据 移动开发 嵌入式 开发工具 数据结构与算法 开发测试 游戏开发 网络协议 系统运维
教程: HTML教程 CSS教程 JavaScript教程 Go语言教程 JQuery教程 VUE教程 VUE3教程 Bootstrap教程 SQL数据库教程 C语言教程 C++教程 Java教程 Python教程 Python3教程 C#教程
数码: 电脑 笔记本 显卡 显示器 固态硬盘 硬盘 耳机 手机 iphone vivo oppo 小米 华为 单反 装机 图拉丁
 
   -> 大数据 -> redo异常强制拉库报ORA-600 kcbzib_kcrsds_1修复---惜分飞 -> 正文阅读

[大数据]redo异常强制拉库报ORA-600 kcbzib_kcrsds_1修复---惜分飞

标题:redo异常强制拉库报ORA-600 kcbzib_kcrsds_1修复

作者:惜分飞?版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

节点2 asm dismount导致redo写报错(ORA-00340,ORA-00345),经过分析asm和系统日志,确认是由于多路径异常导致io异常

2022-01-24T23:44:39.966602+08:00

WARNING: group 4 is being dismounted.

WARNING: ASMB force dismounting group 4 (REDO) due to ASM server dismount

SUCCESS: diskgroup REDO was dismounted

2022-01-24T23:44:41.103783+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF2/trace/XFF2_lgwr_228507.trc:

ORA-00345: redo log write error block 11961764 count 6

ORA-00312: online log 10 thread 2: '+REDO/XFF/ONLINELOG/group_10.261.1074690685'

2022-01-24T23:44:41.156809+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF2/trace/XFF2_lgwr_228507.trc:

ORA-00340: IO error processing online log 10 of thread 2

ORA-00345: redo log write error block 11961764 count 6

ORA-00312: online log 10 thread 2: '+REDO/XFF/ONLINELOG/group_10.261.1074690685'

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF2/trace/XFF2_lgwr_228507.trc? (incident=1341402):

ORA-340 [] [] [] [] [] [] [] [] [] [] [] []

Incident details in: /u01/app/oracle/diag/rdbms/xff/XFF2/incident/incdir_1341402/XFF2_lgwr_228507_i1341402.trc

2022-01-24T23:44:41.505251+08:00

USER (ospid: 133928): terminating the instance due to error 340

由于节点2是突然crash,节点1做实例恢复失败,由于节点2的redo发生了写丢失,导致节点1实例恢复后库crash,进而是的该集群的相关数据库节点全部crash

2022-01-24T23:46:08.440519+08:00

Slave encountered ORA-10388 exception during crash recovery

2022-01-24T23:46:08.442854+08:00

Slave encountered ORA-10388 exception during crash recovery

Abort recovery for domain 0, flags 4

2022-01-24T23:46:08.444531+08:00

Aborting crash recovery due to error 742

2022-01-24T23:46:08.444695+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF1/trace/XFF1_ora_450481.trc:

ORA-00742: Log read detects lost write in thread 2 sequence 63507 block 11941482

ORA-00312: online log 10 thread 2: '+REDO/XFF/ONLINELOG/group_10.261.1074690685'

Abort recovery for domain 0, flags 4

2022-01-24T23:46:08.771108+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF1/trace/XFF1_ora_450481.trc:

ORA-00742: Log read detects lost write inthread 2 sequence 63507 block 11941482

ORA-00312: online log 10 thread 2: '+REDO/XFF/ONLINELOG/group_10.261.1074690685'

ORA-742 signalled during: ALTER DATABASE OPEN /* db agent *//* {0:17:165} */...

2022-01-24T23:46:10.143155+08:00

License high water mark = 33

2022-01-24T23:46:10.143752+08:00

USER (ospid: 451049): terminating the instance

2022-01-24T23:46:11.167337+08:00

Instance terminated by USER, pid = 451049

经过第三方强制拉库之后,数据库报ORA-600 kcbzib_kcrsds_1

2022-01-25T10:13:37.922332+08:00

Completed crash recovery at

?Thread 2: RBA 5.3.16, nab 3, scn 0x00000a348a032122

?0 data blocks read, 0 data blocks written, 0 redo k-bytes read

2022-01-25T10:13:38.071326+08:00

Thread 2 advanced to log sequence 6 (thread recovery)

validate pdb 0, flags x4, valid 0, pdb flags x204

* validated domain 0, flags = 0x200

CRASH recovery complete: pdb 0 valid 1 (flags x4, pdb flags x200)

Picked broadcast on commit scheme to generate SCNs

Endian type of dictionary set to little

2022-01-25T10:13:38.389741+08:00

TT00: Gap Manager starting (PID:220505)

2022-01-25T10:13:38.646484+08:00

Thread 1 opened at log sequence 1

??Current log# 1 seq# 1 mem# 0: +DATA/XFF/ONLINELOG/group_1.536.1094875107

Successful open of redo thread 1

2022-01-25T10:13:38.647243+08:00

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF1/trace/XFF1_ora_216590.trc? (incident=1879556):

ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], []

Incident details in: /u01/app/oracle/diag/rdbms/xff/XFF1/incident/incdir_1879556/XFF1_ora_216590_i1879556.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

*****************************************************************

An internal routine has requested a dump of selected redo.

This usually happens following a specific internal error, when

analysis of the redo logs will help Oracle Support with the

diagnosis.

It is recommended that you retain all the redo logs generated (by

all the instances) during the past 12 hours, in case additional

redo dumps are required to help with the diagnosis.

*****************************************************************

2022-01-25T10:13:39.734366+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF1/trace/XFF1_ora_216590.trc:

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], []

2022-01-25T10:13:39.734424+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF1/trace/XFF1_ora_216590.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], []

2022-01-25T10:13:39.734499+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF1/trace/XFF1_ora_216590.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], []

2022-01-25T10:13:39.734536+08:00

Error 704 happened during db open, shutting down database

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF1/trace/XFF1_ora_216590.trc? (incident=1879557):

ORA-00603: ORACLE server session terminated by fatal error

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], []

Incident details in: /u01/app/oracle/diag/rdbms/xff/XFF1/incident/incdir_1879557/XFF1_ora_216590_i1879557.trc

2022-01-25T10:13:39.894464+08:00

2022-01-25T10:13:40.446888+08:00

opiodr aborting process unknown ospid (216590) as a result of ORA-603

2022-01-25T10:13:40.470643+08:00

ORA-603 : opitsk aborting process

License high water mark = 36

2022-01-25T10:13:40.471453+08:00

USER (ospid: 216590): terminating the instance due to error 704

2022-01-25T10:13:41.436133+08:00

opiodr aborting process unknown ospid (189796) as a result of ORA-1092

2022-01-25T10:13:41.439011+08:00

ORA-1092 : opitsk aborting process

2022-01-25T10:13:41.472060+08:00

PMON (ospid: 189585): terminating the instance due to error 704

该错误是12c之后才有的报错,由于文件异常导致,通过以前的解决经验,接手这个问题之后快速调整数据库文件头信息,顺利open库
参考以前相关blog内容:
Oracle 12c redo 丢失恢复
模拟19c数据库redo异常恢复
ORA-600 kcbzib_kcrsds_1报错
12C数据库报ORA-600 kcbzib_kcrsds_1故障处理
ORA-00603 ORA-01092 ORA-600 kcbzib_kcrsds_1

[oracle@xifenfei02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 26 00:31:50 2022

Copyright (c) 1982, 2016, Oracle.? All rights reserved.

Connected to an idle instance.

SQL> startup mount pfile='/tmp/pfile'

ORACLE instance started.

Total System Global Area 3.2320E+11 bytes

Fixed Size???????????????? 29879248 bytes

Variable Size??????????? 4.5634E+10 bytes

Database Buffers???????? 1.9059E+11 bytes

Redo Buffers???????????? 1043861504 bytes

In-Memory Area?????????? 8.5899E+10 bytes

Database mounted.

SQL> alter database open ;

Database altered.

?

  大数据 最新文章
实现Kafka至少消费一次
亚马逊云科技:还在苦于ETL?Zero ETL的时代
初探MapReduce
【SpringBoot框架篇】32.基于注解+redis实现
Elasticsearch:如何减少 Elasticsearch 集
Go redis操作
Redis面试题
专题五 Redis高并发场景
基于GBase8s和Calcite的多数据源查询
Redis——底层数据结构原理
上一篇文章      下一篇文章      查看所有文章
加:2022-01-28 11:59:11  更:2022-01-28 11:59:38 
 
开发: C++知识库 Java知识库 JavaScript Python PHP知识库 人工智能 区块链 大数据 移动开发 嵌入式 开发工具 数据结构与算法 开发测试 游戏开发 网络协议 系统运维
教程: HTML教程 CSS教程 JavaScript教程 Go语言教程 JQuery教程 VUE教程 VUE3教程 Bootstrap教程 SQL数据库教程 C语言教程 C++教程 Java教程 Python教程 Python3教程 C#教程
数码: 电脑 笔记本 显卡 显示器 固态硬盘 硬盘 耳机 手机 iphone vivo oppo 小米 华为 单反 装机 图拉丁

360图书馆 购物 三丰科技 阅读网 日历 万年历 2024年11日历 -2024/11/24 14:11:06-

图片自动播放器
↓图片自动播放器↓
TxT小说阅读器
↓语音阅读,小说下载,古典文学↓
一键清除垃圾
↓轻轻一点,清除系统垃圾↓
图片批量下载器
↓批量下载图片,美女图库↓
  网站联系: qq:121756557 email:121756557@qq.com  IT数码