ORA-00742: 日志读取在线程 %d 序列 %d 块 %d 中检测到写入丢失情况----惜分飞

标题：ORA-00742: 日志读取在线程 %d 序列 %d 块 %d 中检测到写入丢失情况

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

由于主机异常断电，导致oracle数据库无法正常启动,数据库启动报错ORA-07445 kdxlin,ORA-01172,ORA-00312,ORA-00742等错误

Fri Nov 25 11:24:53 2022

alter database open

Beginning crash recovery of 1 threads

 parallel recovery started with 15 processes

Started redo scan

Completed redo scan

 read 900 KB redo, 386 data blocks need recovery

Started redo application at

 Thread 1: logseq 93214, block 60163

Recovery of Online Redo Log: Thread 1 Group 1 Seq 93214 Reading mem 0

  Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\XFF\REDO01.LOG

Completed redo application of 0.46MB

Fri Nov 25 11:25:02 2022

Hex dump of (file 3, block 208) in trace file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p004_1988.trc

Reading datafile 'D:\APP\ADMINISTRATOR\ORADATA\XFF\UNDOTBS01.DBF' for corruption at rdba: 0x00c000d0 (file 3, block 208)

Reread (file 3, block 208) found valid data

Hex dump of (file 3, block 208) in trace file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p004_1988.trc

Repaired corruption at (file 3, block 208)

Hex dump of (file 3, block 152) in trace file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p004_1988.trc

Reading datafile 'D:\APP\ADMINISTRATOR\ORADATA\XFF\UNDOTBS01.DBF' for corruption at rdba: 0x00c00098 (file 3, block 152)

Reread (file 3, block 152) found same corrupt data (logically corrupt)

RECOVERY OF THREAD 1 STUCK AT BLOCK 152 OF FILE 3

Fri Nov 25 11:25:02 2022

Hex dump of (file 3, block 6859) in trace file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p001_19268.trc

Reading datafile 'D:\APP\ADMINISTRATOR\ORADATA\XFF\UNDOTBS01.DBF' for corruption at rdba: 0x00c01acb (file 3, block 6859)

Reread (file 3, block 6859) found same corrupt data (logically corrupt)

Fri Nov 25 11:25:13 2022

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p010_7024.trc  (incident=224379):

ORA-07445: 出现异常错误: 核心转储 [kdxlin()+4432] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x14306B54A] [UNABLE_TO_READ] []

Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\incident\incdir_224379\XFF_p010_7024_i224379.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Nov 25 11:25:13 2022

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p005_12036.trc  (incident=224343):

ORA-07445: 出现异常错误: 核心转储 [kdxlin()+4432] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x14306B54A] [UNABLE_TO_READ] []

Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\incident\incdir_224343\XFF_p005_12036_i224343.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Nov 25 11:25:18 2022

Sweep [inc][224379]: completed

Sweep [inc][224343]: completed

Sweep [inc2][224379]: completed

Sweep [inc2][224343]: completed

RECOVERY OF THREAD 1 STUCK AT BLOCK 6859 OF FILE 3

Fri Nov 25 11:25:33 2022

Slave exiting with ORA-1172 exception

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p004_1988.trc:

ORA-01172: 线程 1 的恢复停止在块 152 (在文件 3 中)

ORA-01151: 如果需要, 请使用介质恢复以恢复块和还原备份

Fri Nov 25 11:25:34 2022

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p001_19268.trc:

ORA-10388: parallel query server interrupt (failure)

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p001_19268.trc:

ORA-10388: parallel query server interrupt (failure)

Fri Nov 25 11:25:38 2022

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p010_7024.trc:

ORA-00742: 日志读取在线程 %d 序列 %d 块 %d 中检测到写入丢失情况

ORA-00312: 联机日志 1 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\XFF\REDO01.LOG'

ORA-00607: 当更改数据块时出现内部错误

ORA-00602: 内部编程异常错误

ORA-07445: 出现异常错误: 核心转储 [kdxlin()+4432] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x14306B54A] [UNABLE_TO_READ] []

Fri Nov 25 11:25:41 2022

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p005_12036.trc  (incident=224344):

ORA-01578: ORACLE 数据块损坏 (文件号 27, 块号 520567)

ORA-01110: 数据文件 27: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\POWERMPP.DBF'

ORA-10564: tablespace POWERMPP

ORA-01110: 数据文件 27: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\POWERMPP.DBF'

ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 89776

ORA-00607: 当更改数据块时出现内部错误

ORA-00602: 内部编程异常错误

ORA-07445: 出现异常错误: 核心转储 [kdxlin()+4432] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x14306B54A] [UNABLE_TO_READ] []

Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\incident\incdir_224344\XFF_p005_12036_i224344.trc

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p005_12036.trc:

ORA-01578: ORACLE 数据块损坏 (文件号 27, 块号 520567)

ORA-01110: 数据文件 27: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\POWERMPP.DBF'

ORA-10564: tablespace POWERMPP

ORA-01110: 数据文件 27: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\POWERMPP.DBF'

ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 89776

ORA-00607: 当更改数据块时出现内部错误

ORA-00602: 内部编程异常错误

ORA-07445: 出现异常错误: 核心转储 [kdxlin()+4432] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x14306B54A] [UNABLE_TO_READ] []

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p010_7024.trc  (incident=224380):

ORA-01578: ORACLE 数据块损坏 (文件号 26, 块号 227101)

ORA-01110: 数据文件 26: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\POWERMSP.DBF'

ORA-10564: tablespace POWERMSP

ORA-01110: 数据文件 26: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\POWERMSP.DBF'

ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 99375

ORA-00607: 当更改数据块时出现内部错误

ORA-00602: 内部编程异常错误

ORA-07445: 出现异常错误: 核心转储 [kdxlin()+4432] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x14306B54A] [UNABLE_TO_READ] []

Fri Nov 25 11:25:51 2022

Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\incident\incdir_224380\XFF_p010_7024_i224380.trc

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_p010_7024.trc:

ORA-01578: ORACLE 数据块损坏 (文件号 26, 块号 227101)

ORA-01110: 数据文件 26: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\POWERMSP.DBF'

ORA-10564: tablespace POWERMSP

ORA-01110: 数据文件 26: 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\POWERMSP.DBF'

ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 99375

ORA-00607: 当更改数据块时出现内部错误

ORA-00602: 内部编程异常错误

ORA-07445: 出现异常错误: 核心转储 [kdxlin()+4432] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x14306B54A] [UNABLE_TO_READ] []

Fri Nov 25 11:25:54 2022

Aborting crash recovery due to slave death, attempting serial crash recovery

Beginning crash recovery of 1 threads

Started redo scan

Completed redo scan

 read 900 KB redo, 386 data blocks need recovery

Started redo application at

 Thread 1: logseq 93214, block 60163

Recovery of Online Redo Log: Thread 1 Group 1 Seq 93214 Reading mem 0

  Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\XFF\REDO01.LOG

Hex dump of (file 3, block 6743) in trace file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_ora_4172.trc

Reading datafile 'D:\APP\ADMINISTRATOR\ORADATA\XFF\UNDOTBS01.DBF' for corruption at rdba: 0x00c01a57 (file 3, block 6743)

Reread (file 3, block 6743) found same corrupt data (logically corrupt)

RECOVERY OF THREAD 1 STUCK AT BLOCK 6743 OF FILE 3

Fri Nov 25 11:26:09 2022

Aborting crash recovery due to error 1172

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_ora_4172.trc:

ORA-01172: 线程 1 的恢复停止在块 6743 (在文件 3 中)

ORA-01151: 如果需要, 请使用介质恢复以恢复块和还原备份

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFF\XFF\trace\XFF_ora_4172.trc:

ORA-01172: 线程 1 的恢复停止在块 6743 (在文件 3 中)

ORA-01151: 如果需要, 请使用介质恢复以恢复块和还原备份

ORA-1172 signalled during: alter database open...

尝试人工recover恢复,报ORA-00283 ORA-00742 ORA-00312错误

SQL> recover database;

ORA-00283: 恢复会话因错误而取消

ORA-00742: 日志读取在线程 %d 序列 %d 块 %d 中检测到写入丢失情况

ORA-00312: 联机日志 1 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\XFF\REDO01.LOG'

通过特殊这里之后recover库成功

SQL> recover database until cancel;

ORA-00279: 更改 47073228694 (在 11/25/2022 08:11:15 生成) 对于线程 1 是必需的

ORA-00289: 建议:

D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\XFF\ARCHIVELOG\2022_11_25\O1_MF_1_932

14_%U_.ARC

ORA-00280: 更改 47073228694 (用于线程 1) 在序列 #93214 中

 

 

指定日志: {<RET>=suggested | filename | AUTO | CANCEL}

D:\APP\ADMINISTRATOR\ORADATA\XFF\REDO01.LOG

已应用的日志。

完成介质恢复。

打开数据库报ORA-600 2662错误

---

使用oracle patch scn工具快速修改 open库成功

---

SQL> startup mount pfile='d:/pfile.txt'

ORACLE 例程已经启动。

 

Total System Global Area       1603411968 bytes

Fixed Size                        2281656 bytes

Variable Size                  1191186248 bytes

Database Buffers                402653184 bytes

Redo Buffers                      7290880 bytes

数据库装载完毕。

SQL> ALTER DATABASE OPEN;

 

数据库已更改。

然后逻辑导出数据,导入新库,完成数据迁移工作

• ora-600 kcratr_scan_lastbwr
• 又一例ORA-600 kcratr_nab_less_than_odr
• ORA-600 kcratr_scan_lastbwr 恢复
• ORA-00322 ORA-00312恢复
• ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified 恢复思路
• ORA-00600 [2662]和ORA-00600 [4194]恢复
• Patch SCN工具快速解决ORA-600 2662问题
• ORA-00742 ORA-00312 故障恢复
• Oracle Recovery Tools 解决ORA-600 3020故障
• recover database 报kcbs_dump_adv_state恢复
• 12c启动报kcratr_nab_less_than_odr
• ORA-600 3600恢复—-resetlogs scn异常