Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003

    Unanswered: ORA-600 on db open

    Hi -

    We are trying to restore a copy of cold backup of a noarchivelog mode db in on a drp server. There were sessions connected when the instance was shutdown for the cold backup. We get the following error upon startup on the drp server

    ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [], [], [], []
    ORA-600 signalled during: ALTER DATABASE OPEN...

    Is there a workaround to open this drp copy of the db?


  2. #2
    Join Date
    Jul 2003
    ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
    Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:
    file corruption 
    failed data checks in memory 
    hardware, memory, or I/O errors 
    incorrectly restored files 
    The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.
    Action: Report this error to Oracle Support Services after gathering the following information:
    events that led up to the error 
    the operations that were attempted that led to the error 
    the conditions of the operating system and databases at the time of the error 
    any unusual circumstances that occurred before receiving the ORA-00600 message 
    contents of any trace files generated by the error 
    the relevant portions of the Alter files 
    Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Apr 2003
    Greenville, SC (USA)
    According to Metalink, this indicates a write or writes to the database was not completed prior to a database crash and are lost ...
    They recommend

    alter database recover
    alter database open

    this may not work in all cases but should be tried prior to restoring...


  4. #4
    Join Date
    May 2008
    tnx a lot... this worked for me when our development server crashed...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts