Next, redo error after the Open Database and the error ORA-00600: Internal error code, arguments: [2662].
The reason is that the resetlogs opens the database after _ allow_resetlogs_uption, we may encounter the ORA-00600 2662 error due to inconsistent SCN(Current SCN is smaller than undo block SCN).
Symptoms and solutions-this is an example of taking an exam on eygle.
Sun Dec 11 18:02:25 2005 errors in file/opt/Oracle/admin/Conner/udump/conner_ora_13349.trc:ORA-00600: Internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], []Sun Dec 11 18:02:27 2005At this point, we can adjust the SCN through Oracle internal events:
There are two common usage 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.
Level calculation rules:
ORA-00600: internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], []
ORA-00600: internal error code, arguments: [2662], [a], [b], [c], [d], [e], [], []
A cruuent SCN wrap B--CURRENT SCN base C--DEPENDENT SCN wrap D--DEPENDENT SCN base e -- where present this is the DBA where the dependent SCN came from.
D <1024*1024*1024 = 1073741824, the required level is: C * 4 + 1
D <1024*1024*1024*2 = 1073741824*2, the required level is: C * 4 + 2
You can also set the hidden shard number _ minimum_giga_scn to increase the current SCN at a high speed. The PSU after January 1, January 2012 contains the implicit sequence number _ external_scnrejection_threshold_hours. In this case, the implicit sequence number and 10015 events will expire.
Yan test link Zhou Liang DBA Practice strategy http://www.eygle.com/archives/2005/12/oracle_diagnostics_howto_deal_2662_error.html
Simply record a ORA-00600: Internal error code, arguments: [2662]