1 2 Previous Next 23 Replies Latest reply on Sep 21, 2005 3:41 PM by The Human Fly Go to original post
      • 15. Re: Out of Space Condition Destroys Database?
        376714
        Hi MikeL,
        Mon Sep 19 10:43:00 2005
        Errors in file d:\oracle\admin\orcld\udump\orcld_ora_2652.trc:
        ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [], [], [], []
        maybe you should look what's in the file "d:\oracle\admin\orcld\udump\orcld_ora_2652.trc" ? there is usually more info into those specific files.

        Furthermore when you get "ORA-00600: internal error code, ...", you should open a TAR on metalink. Those internal errors are often related to bugs. And it's really hard to find a wakthrough without Oracle's help.

        Regards,

        Yoann.
        • 16. Re: Out of Space Condition Destroys Database?
          The Human Fly
          see if this could help you
          =========

          Doc ID:      Note:248718.1
          Subject:      ORA-600 [kcratr1_lostwrt]
          Type:      REFERENCE
          Status:      PUBLISHED
               
          Content Type:      TEXT/X-HTML
          Creation Date:      17-SEP-2003
          Last Revision Date:      11-AUG-2005


          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:

          This could suggest a hardware/OS problem.

          There is every chance that a restore will be required in order to stop this
          error occuring, although recovery may well resolve the issue:-

          Do the following:-

          startup mount;
          recover database; => assuming you get "Media recovery complete" then...
          alter database open;

          If this fails to resolve the error then contact Oracle Support Services
          and provide all trace files and alert log.

          Known issues:
          =====
          • 17. Re: Out of Space Condition Destroys Database?
            455283
            I have looked through the trace files (there is one for every time oracle tried to start itself), but there isnt anything there that gives me much of a clue. At this point I am just trying to establish that the problem was caused by the system running out of space. The system is being rebuilt from our production db so we can continue to move ahead, I just want to try to ensure there is no other simple explaination.
            • 18. Re: Out of Space Condition Destroys Database?
              455283
              Thanks Jaffar, that actually helps alot. It does indeed suggest that a disk write did not happen. Hopefully the dba has saved all of the related files as there is a fair amount of development work that can be saved.
              • 19. Re: Out of Space Condition Destroys Database?
                455427
                The following id from note 248718.1 on Metalink:

                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:

                This could suggest a hardware/OS problem.

                There is every chance that a restore will be required in order to stop this
                error occuring, although recovery may well resolve the issue:-

                Do the following:-

                startup mount;
                recover database; => assuming you get "Media recovery complete" then...
                alter database open;

                If this fails to resolve the error then contact Oracle Support Services
                and provide all trace files and alert log.

                Known issues:
                .
                • 20. Re: Out of Space Condition Destroys Database?
                  66787
                  ORA-600 usually means database corruption. If you have metalink access you can serach what the parameters means next to the ORA-600 error
                  Thanks
                  Shyam
                  • 21. Re: Out of Space Condition Destroys Database?
                    The Human Fly
                    ORA-600 usually means database corruption.
                    Absolutely not. This could cause due to number of factors.

                    Jaffar
                    • 22. Re: Out of Space Condition Destroys Database?
                      317243
                      Take a look at Metalink note 248718.1.

                      Basically, you can try this:

                      startup mount;
                      recover database; => assuming you get "Media recovery complete" then...
                      alter database open;

                      If this fails to resolve the error then contact Oracle Support Services
                      and provide all trace files and alert log.


                      HTH. For what it's worth, your DBA really should be monitoring this and doing the research. -Kevin
                      • 23. Re: Out of Space Condition Destroys Database?
                        The Human Fly
                        Kevin sorry to say, but, this metalink reference has been already given by couple of guys here.

                        Jaffar
                        1 2 Previous Next