硬件故障,客户自行强制resetlogs库,报ORA-600 kcbzib_kcrsds_1错误 2024-01-17T17:30:33.094367+08:00 alter database open resetlogs 2024-01-17T17:30:33.105461+08:00 RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESE...
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/...
一个19c库由于某种原因redo损坏强制打开库报ORA-600 kcbzib_kcrsds_1错误 SQL> startup mount pfile='?/database/pfile.txt'; ORACLE instance started. Total System Global Area 859830696 bytes Fixed Size 9034152 bytes Variable Size 566231040 bytes Database Buffers 276824064 bytes Redo Buffers 7741440 bytes...
客户存储故障,修复之后,多套库增加_allow_resetlogs_corruption隐含参数强制拉库出现都类似错误ORA-600 kcbzib_kcrsds_1,出现这个错误,一般都是由于数据库不一致强制拉库导致 2019-02-23T01:25:43.125621+08:00 alter database open resetlogs 2019-02-23T01:25:43.231990+08:00 ...
对于这种情况,选择强制拉库,然后数据库报ORA-600 kcbzib_kcrsds_1错误 对于此类故障参考以前处理过类似案例:ORA-600 kcbzib_kcrsds_1报错,对数据库scn进行修改(这类错误可以通过PATCH SCN工具快速解决),数据库顺利open
这个错误一般是由于之前resetlogs未能正常打开库导致,通过rectl之后,尝试重新打开库,报错为:ORA-600 kcbzib_kcrsds_1 SQL>ALTERDATABASEOPEN; ALTERDATABASEOPEN * ERRORatline 1: ORA-00603: ORACLE server session terminatedbyfatal error ORA-01092: ORACLE instance terminated. Disconnection forced ...
Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_66361.trc (incident=672241): ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [] Incident details in: /database/oracle/app/oracle/diag/rdbms/xff/xff/incident/incdir_67...
由于客户误操作,在有文件offline的情况下进行resetlogs操作,导致有文件resetlogs scn不对 尝试offline异常文件,均报ORA-600 3600 ---直接offline Wed Jan 26 11:08:15 2022 ALTER DATABASE RECOVER database until cancel Media Recovery Start started logmerger process ...
ORA-00283: recovery session canceled due to errors ORA-19909: datafile 8 belongs to an orphan incarnation ORA-01110: data file 8: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\XIFENFEI.DBF' Recovery Slave PR00 previously exited with exception 283 ...
Errorsinfile/oracle/db/diag/rdbms/xff/xff1/trace/xff1_ora_5767246.trc: ORA-01113:file32 needs media recovery ORA-01110: datafile32:'+DATA/xff/datafile/x5sys_cs.dbf' ORA-1113 signalled during: ALTER DATABASE OPEN... Wed Feb 21 09:23:27 2024 ...