Oracle data Recovery encounters ora-00600[3705] Solution

Source: Internet
Author: User
Tags error code


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





Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.