19c库启动报ORA-600 kcbzib_kcrsds_1---惜分飞

2024-08-26 15:04

本文主要是介绍19c库启动报ORA-600 kcbzib_kcrsds_1---惜分飞,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

一套19c的库由于某种情况,发现异常,当时的技术使用隐含参数强制拉库,导致数据库启动报ORA-00704 ORA-600 kcbzib_kcrsds_1错误

2024-08-24T06:11:25.494304+08:00

ALTER DATABASE OPEN

2024-08-24T06:11:25.494370+08:00

TMI: adbdrv open database BEGIN 2024-08-24 06:11:25.494324

Smart fusion block transfer is disabled:

  instance mounted in exclusive mode.

2024-08-24T06:11:25.515306+08:00

Beginning crash recovery of 1 threads

 parallel recovery started with 7 processes

 Thread 1: Recovery starting at checkpoint rba (logseq 2 block 3), scn 286550073

2024-08-24T06:11:25.567011+08:00

Started redo scan

2024-08-24T06:11:25.587170+08:00

Completed redo scan

 read 0 KB redo, 0 data blocks need recovery

2024-08-24T06:11:25.595192+08:00

Started redo application at

 Thread 1: logseq 2, block 3, offset 0, scn 0x0000000011146839

2024-08-24T06:11:25.595552+08:00

Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0

  Mem# 0: /dbf/RLZY/redo02.log

2024-08-24T06:11:25.595712+08:00

Completed redo application of 0.00MB

2024-08-24T06:11:25.596058+08:00

Completed crash recovery at

 Thread 1: RBA 2.3.0, nab 3, scn 0x000000001114683a

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

Endian type of dictionary set to little

2024-08-24T06:11:25.648152+08:00

LGWR (PID:1614826): STARTING ARCH PROCESSES

2024-08-24T06:11:25.661738+08:00

TT00 (PID:1614908): Gap Manager starting

Starting background process ARC0

2024-08-24T06:11:25.677246+08:00

ARC0 started with pid=54, OS id=1614910

2024-08-24T06:11:25.687525+08:00

LGWR (PID:1614826): ARC0: Archival started

LGWR (PID:1614826): STARTING ARCH PROCESSES COMPLETE

2024-08-24T06:11:25.687733+08:00

ARC0 (PID:1614910): Becoming a 'no FAL' ARCH

ARC0 (PID:1614910): Becoming the 'no SRL' ARCH

2024-08-24T06:11:25.696437+08:00

TMON (PID:1614886): STARTING ARCH PROCESSES

Starting background process ARC1

2024-08-24T06:11:25.711645+08:00

Thread 1 advanced to log sequence 3 (thread open)

Redo log for group 3, sequence 3 is not located on DAX storage

2024-08-24T06:11:25.715270+08:00

ARC1 started with pid=56, OS id=1614914

Starting background process ARC2

Thread 1 opened at log sequence 3

  Current log# 3 seq# 3 mem# 0: /dbf/RLZY/redo03.log

Successful open of redo thread 1

2024-08-24T06:11:25.728586+08:00

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Stopping change tracking

2024-08-24T06:11:25.734124+08:00

ARC2 started with pid=57, OS id=1614916

Starting background process ARC3

2024-08-24T06:11:25.752891+08:00

ARC3 started with pid=58, OS id=1614918

2024-08-24T06:11:25.752979+08:00

TMON (PID:1614886): ARC1: Archival started

TMON (PID:1614886): ARC2: Archival started

TMON (PID:1614886): ARC3: Archival started

TMON (PID:1614886): STARTING ARCH PROCESSES COMPLETE

2024-08-24T06:11:25.802551+08:00

ARC0 (PID:1614910): Archived Log entry 2828 added for T-1.S-2 ID 0x74f18f91 LAD:1

2024-08-24T06:11:25.806845+08:00

TT03 (PID:1614922): Sleep 5 seconds and then try to clear SRLs in 2 time(s)

Errors in file /oracle/diag/rdbms/xff/xff/trace/xff_ora_1614892.trc  (incident=124865):

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

Incident details in: /oracle/diag/rdbms/xff/xff/incident/incdir_124865/xff_ora_1614892_i124865.trc

Use ADRCI or Support Workbench to package the incident.

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

2024-08-24T06:11:25.871925+08:00

2024-08-24T06:11:26.772652+08:00

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

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.

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

2024-08-24T06:11:26.872265+08:00

Errors in file /oracle/diag/rdbms/xff/xff/trace/xff_ora_1614892.trc:

ORA-00704: bootstrap process failure

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

2024-08-24T06:11:26.872351+08:00

Errors in file /oracle/diag/rdbms/xff/xff/trace/xff_ora_1614892.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

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

2024-08-24T06:11:26.872412+08:00

Errors in file /oracle/diag/rdbms/xff/xff/trace/xff_ora_1614892.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

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

2024-08-24T06:11:26.872455+08:00

Error 704 happened during db open, shutting down database

Errors in file /oracle/diag/rdbms/xff/xff/trace/xff_ora_1614892.trc  (incident=124866):

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: /oracle/diag/rdbms/xff/xff/incident/incdir_124866/xff_ora_1614892_i124866.trc

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

2024-08-24T06:11:27.498146+08:00

Errors in file /oracle/diag/rdbms/xff/xff/trace/xff_ora_1614892.trc:

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], [], [], [], [], [], [], [], [], [], [], []

2024-08-24T06:11:27.501122+08:00

ORA-603 : opitsk aborting process

License high water mark = 8

USER(prelim) (ospid: 1614892): terminating the instance due to ORA error 704

2024-08-24T06:11:28.526358+08:00

Instance terminated by USER(prelim), pid = 1614892

官方关于kcbzib_kcrsds_1从解释只有:Bug 31887074 – sr21.1bigscn_hipu3 – trc – ksfdopn2 – ORA-600 [kcbzib_kcrsds_1] (Doc ID 31887074.8)
 

ksfdopn2


虽然关于ORA-600 [kcbzib_kcrsds_1],oracle官方没有给出来解决方案,其实通过以往大量的恢复案例和经验中已经知道,这个错误解决方案就是修改oracle scn的方法可以绕过去,以前有过一些类似恢复案例:
ORA-600 kcbzib_kcrsds_1报错
12C数据库报ORA-600 kcbzib_kcrsds_1故障处理
ORA-00603 ORA-01092 ORA-600 kcbzib_kcrsds_1
redo异常强制拉库报ORA-600 kcbzib_kcrsds_1修复
Patch SCN工具一键恢复ORA-600 kcbzib_kcrsds_1
存储故障,强制拉库报ORA-600 kcbzib_kcrsds_1处理

这篇关于19c库启动报ORA-600 kcbzib_kcrsds_1---惜分飞的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/1108898

相关文章

nginx启动命令和默认配置文件的使用

《nginx启动命令和默认配置文件的使用》:本文主要介绍nginx启动命令和默认配置文件的使用,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录常见命令nginx.conf配置文件location匹配规则图片服务器总结常见命令# 默认配置文件启动./nginx

Nexus安装和启动的实现教程

《Nexus安装和启动的实现教程》:本文主要介绍Nexus安装和启动的实现教程,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录一、Nexus下载二、Nexus安装和启动三、关闭Nexus总结一、Nexus下载官方下载链接:DownloadWindows系统根

Java中实现线程的创建和启动的方法

《Java中实现线程的创建和启动的方法》在Java中,实现线程的创建和启动是两个不同但紧密相关的概念,理解为什么要启动线程(调用start()方法)而非直接调用run()方法,是掌握多线程编程的关键,... 目录1. 线程的生命周期2. start() vs run() 的本质区别3. 为什么必须通过 st

Oracle修改端口号之后无法启动的解决方案

《Oracle修改端口号之后无法启动的解决方案》Oracle数据库更改端口后出现监听器无法启动的问题确实较为常见,但并非必然发生,这一问题通常源于​​配置错误或环境冲突​​,而非端口修改本身,以下是系... 目录一、问题根源分析​​​二、保姆级解决方案​​​​步骤1:修正监听器配置文件 (listener.

MySQL版本问题导致项目无法启动问题的解决方案

《MySQL版本问题导致项目无法启动问题的解决方案》本文记录了一次因MySQL版本不一致导致项目启动失败的经历,详细解析了连接错误的原因,并提供了两种解决方案:调整连接字符串禁用SSL或统一MySQL... 目录本地项目启动报错报错原因:解决方案第一个:第二种:容器启动mysql的坑两种修改时区的方法:本地

MySQL启动报错:InnoDB表空间丢失问题及解决方法

《MySQL启动报错:InnoDB表空间丢失问题及解决方法》在启动MySQL时,遇到了InnoDB:Tablespace5975wasnotfound,该错误表明MySQL在启动过程中无法找到指定的s... 目录mysql 启动报错:InnoDB 表空间丢失问题及解决方法错误分析解决方案1. 启用 inno

无法启动此程序因为计算机丢失api-ms-win-core-path-l1-1-0.dll修复方案

《无法启动此程序因为计算机丢失api-ms-win-core-path-l1-1-0.dll修复方案》:本文主要介绍了无法启动此程序,详细内容请阅读本文,希望能对你有所帮助... 在计算机使用过程中,我们经常会遇到一些错误提示,其中之一就是"api-ms-win-core-path-l1-1-0.dll丢失

解决tomcat启动时报Junit相关错误java.lang.ClassNotFoundException: org.junit.Test问题

《解决tomcat启动时报Junit相关错误java.lang.ClassNotFoundException:org.junit.Test问题》:本文主要介绍解决tomcat启动时报Junit相... 目录tomcat启动时报Junit相关错误Java.lang.ClassNotFoundException

Redis在windows环境下如何启动

《Redis在windows环境下如何启动》:本文主要介绍Redis在windows环境下如何启动的实现方式,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录Redis在Windows环境下启动1.在redis的安装目录下2.输入·redis-server.exe

解决SpringBoot启动报错:Failed to load property source from location 'classpath:/application.yml'

《解决SpringBoot启动报错:Failedtoloadpropertysourcefromlocationclasspath:/application.yml问题》这篇文章主要介绍... 目录在启动SpringBoot项目时报如下错误原因可能是1.yml中语法错误2.yml文件格式是GBK总结在启动S