Monday, March 17, 2014


ORA-600 [3619] Unable To Start Database [ID 452405.1]

Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.2.0
This problem can occur on any platform.

Symptoms
Database will not start and terminates the instance startup with ORA-00600: internal error code,
arguments: [3619], [10], [0], [], [], [], [], [] error.

Changes
This is usually associated with a previous crash of the database for some reason.

Cause

Failure is in the Cache recovery component of the code.  The error points to the fact
that one or more of the database files needs more recovery, and that was not seen by the system at
mount, but then found when attempting to open.  Since one or more of the datafiles needs more
recovery to be consistent and the system missed that, it will not allow the database to open and raises this error.

Description of the error.

If no threads need recovery, then there should not be any files that need recovery. If there were,
then they should need media recovery and should be caught in the recovery code. If they are not caught in the recovery code,  raise the OERI:3619.

Solution

1)Make sure both instances are shutdown in RAC scenario.
2)Open one instance manually in mount state.
  startup mount
3)Apply recovery
  recover database;
4)If recovery completes then open instance.
  alter database open;
5)Instance should open and check status.
  select status from v$instance;
6)shutdown instance and then start as you normally would.

No comments:

Post a Comment