Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


...

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

SYMPTOMS

Error on startup:
ORA-00600: internal error code, arguments: [3005], [1], [13145], [11812], [0], [0], [], [], [], [], [], []

CAUSE

ORA-00600 ([3005]) occurs due to a failure in the check for the start RBA of the online redo log files.

This can be caused by factors outside of Oracle such as an operating system or hardware crash; or during the recreation of the controlfile noresetlogs where online redo logs or threads has been omitted.
 

SOLUTION

1.  Check the current state of datafiles and online redo logs

a.  Compare SCN (checkpoint_change#) from datafile headers:

select status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, count(*), fuzzy from v$datafile_header
group by status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, fuzzy;

...