联系：手机/微信(+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