联系：手机/微信(+86 17813235971) QQ(107644445)
标题：ORA-00600 [2662]和ORA-00600 [4194]恢复
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
数据库启动报ORA-600 2662
Sat Dec 26 19:34:05 2020 alter database open Beginning crash recovery of 1 threads parallel recovery started with 7 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 24, block 2, scn 2621149392 Recovery of Online Redo Log: Thread 1 Group 3 Seq 24 Reading mem 0 Mem# 0: E:\ORACLE\APP\ADMINISTRATOR\ORADATA\xff\REDO03.LOG Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 24, block 3, scn 2621169394 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Sat Dec 26 19:34:06 2020 Thread 1 advanced to log sequence 25 (thread open) Thread 1 opened at log sequence 25 Current log# 1 seq# 25 mem# 0: E:\ORACLE\APP\ADMINISTRATOR\ORADATA\xff\REDO01.LOG Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Dec 26 19:34:06 2020 SMON: enabling cache recovery Errors in file e:\oracle\app\administrator\diag\rdbms\xff\xff\trace\xff_ora_5812.trc (incident=110636): ORA-00600: 内部错误代码, 参数: [2662], [0], [2621169401], [0], [2621591939], [4194545], [], [], [], [], [], [] Errors in file e:\oracle\app\administrator\diag\rdbms\xff\xff\trace\xff_ora_5812.trc: ORA-00704: 引导程序进程失败 ORA-00704: 引导程序进程失败 ORA-00600: 内部错误代码, 参数: [2662], [0], [2621169401], [0], [2621591939], [4194545], [], [], [], [], [], [] Errors in file e:\oracle\app\administrator\diag\rdbms\xff\xff\trace\xff_ora_5812.trc: ORA-00704: 引导程序进程失败 ORA-00704: 引导程序进程失败 ORA-00600: 内部错误代码, 参数: [2662], [0], [2621169401], [0], [2621591939], [4194545], [], [], [], [], [], [] Error 704 happened during db open, shutting down database USER (ospid: 5812): terminating the instance due to error 704 Instance terminated by USER, pid = 5812 ORA-1092 signalled during: alter database open... opiodr aborting process unknown ospid (5812) as a result of ORA-1092 Sat Dec 26 19:34:10 2020 ORA-1092 : opitsk aborting process
对应的trace文件内容,主要在查询undo$表触发ORA-600 2662错误
通过修改scn,解决ORA-600 2662错误之后,数据库启动报ORA-600 4194
Sat Dec 26 20:13:28 2020 SMON: enabling tx recovery Database Characterset is ZHS16GBK Trace dumping is performing id=[cdmp_20201226201328] No Resource Manager plan active Errors in file e:\oracle\app\administrator\diag\rdbms\xff\xff\trace\xff_smon_8104.trc (incident=114188): ORA-00600: internal error code, arguments: [4194], [], [ Incident details in: e:\oracle\app\administrator\diag\rdbms\xff\xff\incident\incdir_114188\xff_smon_8104_i114188.trc Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x470E9BAC] [PC:0x6F21343, ___dyn_tls_init_callback()+111576860] Sat Dec 26 20:13:29 2020 Errors in file e:\oracle\app\administrator\diag\rdbms\xff\xff\cdump\xffcore.log ORA-07445: caught exception [ACCESS_VIOLATION] at [___dyn_tls_init_callback()+111576860] [0x06F21343] Doing block recovery for file 3 block 3121 Resuming block recovery (PMON) for file 3 block 3121 Block recovery from logseq 12, block 73 to scn 3221225727 Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0 Mem# 0: E:\ORACLE\APP\ADMINISTRATOR\ORADATA\xff\REDO03.LOG Block recovery stopped at EOT rba 12.75.16 Block recovery completed at rba 12.75.16, scn 0.3221225724 Doing block recovery for file 3 block 176 Resuming block recovery (PMON) for file 3 block 176 Block recovery from logseq 12, block 73 to scn 3221225721 Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0 Mem# 0: E:\ORACLE\APP\ADMINISTRATOR\ORADATA\xff\REDO03.LOG Block recovery completed at rba 12.73.16, scn 0.3221225722 Errors in file e:\oracle\app\administrator\diag\rdbms\xff\xff\trace\xff_smon_8104.trc: ORA-01595: error freeing extent (3) of rollback segment (4)) ORA-00600: internal error code, arguments: [4194], [], [ Trace dumping is performing id=[cdmp_20201226201331] Sat Dec 26 20:13:31 2020 PMON (ospid: 5200): terminating the instance due to error 397 Instance terminated by PMON, pid = 5200
解决异常undo,数据库启动正常,导出数据
加我QQ
