ora-00600 [2662] after recovery database

[Former Member]

Hi experts,

I recovered database for system copy but I got oracle error ORA-01092 : ORACLE instance terminated. Disconnection forced.

I checked oracle trace file and found error information

ORA-00600: internal error code, argument [2662] ....

I was known that error is different SCN through many internet pages.

so I applied

1. allowresetlogs_corruption=true

2. alter session set events '10015 trace name adjust_scn level 1' to level 10

but It was same error.

how can I do ??

[Former Member]

Hi,

What Oracle software version and patch level you on.

Mark

[Former Member]

Suggest you to restore again and recover your Database.

This is one of the best option in this worst case(without wasting your time).

Regards,

Nick Loy

[Former Member]

Hi Lee,

Just go through the below sap note.

[Note 582427 - Error due to inconsistent Oracle DDIC|https://service.sap.com/sap/support/notes/582427]

You might need to recreate the Oracle dictionary for a specific version.

Regards.

Rajesh Narkhede

[Former Member]

hi, Rajesh

thanks for your reply.

I checked Note 582427 - Error due to inconsistent Oracle DDIC.

but there is different arguments ([2662]=/[kkpofpcd1]) in the note.

I knew cause of this problem as I sad above.

I want to know how can I correct SCN consistency.

thanks again.

[Former Member]

Hi Lee,

What is your OS version ??

What is your database version ?

On what basis you are saying that SCN is not consistant ?

Please post the result of below commands

#sqlplus / as sysdba
SQL> SELECT FILE#,CHECKPOINT_CHANGE# FROM V$DATAFILE;

SQL> SELECT CHECKPOINT_CHANGE#,CURRENT_SCN FROM V$DATABASE;

If you have consistant backup then restoring again would be more easy task. It will save your time also...

Otherwise, attempting to start the database multiple time sometime correct this problem if the SCN difference is less.

Regards.

Rajesh Narkhede