I got this off the Oracle Metalink website:
***********************************************
Note: For additional ORA-600 related information please read Note 146580.1
PURPOSE:
This article discusses the internal error "ORA-600 [kcratr1_lostwrt]",
what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.
ERROR:
ORA-600 [kcratr1_lostwrt]
VERSIONS:
versions 9.2 to 10.1
DESCRIPTION:
This error is raised during crash/media recovery.
When an instance is restarted following an instance crash, Oracle
carries out some checks against the last block that was written to disk
prior to the instance crash.
If Oracle finds an old block, then this suggests a lost write and the
error is raised.
FUNCTIONALITY:
Cache Redo Application
IMPACT:
INSTANCE FAILURE
POSSIBLE PHYSICAL CORRUPTION
SUGGESTIONS:
Submit the trace files and alert.log Oracle Support Services for further
analysis.
This could suggest a hardware/OS problem.
There is every chance that a recovery will be needed in order to resolve
this problem.
Oracle Support Services will advise on this once suitable evidence has
been provided from the trace files and alert log.
Known issues:
<Internal_Only>
ORA-600 [kcratr1_lostwrt] []
Versions: 9.2.x Source: kcra.c
===========================================================================
Meaning:
An expected block write to the OS has been lost.
---------------------------------------------------------------------------
Argument Description:
None
---------------------------------------------------------------------------
Explanation:
During crash/media recovery, we check the last block written to disk.
If an old block is found this error is raised because a write has been
lost.
---------------------------------------------------------------------------
Diagnosis:
Check the trace file, this will show the last expected BWR (Block Written
Record), and the version that was found on disk.
As the on disk version is older than the expected BWR this error is
rasied.
This would point to OS problems with the I/O subsystem.
Confirm OS is on recommended patch levels.
Advise OS checks to be performed as OS write[s] have been lost.
Take a backup of the current database before doing anything else.
Then perform a recovery from a backup. Given that this is a lost write to
the datafile, we should be able to do a complete recovery.
If the redo has also got problems, do a point-in-time recovery to a point
before the write[s] were lost maybe required.
If no backups or archived redo are available, then we may need to force
the instance up - in which case, the database will need to be rebuilt
through exp/imp.
***********************************************
-----Original Message-----
From: Bob Metelsky
[mailto:oracledba-ezmlmshield-x96645394.[Email address protected]
Sent: Friday, February 25, 2005 19:44
To: LazyDBA Discussion
Subject: Re: Error on startup - HELP
Check your file locations. I trust you have created new binary control
files on the new machine from the original db control file while it was
running on the old machine. Did you make an entry in /etc/oratab..? Check
your file locations hth bob
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."
butler Daniel wrote:
>hi, I have just copied a databse from one machine to another (both
>Solaris V880). The machoine I amtrying to start the copy database has
>previously run a copy of this database, but I am getting the following
>Eror message - anyone Any Ideas ?
>
>ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [],
[], []
>, [], []
>Current SQL statement for this session:
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
>
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page