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

embedded/2024/10/16 2:27:38/

一套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处理


http://www.ppmy.cn/embedded/101496.html

相关文章

搭建FTP服务器,通过浏览器访问FTP服务器,测试终端上传的音频文件。

文章目录 引言I 搭建FTP服务器II 浏览器访问FTP文件PC端浏览器访问iphone-safari浏览器访问FTP设置Mac-Safari浏览器访问FTP设置III FTP基础知识FTP客户端数据连接: 被动模式(PASV)引言 需求: 通过浏览器访问,测试终端通过FTP上传的语音文件,支持直接播放语音文件。 建议…

微信小程序怎样进行本地存储的读、写、删、清?同步及异步两种类型

微信小程序提供了本地存储的API,允许开发者在页面上保存用户数据,以便在用户的会话或跨会话中持久化数据。本地存储支持同步和异步两种方式来进行读、写、删、清操作。 同步方式 微信小程序从基础库版本 2.10.0 开始,逐步废弃了同步的本地存…

在CentOS 7上安装MariaDB的方法

前些天发现了一个巨牛的人工智能学习网站,通俗易懂,风趣幽默,忍不住分享一下给大家。点击跳转到网站。 简介 MariaDB 是一个开源的数据库管理系统,通常作为流行的 LEMP(Linux、Nginx、MySQL/MariaDB、PHP/Python/Per…

0基础学习spark

零、pyspark模板 import os from pyspark import SparkContext, SparkConf os.environ[SPARK_HOME] /export/server/spark os.environ[PYSPARK_PYTHON] /root/anaconda3/bin/python3 os.environ[PYSPARK_DIRVER_PYTHON] /root/anaconda3/bin/python3 if __name__ __main__:…

【Rust光年纪】探索Rust语言中的WebAssembly利器:核心功能、安装配置与API概览

构建现代Web应用:掌握Rust语言的前端开发利器 前言 在现代的Web开发中,使用Rust语言进行前端和图形开发变得越来越流行。本文将介绍一些用于Rust语言的WebAssembly、WebGPU库,以及现代Web框架和与JavaScript互操作的库,帮助读者…

Android 模拟器的简单操作

Android 模拟器的简单操作 一、adb 命令查看模拟器基础信息 1、查看屏幕的尺寸adb shell wm size2、查看屏幕密度adb shell wm density二、常用几个 adb 命令 返回到主页,模拟按下设备的 “Home” 按钮 adb shell input keyevent 3adb shell input keyeve…

架构师面试题系列之Spring MVC面试专题及答案(31题)

目录 1、什么是 SpringMvc?说一下你对它的理解2、SpringMVC 的优点 :3、SpringMVC 工作原理?4、SpringMVC 的主要组件?5、讲下 SpringMvc 的执行流程6、SpingMvc 中的控制器的注解一般用那个,有没有别的注解可以替代?7、如果在拦截请求中,想拦截 get 方式提交的方法,怎么…

vue在生产环境和测试环境去掉 console 打印日志 只保留 “error“、 “warn“

vue在生产环境和测试环境去掉 console 打印日志 只保留 “error”、 “warn” 文章目录 vue在生产环境和测试环境去掉 console 打印日志 只保留 "error"、 "warn"一、安装插件二、babel.config.js配置 一、安装插件 npm install babel-plugin-transform-r…