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

    Unanswered: ORA-600 on db open

    Hi -

    We are trying to restore a copy of cold backup of a noarchivelog mode db in 9.2.0.3 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?

    Thanks

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Code:
    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:
    
    timeouts 
    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
    Location
    Greenville, SC (USA)
    Posts
    1,155
    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...

    HTH
    Gregg

  4. #4
    Join Date
    May 2008
    Posts
    7
    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
  •