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

最新推荐文章于 2025-10-14 11:30:09 发布

原创最新推荐文章于 2025-10-14 11:30:09 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #oracle

本文记录了Oracle数据库因主机故障导致启动失败，详细描述了crash recovery过程，包括ORACLE错误ORA-07445、ORA-01172、ORA-00312和数据修复步骤。重点讨论了数据文件损坏、redo log应用问题及后续手动恢复和数据库打开失败的解决方法。

由于主机异常断电，导致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;

数据库已更改。

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