Oracle data Recovery encounters ora-00600[3705] Solution

Trying to recover a database

The code is as follows

C:\Documents and Settings\administrator>set oracle_sid=telnet C:\Documents and Settings\administrator>sqlplus/nolog Sql*plus:release 9.2.0.1.0-production on Sunday May 25 13:04:29 2014 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Sql> Conn/as SYSDBA is connected. Sql> select Open_mode from V$database; Open_mode ---------- Mounted sql> ALTER DATABASE open; ALTER DATABASE Open * ERROR is on line 1th: ORA-01113: File 2 requires media recovery ORA-01110: Data file 2: ' E:\ORACLE\ORADATA\TELNET\UNDOTBS01.DBF ' sql> Recover database; ORA-00283: Recovery session canceled due to error ORA-00322: Log 2 (thread 1) is not the current copy ORA-00312: Online log 2 thread 1: ' E:\ORACLE\ORADATA\TELNET\REDO02.LOG ' Redo exception, trying to start the database with the _allow_resetlogs_corruption parameter sql> startup Mount Pfile= ' C:\pfile.txt ' The ORACLE routine has started. Total System Global area 126950220 bytes Fixed Size 453452 bytes Variable Size 109051904 bytes Database buffers 16777216 bytes Redo buffers 667648 bytes Database loading complete. sql> recover database until cancel; ORA-00279: Change 66763056 (generated at 05/12/2014 09:50:10) is required for thread 1 ORA-00289: Suggestion: E:\ORACLE\ORA92\RDBMS\ARC00312.001 ORA-00280: Change 66763056 for thread 1 is in sequence # 312 Specify log: {<ret>=suggested | AUTO | CANCEL} Cancel ORA-01547: Warning: RECOVER successful but OPEN Resetlogs will receive the following error ORA-01194: File 1 requires more recovery to maintain consistency ORA-01110: Data file 1: ' E:\ORACLE\ORADATA\TELNET\SYSTEM01.DBF '

ORA-01112: Media Recovery not started

The code is as follows

sql> ALTER DATABASE open resetlogs; ALTER DATABASE open Resetlogs * ERROR is on line 1th: ORA-03113: End of file for communication channel View Alert Log Sun May 25 15:35:02 2014 ALTER DATABASE RECOVER CANCEL ORA-1547 signalled During:alter DATABASE RECOVER CANCEL ... Sun May 25 15:35:02 2014 ALTER DATABASE RECOVER CANCEL ORA-1112 signalled During:alter DATABASE RECOVER CANCEL ... Sun May 25 15:35:09 2014 ALTER DATABASE open Resetlogs Resetlogs is being done without consistancy checks. This could result In a corrupted database. The database should be recreated. Resetlogs after incomplete recovery UNTIL change 66763056 Resetting Resetlogs activation ID 0 (0x0) Sun May 25 15:35:20 2014 assigning activation ID 2117757301 (0x7e3a6975) Sun May 25 15:35:20 2014 Errors in file e:\oracle\admin\telnet\bdump\telnet_lgwr_12140.trc: Ora-00600:internal error code, arguments: [3705], [1], [1], [1], [1], [], [], [] Sun May 25 15:35:56 2014 Errors in file e:\oracle\admin\telnet\bdump\telnet_lgwr_12140.trc: Ora-00600:internal error code, arguments: [3705], [1], [1], [1], [1], [], [], [] Lgwr:terminating instance due to error 600 Instance terminated by LGWR, PID = 12140 Create control file Continue restore sql> recover database until cancel; ORA-00283: Recovery session canceled due to error ORA-00600: Internal error code, parameters: [2130], [0], [1], [2], [], [], [], [] sql> ALTER DATABASE backup Controlfile to trace as ' c:\ctl.txt ';

The database has changed.

The code is as follows

sql> ALTER DATABASE open; ALTER DATABASE Open * ERROR is on line 1th: ORA-03113: End of file for communication channel Sql> Startup Nomount The ORACLE routine has started. Total System Global area 126950220 bytes Fixed Size 453452 bytes Variable Size 109051904 bytes Database buffers 16777216 bytes Redo buffers 667648 bytes Sql> CREATE controlfile Reuse DATABASE "TELNET" Noresetlogs Noarchivelog 2 Maxlogfiles 50 3 Maxlogmembers 5 4 Maxdatafiles 100 5 Maxinstances 1 6 Maxloghistory 226 7 LOGFILE 8 GROUP 1 ' E:\ORACLE\ORADATA\TELNET\REDO01.LOG ' SIZE 100M, 9 GROUP 2 ' E:\ORACLE\ORADATA\TELNET\REDO02.LOG ' SIZE 100M, GROUP 3 ' E:\ORACLE\ORADATA\TELNET\REDO03.LOG ' SIZE 100M One datafile ' E:\ORACLE\ORADATA\TELNET\SYSTEM01.DBF ', ' E:\ORACLE\ORADATA\TELNET\UNDOTBS01.DBF ', ' E:\ORACLE\ORADATA\TELNET\CWMLITE01.DBF ', ' E:\ORACLE\ORADATA\TELNET\DRSYS01.DBF ', ' E:\ORACLE\ORADATA\TELNET\EXAMPLE01.DBF ', ' E:\ORACLE\ORADATA\TELNET\INDX01.DBF ', ' E:\ORACLE\ORADATA\TELNET\ODM01.DBF ', ' E:\ORACLE\ORADATA\TELNET\TOOLS01.DBF ', ' E:\ORACLE\ORADATA\TELNET\USERS01.DBF ', ' E:\ORACLE\ORADATA\TELNET\XDB01.DBF ' CHARACTER SET ZHS16GBK 23;

Control file created

The code is as follows
sql> Recover database; ORA-00283: Recovery session canceled due to error ORA-00264: No Recovery required sql> ALTER DATABASE open;

The database has changed.

Contact: Mobile Phone (13429648788) QQ (107644445)

Link: http://www.xifenfei.com/5338.html

Title: Database recovery Encounters ora-00600[3705]

Author: Xi-fei © Copyright [Article allows reprint, but must be linked to the source address, or to investigate legal liability.]