ORA-00603 ORA-01092 ORA-600 kcbzib_kcrsds_1

联系：手机/微信(+86 17813235971) QQ(107644445)

标题：ORA-00603 ORA-01092 ORA-600 kcbzib_kcrsds_1

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

接手客户故障数据库报错为:ORA-16433

[orauser@xifenfei check_db]$ sqlplus / as sysdba

 

SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 14 02:36:24 2021

 

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

 

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

 

SQL> alter database backup controlfile to trace as '/tmp/ctl';

alter database backup controlfile to trace as '/tmp/ctl'

*

ERROR at line 1:

ORA-16433: The database or pluggable database must be opened in read/write mode.

 

 

SQL> recover datafile 1;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database or pluggable database must be opened in read/write mode.

这个错误一般是由于之前resetlogs未能正常打开库导致,通过rectl之后,尝试重新打开库,报错为:ORA-600 kcbzib_kcrsds_1

SQL> ALTER DATABASE OPEN;

ALTER DATABASE OPEN

*

ERROR at line 1:

ORA-00603: ORACLE server session terminated by fatal error

ORA-01092: ORACLE instance terminated. Disconnection forced

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

Process ID: 49304

Session ID: 4698 Serial number: 14852

这个错误一般是scn问题,对于之前版本直接使用隐含参数,event,oradebug进行调整scn即可,但是在12.2版本之后无法使用这些方法修改,处理起来相对麻烦一些，参考以前处理的相关文章:
ORA-600 kcbzib_kcrsds_1报错
12C数据库报ORA-600 kcbzib_kcrsds_1故障处理
oradebug poke ORA-32521/ORA-32519故障解决

• ora-600 2662和ora-600 kclchkblk_4恢复
• 12C数据库报ORA-600 kcbzib_kcrsds_1故障处理
• 模拟19c数据库redo异常恢复
• 分享一次ORA-01113 ORA-01110故障处理过程
• Oracle Recovery Tools恢复—ORA-00704 ORA-01555故障
• rm -rf 删除数据文件恢复方法—文件系统反删除+oracle碎片重组
• ORA-600 kcbzib_kcrsds_1报错
• 模拟19c数据库root pdb undo异常恢复
• oradebug poke ORA-32521/ORA-32519故障解决
• 再次遇到ORA-600 kokasgi1故障恢复
• Oracle Recovery Tools 解决ORA-01190 ORA-01248等故障
• 记录一次pdb恢复过程中遇到的大量bug