联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
12.1.0.1的由于硬件故障，恢复文件之后，导致redo写丢失，数据库数据库无法正常启动
报错ORA-00742 ORA-00312
Mon Feb 22 17:07:48 2021 alter database open Mon Feb 22 17:07:48 2021 Beginning crash recovery of 1 threads parallel recovery started with 3 processes Mon Feb 22 17:07:48 2021 Started redo scan Mon Feb 22 17:07:49 2021 Slave encountered ORA-10388 exception during crash recovery Mon Feb 22 17:07:49 2021 Slave encountered ORA-10388 exception during crash recovery Mon Feb 22 17:07:49 2021 Slave encountered ORA-10388 exception during crash recovery Mon Feb 22 17:07:51 2021 Aborting crash recovery due to error 742 Mon Feb 22 17:07:51 2021 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_4624.trc: ORA-00742: 日志读取在线程 1 序列 4035 块 44165 中检测到写入丢失情况 ORA-00312: 联机日志 3 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL12C\REDO03.LOG' Mon Feb 22 17:07:51 2021 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_4624.trc: ORA-00742: 日志读取在线程 1 序列 4035 块 44165 中检测到写入丢失情况 ORA-00312: 联机日志 3 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL12C\REDO03.LOG' ORA-742 signalled during: alter database open...
通过屏蔽一致性,强制resetlogs方式打开库报ORA-600 2662错误
Mon Feb 22 17:27:38 2021 Checker run found 17 new persistent data failures alter database open resetlogs Mon Feb 22 17:27:54 2021 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 102879654 Resetting resetlogs activation ID 762781739 (0x2d77202b) Mon Feb 22 17:27:59 2021 Setting recovery target incarnation to 4 Mon Feb 22 17:28:00 2021 Assigning activation ID 895702933 (0x35635795) Starting background process TMON Mon Feb 22 17:28:00 2021 TMON started with pid=26, OS id=4204 Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL12C\REDO01.LOG Successful open of redo thread 1 Mon Feb 22 17:28:00 2021 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Feb 22 17:28:00 2021 SMON: enabling cache recovery Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_4804.trc (incident=21657): ORA-00600: 内部错误代码, 参数: [2662], [0], [102879661], [0], [102879857], [20971648], [], [], [], [], [], [] Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\incident\incdir_21657\orcl12c_ora_4804_i21657.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Mon Feb 22 17:28:06 2021 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_4804.trc: ORA-00600: 内部错误代码, 参数: [2662], [0], [102879661], [0], [102879857], [20971648], [], [], [], [], [], [] Mon Feb 22 17:28:06 2021 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_4804.trc: ORA-00600: 内部错误代码, 参数: [2662], [0], [102879661], [0], [102879857], [20971648], [], [], [], [], [], [] Mon Feb 22 17:28:06 2021 Error 600 happened during db open, shutting down database USER (ospid: 4804): terminating the instance due to error 600
由于scn相差的不大，重启几次后，该问题解决，后续数据库启动报ORA-600 4193
Mon Feb 22 19:53:11 2021 Database Characterset is ZHS16GBK Starting background process SMCO Mon Feb 22 19:53:11 2021 SMCO started with pid=28, OS id=3236 Mon Feb 22 19:53:15 2021 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_smon_4460.trc: ORA-01595: 释放区 (2) 回退段 (1) 时出错 ORA-00600: 内部错误代码, 参数: [4193], [15352], [18655], [], [], [], [], [], [], [], [], [] Mon Feb 22 19:53:18 2021 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_1356.trc: ORA-00600: 内部错误代码, 参数: [4193], [15352], [18655], [], [], [], [], [], [], [], [], [] Error 600 happened during db open, shutting down database USER (ospid: 1356): terminating the instance due to error 600 Mon Feb 22 19:53:21 2021 Instance terminated by USER, pid = 1356 ORA-1092 signalled during: ALTER DATABASE OPEN...
处理异常undo之后，数据库启动正常，完成数据库恢复
加我QQ
