Methods for Oracle database recovery caused by Operation errors

The following content mainly introduces the syntax for solving the Oracle database large recovery caused by an incorrect operation, that is, before recreating the control file and the control file, back up controlfile and online redolog.

Reference

 
 

  
  
Create controlfile reuse set database "LDBRA"  
  
  
MAXINSTANCES 8  
  
  
MAXLOGHISTORY 1  
  
  
MAXLOGFILES 16  
  
  
MAXLOGMEMBERS 3  
  
  
MAXDATAFILES 100  
  
  
Datafile  
  
  
'/ora10g/app/oradata/ldbra/system01.dbf',  
  
  
'/ora10g/app/oradata/ldbra/undotbs01.dbf',  
  
  
'/ora10g/app/oradata/ldbra/sysaux01.dbf',  
  
  
'/ora10g/app/oradata/ldbra/users01.dbf',  
  
  
'/ora10g/app/oradata/ldbra/example01.dbf',  
  
  
'/ora10g/app/product/10.2.0/db_1/dbs/ company.dbf',  
  
  
'/ora10g/app/product/10.2.0/db_1/dbs/streams.dbf'  
  
  
LOGFILE GROUP 1 ('/ora10g/app/oradata/ldbra/redo01.log')
 SIZE 51200K,  
  
  
GROUP 2 ('/ora10g/app/oradata/ldbra/redo02.log')
 SIZE 51200K,  
  
  
GROUP 3 ('/ora10g/app/oradata/ldbra/redo03.log') 
SIZE 51200K RESETLOGS;  
 
 

Using the above statements to solve the Oracle database large recovery operation caused by an incorrect operation seems to have been successfully rebuilt! However, an error was reported during recover!

Reference

 
 

  
  
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;  
  
  
ORA-00283: recovery session canceled due to errors  
  
  
ORA-00600: internal error code, arguments: [kcvhvdf_1], 
[], [], [], [], [], [],  
  
  
[]   
 
 

We can see that the control file is reset by dbid during reconstruction.

Reference

 
 

  
  
SQL> select dbid from v$database;  
  
  
DBID  
  
  
1498845164  
 
 

The problem seems to have lost a clue here. Haha, copy back the backup control file to replace the just-created control file. Because I use the resetlog option to create a control file, in theory, it should reset redolog, that is, re-create redolog. However, using this option currently does result in a ORA-01227 error. Incredible! Later, it may be related to the dbid in the data file being 0. So we use the ultimate repair method, bbed! First, reset the dbid of all data files to 1488207495 using the bbed tool, and then mark the fuzzy mark as 0x2000 because the database is terminated abnormally by the ckpt process, mark it as 0x2000, indicating that the database is shut down immediate). After using the above method, the control file is successfully created!

Reference

 
 

  
  
SQL> STARTUP NOMOUNT  
  
  
CREATE CONTROLFILE REUSE DATABASE "LDBRA" RESETLOGS 
ARCHIVELOG  
  
  
MAXLOGFILES 16  
  
  
MAXLOGMEMBERS 3  
  
  
MAXDATAFILES 100  
  
  
MAXINSTANCES 8  
  
  
MAXLOGHISTORY 292  
  
  
LOGFILE  
  
  
ORACLE instance started.  
  
  
Total System Global Area 1073741824 bytes  
  
  
Fixed Size 1271616 bytes  
  
  
Variable Size 461375680 bytes  
  
  
Database Buffers 608174080 bytes  
  
  
Redo Buffers 2920448 bytes  
  
  
GROUP 1 '/ora10g/app/oradata/ldbra/redo01.log' SIZE 50M,  
  
  
GROUP 2 '/ora10g/app/oradata/ldbra/redo02.log' SIZE 50M,  
  
  
GROUP 3 '/ora10g/app/oradata/ldbra/redo03.log' SIZE 50M  
  
  
-- STANDBY LOGFILE  
  
  
DATAFILE  
  
  
'/ora10g/app/oradata/ldbra/system01.dbf',  
  
  
'/ora10g/app/oradata/ldbra/undotbs01.dbf',  
  
  
'/ora10g/app/oradata/ldbra/sysaux01.dbf',  
  
  
'/ora10g/app/oradata/ldbra/users01.dbf',  
  
  
'/ora10g/app/oradata/ldbra/example01.dbf',  
  
  
'/ora10g/app/product/10.2.0/db_1/dbs/company.dbf',  
  
  
'/ora10g/app/product/10.2.0/db_1/dbs/streams.dbf'  
  
  
CHARACTER SET ZHS16GBK  
  
  
21 ;  
  
  
Control file created.  
 
 

Try to open a database in Oracle

 
 

  
  
SQL> alter database open RESETLOGS; 
 
 

When the database is suspended, the alert Log in the background displays a [2662] error!

Reference

 
 

  
  
SMON: enabling cache recovery  
  
  
Tue Mar 9 03:11:38 2010  
  
  
Errors in file /ora10g/app/admin/ldbra/udump/
ldbra_ora_13676.trc:  
  
  
ORA-00600: internal error code, arguments: 
[2662], [2268], [3799096903], [2268], [3799098345], 
[8388617], [], []  
  
  
Tue Mar 9 03:11:40 2010  
  
  
Errors in file /ora10g/app/admin/ldbra/udump/
ldbra_ora_13676.trc:  
  
  
ORA-00600: internal error code, arguments: [2662],
 [2268], [3799096903], [2268], [3799098345], [8388617],
 [], []  
  
  
Tue Mar 9 03:11:40 2010  
 
 

The above content is an introduction to the actual operations on the syntax reconstruction control file for Oracle Database large recovery caused by an incorrect operation.