联系：手机/微信(+86 17813235971) QQ(107644445)标题：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 ...继续阅读 (30)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：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 ...继续阅读 (43)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-00756 ORA-10567故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库异常断电之后，recover 报ORA-00756 ORA-10567等错SQL> recover database; ORA-00756: 恢复操作检测到数据块写入丢失 ORA-10567: Redo is inconsistent with data block (file# 1,block# 113855,file offset is 932700160 bytes) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 67alert日志报大量block逻辑错误2024-07-16T13:16:31.050599+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.050599+08:00 Errors in f ...继续阅读 (47)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-00756 ORA-10567故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库异常断电之后，recover 报ORA-00756 ORA-10567等错SQL> recover database; ORA-00756: 恢复操作检测到数据块写入丢失 ORA-10567: Redo is inconsistent with data block (file# 1,block# 113855,file offset is 932700160 bytes) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 67alert日志报大量block逻辑错误2024-07-16T13:16:31.050599+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.050599+08:00 Errors in f ...继续阅读 (43)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 23ai rm redo*.log恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在oracle 23ai的pdb中创建用户和表,并且插入数据(不提交),在另外一个会话中abort库,并从os层面rm删除掉redo文件,模拟数据库当前redo丢失,数据库恢复创建用户和表并插入数据[oracle@xifenfei ~]$ sqlplus sys/oracle@free as sysdba SQL*Plus: Release 23.0.0.0.0 - Production on Fri May 3 15:40:55 2024 Version 23.4.0.24.05 Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free Version 23.4.0.24.05 SQL> SQL> SQL> show pdbs; CON_ID CON_NAME ...继续阅读 (54)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 23ai rm redo*.log恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在oracle 23ai的pdb中创建用户和表,并且插入数据(不提交),在另外一个会话中abort库,并从os层面rm删除掉redo文件,模拟数据库当前redo丢失,数据库恢复创建用户和表并插入数据[oracle@xifenfei ~]$ sqlplus sys/oracle@free as sysdba SQL*Plus: Release 23.0.0.0.0 - Production on Fri May 3 15:40:55 2024 Version 23.4.0.24.05 Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free Version 23.4.0.24.05 SQL> SQL> SQL> show pdbs; CON_ID CON_NAME ...继续阅读 (46)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：存储故障,强制拉库报ORA-600 kcbzib_kcrsds_1处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]硬件故障,客户自行强制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. RESETLOGS after incomplete recovery UNTIL CHANGE 16456823130015 time .... (PID:1584): Clearing online redo logfile 1 /u01/app/oracle/oradata/XFF/redo01.log .... (PID:1584): Clearing online redo logfile 2 ...继续阅读 (101)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：存储故障,强制拉库报ORA-600 kcbzib_kcrsds_1处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]硬件故障,客户自行强制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. RESETLOGS after incomplete recovery UNTIL CHANGE 16456823130015 time .... (PID:1584): Clearing online redo logfile 1 /u01/app/oracle/oradata/XFF/redo01.log .... (PID:1584): Clearing online redo logfile 2 ...继续阅读 (75)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 19c 断电异常恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]19.3数据库由于异常断电,导致数据库无法启动，报ORA-600 ktbair2: illegal inheritance,ORA-600 6101等错误2023-01-02T22:01:37.310225+08:00 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_pr0l_3788.trc: ORA-10562: Error occurred while applying redo to data block (file# 10, block# 399386) ORA-10564: tablespace DATA ORA-01110: data file 10: 'D:\ORADATA\DATA04.ORA' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 81882 ORA-00600: internal error code, arguments: [ktbair2: illegal ...继续阅读 (72)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 19c 断电异常恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]19.3数据库由于异常断电,导致数据库无法启动，报ORA-600 ktbair2: illegal inheritance,ORA-600 6101等错误2023-01-02T22:01:37.310225+08:00 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_pr0l_3788.trc: ORA-10562: Error occurred while applying redo to data block (file# 10, block# 399386) ORA-10564: tablespace DATA ORA-01110: data file 10: 'D:\ORADATA\DATA04.ORA' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 81882 ORA-00600: internal error code, arguments: [ktbair2: illegal ...继续阅读 (73)