ORA-00600 [2662] troubleshooting

The client software cannot connect to the server. The following error message is sent when you view the database log information:

Tue Jun 25 25 12:02:52 CST 2013

Errors in file/home/Oracle/orabase/admin/ORACLE/bdump/oracle_q000_3529.trc:

ORA-00600: internal error code, arguments: [2662], [0], [91108808], [0], [91133612], [12605758], [], []

Tue Jun 25 25 12:02:55 CST 2013

Errors in file/home/oracle/orabase/admin/ORACLE/bdump/oracle_q000_3529.trc:

ORA-00600: internal error code, arguments: [2662], [0], [91108810], [0], [91133612], [12605758], [], []

ORA-00600: internal error code, arguments: [2662], [0], [91108808], [0], [91133612], [12605758], [], []

Tue Jun 25 25 12:02:56 CST 2013

Errors in file/home/oracle/orabase/admin/ORACLE/bdump/oracle_q000_3529.trc:

ORA-00600: internal error code, arguments: [2662], [0], [91108811], [0], [91133612], [12605758], [], []

ORA-00600: internal error code, arguments: [2662], [0], [91108810], [0], [91133612], [12605758], [], []

ORA-00600: internal error code, arguments: [2662], [0], [91108808], [0], [91133612], [12605758], [], []

Tue Jun 25 25 12:02:57 CST 2013

Errors in file/home/oracle/orabase/admin/ORACLE/bdump/oracle_q000_3529.trc:

ORA-00600: internal error code, arguments: [2662], [0], [91108812], [0], [91133612], [12605758], [], []

ORA-00600: internal error code, arguments: [2662], [0], [91108811], [0], [91133612], [12605758], [], []

ORA-00600: internal error code, arguments: [2662], [0], [91108810], [0], [91133612], [12605758], [], []

ORA-00600: internal error code, arguments: [2662], [0], [91108808], [0], [91133612], [12605758], [], []

Obtain the following information based on network information:

ORA-600 [2662] "Block SCN is ahead of Current SCN", indicating that the SCN of the Current database's data Block is earlier than the Current SCN, mainly compared with the dependent SCN stored in the UGA variable, if the current SCN is smaller than it, the database will generate this ORA-600 [2662] error. The error contains five parameters, which indicate different meanings,

ORA-600 [2662] [a] [B] [c] [d] [e]

Arg [a] Current SCN WRAP

Arg [B] Current SCN BASE

Arg [c] dependent SCN WRAP

Arg [d] dependent SCN BASE

Arg [e] Where present this is the DBA where the dependent SCN came from.

After reading the document, I found that the cause of this error is as follows:

1. Use the implicit parameter _ allow_resetlogs_resume uption to open the database.

2. The database cannot write Control Files Or redo log files due to hardware errors.

3. Recover the database partially due to an error

4. The control file is restored, but the recover database using backup controlfile is not used for restoration.

5. The _ DISABLE_LOGGING implicit parameter is set after the database crash.

6. Problems with DLM in the parallel server environment

According to the error message, its parameters B = 91108811, d = 91133612 indicate that the current SCN is indeed smaller than the dependent SCN, so this 600 error is generated. Therefore, the ADJUST_SCN event is used to adjust the current SCN so that it is greater than the dependent SCN. Then, ensure that the database can be exported from the entire database, and then re-create the database to import data. There are two ways to adjust SCN:

There are two common methods to improve SCN:

1. Use the immediate trace name method (in the database Open state)

Alter session set events 'immediate trace name ADJUST_SCN level x ';

2. Pass the 10015 event (unable to open the database, mount the status)

Alter session set events '10015 trace name adjust_scn level x ';

Note: level 1 is used to increase SCN 1 billion (1 billion) (1024*1024*1024). Generally, Level 1 is sufficient. It can also be adjusted according to the actual situation.

Upon inquiry, the person in charge on duty suspected that the database could not write Control Files Or redo log files due to hardware errors. Therefore, execute the following operations to resume opening:

SQL> startup mount

ORACLE instance started.

Total System Global Area 97588504 bytes

Fixed Size 451864 bytes

Variable Size 33554432 bytes

Database Buffers 62914560 bytes

Redo Buffers 667648 bytes

Database mounted.

SQL> alter session set events '10015 trace name adjust_scn level 1 ';

Session altered.

SQL> alter database open;

Database altered.

SQL>

Then, the business accounts log on to the database respectively to export the business data, and re-create the database to import the business data recovery service.