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 ... |