ORA-00600 [2662] [] [] [] [] [] [] Error resolution

Today to the customer data recovery, found that the use of the hidden parameter _ allow_resetlogs_upload uption, the result of a 2662 error in ORA-00600.

The customer said that a data file CUUG was lost. DBF, there is only one cold backup (the result is that this data file is backed up ............ ###@￥ ...). When taking over the customer system, the dba has rebuilt the control file. Speechless ......

Copy the previous data files back and register the archived logs again. Error:

1. Prompt ORA-01547: warning: RECOVER succeeded but open resetlogs wocould get error below
2. ORA-01194: file 1 needs more recovery to be consistent
3. ORA-01110: data file 1: '/opt/Oracle/product/10.2.0/oradata/orcl1/system01.dbf'

Check the SCN of the data file:

1. SQL> select CHECKPOINT_CHANGE # from v $ datafile_header;
3. CHECKPOINT_CHANGE #
4. ------------------
5. 591931
6. 591931
7. 591931
8. 591931
9. 505927

Check the archived log:

1. /Opt/oracle/product/10.2.0/flash_recovery_area/ORCL1/archivelog/2012_05_19/o1_mf_00009_7vh78q75 _. arc 591800 591805
2. /Opt/oracle/product/10.2.0/flash_recovery_area/ORCL1/archivelog/2012_05_19/o1_mf_1_8_7vh78gwc _. arc 590306 591800
3. /Opt/oracle/product/10.2.0/flash_recovery_area/ORCL1/archivelog/2012_05_19/o1_mf_1_10_7v1_b2xs _. arc 591805 591931

It seems that normal recovery is useless... the archiving log is not continuous.

Enable hidden Parameters

SQL> alter system set "_ allow_resetlogs_uption" = true scope = spfile;

Try again to open the database and start to prompt ORA-00600 error.

1. Wed May 23 15:06:44 2012
2. SMON: enabling cache recovery
3. Wed May 23 15:06:44 2012
4. Errors in file/opt/oracle/product/10.2.0/admin/orcl1/udump/orcl1_ora_1_8.trc:
5. ORA-00600: internal error code, arguments: [2662], [0], [545944], [0], [590505], [4194313], [], []
6. Wed May 23 15:06:44 2012
7. Incremental checkpoint up to RBA [0x1. 3.0], current log tail at RBA [0x1. 3.0]
8. Wed May 23 15:06:44 2012
9. Errors in file/opt/oracle/product/10.2.0/admin/orcl1/udump/orcl1_ora_1_8.trc:
10. ORA-00600: internal error code, arguments: [2662], [0], [545944], [0], [590505], [4194313], [], []
11. Wed May 23 15:06:44 2012
12. Error 600 happened during db open, shutting down database
13. USER: terminating instance due to error 600.
14. Instance terminated by USER, pid = 4268

1 2 Next Page